xml to mysql using php - urgent

Issue is have a "xml" file and I have created mysql database using php

and fatch data from "xml" file. MY table and all data placed

accordingly but I am facing problem with one atribute.

<ToLet Version="1.0" Agent="abc" Password="123" Date="20040813">
 <Property>
  <Refnumber>1.00</Refnumber> 
  <Number>1a</Number> 
  <Street>Madina Town</Street> 
  <Address3>St Johns Wood</Address3> 
  <Address4>London</Address4> 
  <Postcode>NW6 1HY</Postcode> 
  <Area>St Johns Wood</Area> 
  <Type>Conversion</Type> 
  <Beds>2.00</Beds> 
  <Receps>1.00</Receps> 
  <Garage>False</Garage> 
  <Parking>False</Parking> 
  <Garden>False</Garden> 
  <Balcony>True</Balcony> 
  <Floor>G</Floor> 
  <Available>29/02/2004</Available> 
  <Rent Per="Week">200.00</Rent> 
  <Description>Delightful 2 bed flat in sought after location close to 

all amenities</Description> 
  <Comments>Delightful 2 bed flat in sought after location close to all 

amenities</Comments> 
  <Photo1>abc_1_1.jpg</Photo1> 
  <Photo2>abc_1_2.jpg</Photo2> 
  <Photo3>abc_1_3.jpg</Photo3> 
  <Photo4>abc_1_4.jpg</Photo4> 
  <Photo5>abc_1_5.jpg</Photo5> 
  <Photo6>abc_1_6.jpg</Photo6> 
  <Photo7>abc_1_7.jpg</Photo7> 
  <Photo8>abc_1_8.jpg</Photo8> 
  <Photo9>abc_1_9.jpg</Photo9> 
  <Map /> 
  <Movie /> 
  <Url>http://www.rman.co.uk</Url> 
 </Property>
 <Property>
  <Refnumber>2.00</Refnumber> 
  <Number>1b</Number> 
  <Street>Gulburg</Street> 
  <Address3>St Johns Wood</Address3> 
  <Address4>London</Address4> 
  <Postcode>NW8</Postcode> 
  <Area>St Johns Wood</Area> 
  <Type>Conversion</Type> 
  <Beds>2.00</Beds> 
  <Receps>1.00</Receps> 
  <Garage>False</Garage> 
  <Parking>False</Parking> 
  <Garden>False</Garden> 
  <Balcony>False</Balcony> 
  <Floor>1</Floor> 
  <Available>29/09/2004</Available> 
  <Rent Per="Week">250.00</Rent> 
  <Description>Delightful 3 bed flat in new conversion. Close to all 

amenities</Description> 
  <Comments>Delightful 3 bed flat in new conversion. Close to all 

amenities</Comments> 
  <Photo1>abc_2_1.jpg</Photo1> 
  <Photo2>abc_2_2.jpg</Photo2> 
  <Photo3>abc_2_3.jpg</Photo3> 
  <Photo4>abc_2_4.jpg</Photo4> 
  <Photo5>abc_2_5.jpg</Photo5> 
  <Photo6>abc_2_6.jpg</Photo6> 
  <Photo7>abc_2_7.jpg</Photo7> 
  <Photo8>abc_2_8.jpg</Photo8> 
  <Photo9>abc_2_9.jpg</Photo9> 
  <Map /> 
  <Movie /> 
  <Url /> 
 </Property>
</ToLet>

PHP:

In this file all atribute readed because every thing same but one

atribute <Rent Per="Week">200.00</Rent> in different method and

<Rent Per="Week"> contian two conditions one is Rent per Week and other

will Rent per month.
<Rent Per="Week">200.00</Rent> in this lines we fatch 200.00 in our

databse but we also want to fatch "week" in our database.

We have write a php file to fatch data from XML to mySQL wich working

fine instead of <Rent Per="Week"> issue.

My PHP file code is as:

<?php
define("DB_HOST","localhost",TRUE); // database server name
define("DB_USER","root",TRUE); // database user
define("DB_PASS","1234",TRUE); // database user's password
define("DB_NAME","xml",TRUE); // database name

$TAG = "EXTRA";
$id = 0;
//Initialize the XML parser
$parser=xml_parser_create();

