Tuesday, July 21, 2009

MySQL Help....!!!

$selectStateID = mysql_query("SELECT StateID FROM tims_state WHERE State_Name='$value[0]'");

$selectAreaID = mysql_query("SELECT AreaID FROM tims_area WHERE Area_Name='$value[1]'");

$selectDistrictID = mysql_query("SELECT DistrictID FROM tims_district WHERE District_Name='$value[2]'");

$resultInv = mysql_query("INSERT INTO ".$tableInv."(StateID,AreaID,DisctrictID) VALUES(".$selectStateID.",".$selectAreaID.",
".$selectDistrictID.")",$connect);


$result = mysql_query("INSERT INTO ".$table."($value1,$value2,$value3,$value4,$value5,$value6,$value7,
$value8,$value9,$value10,$value11,$value12)
VALUES (".$value[6].",".$value[3].",".$value[7].",
".$value[8].",".$value[9].",".$value[10].",
".$value[11].",".$value[12].",".$value[13].",".$value[14].",".$value[15].",
".$value[16].")",$connect);


Can anyone tell me what is wrong of those command??? relly need help for those who understand it ..... thanks

No comments:

Post a Comment