//Function to use at the start of an element
function start($parser,$element_name,$element_attrs)
{
	global $TAG; 
	
	switch($element_name)
	{
    	case "PROPERTY":
		echo "<br />[Property]";
		$TAG = "PROPERTY";
		break;    	
		case "REFNUMBER":
		$TAG = "REFNUMBER";
		break;		
		case "NUMBER":
		$TAG = "NUMBER";
		break;    	
		case "STREET":
		$TAG = "STREET";
		break;		
		case "ADDRESS3":
		$TAG = "ADDRESS3";
		break;    	
		case "ADDRESS4":
		$TAG = "ADDRESS4";
		break;		
		case "POSTCODE":
		$TAG = "POSTCODE";
		break;    	
		case "AREA":
		$TAG = "AREA";
		break;		
		case "TYPE":
		$TAG = "TYPE";
		break;    	
		case "BEDS":
		$TAG = "BEDS";
		break;		
		case "RECEPS":
		$TAG = "RECEPS";
		break;    	
		case "GARAGE":
		$TAG = "GARAGE";
		break;		
		case "PARKING":
		$TAG = "PARKING";
		break;    	
		case "GARDEN":
		$TAG = "GARDEN";
		break;		
		case "BALCONY":
		$TAG = "BALCONY";
		break;
		case "FLOOR":
		$TAG = "FLOOR";
		break;		
		case "AVAILABLE":
		$TAG = "AVAILABLE";
		break;
		case "RENT":
		$TAG = "RENT";
		break;		
		case "DESCRIPTION":
		$TAG = "DESCRIPTION";
		break;
		case "COMMENTS":
		$TAG = "COMMENTS";
		break;		
		case "PHOTO1":
		$TAG = "PHOTO1";
		break;
		case "PHOTO2":
		$TAG = "PHOTO2";
		break;		
		case "PHOTO3":
		$TAG = "PHOTO3";
		break;
		case "PHOTO4":
		$TAG = "PHOTO4";
		break;		
		case "PHOTO5":
		$TAG = "PHOTO5";
		break;
		case "PHOTO6":
		$TAG = "PHOTO6";
		break;		
		case "PHOTO7":
		$TAG = "PHOTO7";
		break;
		case "PHOTO8":
		$TAG = "PHOTO8";
		break;		
		case "PHOTO9":
		$TAG = "PHOTO9";
		break;
		case "MAP":
		$TAG = "MAP";
		break;		
		case "MOVIE":
		$TAG = "MOVIE";
		break;
		case "URL":
		$TAG = "URL";
		break;		
		
		default:
		$TAG = "EXTRA";
    }
}

//Function to use at the end of an element
function stop($parser,$element_name)
 {
 	 echo "";
  
 }

//Function to use when finding character data
function char($parser,$data)
{
	global $TAG; 
	global $id;

	require_once('mysql.class.php');

	if( !isset($db_obj) ) {
		$db_obj = new db; 
	}
		
	$db_conect = $db_obj->connect();

	if( $TAG != "EXTRA") {
		
		
		echo "<br />$data <font color=#006600 

size=2>[OK]</font>";
		
		
		if($TAG == "PROPERTY") {
			
			$sql = $db_obj->query("select max(id) as id 

from property ",$db_conect);
			if( $rs = $db_obj->fetch_array($sql) ) {
				$id = $rs['id'];
			}
			$id = $id + 1;
		
			$db_obj->query("insert into property (id) 

values('$id') ",$db_conect);
			
		}
		else if( $TAG == "REFNUMBER" || $TAG == "NUMBER" || 

$TAG == "STREET" || $TAG == "ADDRESS3" || $TAG == "ADDRESS4" || 
		$TAG == "POSTCODE" || $TAG == "AREA" || $TAG == "TYPE" 

|| $TAG == "BEDS" || $TAG == "RECEPS" || $TAG == "GARAGE" || 
		$TAG == "PARKING" || $TAG == "GARDEN" || $TAG == 

"BALCONY" || $TAG == "FLOOR" || $TAG == "AVAILABLE" || $TAG == "RENT"
		|| $TAG == "DESCRIPTION" || $TAG == "COMMENTS" || $TAG 

== "PHOTO1" || $TAG == "PHOTO2" || $TAG == "PHOTO3" || 
		$TAG == "PHOTO4" || $TAG == "PHOTO5" || $TAG == 

"PHOTO6" || $TAG == "PHOTO7" || $TAG == "PHOTO8" || $TAG == "PHOTO9" 
		|| $TAG == "MAP" || $TAG == "MOVIE" || $TAG == "URL" ) 

{
		
			$db_obj->query("update property set 

$TAG='$data' where id='$id' ",$db_conect);
		}
		
		$TAG = "EXTRA";
		
	}
	
}


//Specify element handler
xml_set_element_handler($parser,"start","stop");

//Specify data handler
xml_set_character_data_handler($parser,"char");

//Open XML file
$fp=fopen("rentman.xml","r");

//Read data
while ($data=fread($fp,4096))
  {
  xml_parse($parser,$data,feof($fp)) or 
  die (sprintf("XML Error: %s at line %d", 
  xml_error_string(xml_get_error_code($parser)),
  xml_get_current_line_number($parser)));
  }

//Free the XML parser
xml_parser_free($parser);

?>

PHP:

I also use a class for this purpose as below:

<?php

class db {


	function connect() {
		$die = false;
		$link = @mysql_connect(DB_HOST, DB_USER,DB_PASS) or 

($die = true);
				
		if($die){
					
			echo '<h3>Database connection error!!!</h3>';
			
			echo 'A connection to the Database could not be 

established.<br />';
			echo 'Please check your username, password, 

database name and host.<br />';
			echo 'Also make sure <i>mysql.class.php</i> is 

rightly configured!<br /><br />';
			
			exit();
		}
		
		mysql_select_db(DB_NAME);
		
		return $link;
	}

	// Returns an array that corresponds to the fetched row
	function fetch_array($query) {
		$query = mysql_fetch_array($query,MYSQL_ASSOC);
		return $query;
	} 
	// To Execute Sql Query
	function query($sql,$res) {
		$query = mysql_query($sql) or die(mysql_error());
		return $query;
	}
	// Retrieves the number of rows from a result set
	function num_rows($query) {
		$query = mysql_num_rows($query);
		return $query;
	}
	// Get the number of affected rows by the last INSERT, UPDATE 

or DELETE query
	function affected_rows($query) {
		$query =   mysql_affected_rows();
		return $query;
	}
	
}
?>

PHP:

Now in this situation I also want to fatch data of this attribute <Rent

Per="Week"> in my databse. In thi I want to store "week" in my databse.

For this purpose please write any quote within my quote and let me know

changes... I am waiting your reply