$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
Tuesday, July 21, 2009
Wednesday, July 15, 2009
HELP!!!!!
For any viewers that knows MySQL.... can you please help me with these errors?
"MySQL error number 1005 Cant create table 'tims.#sql17a8_c'(errno:121)"
It appears that when i try to create a foreign key for a table .... I've try many ways to solve it .. but it just wont work ...
Any suggestion will be much appreciated ... Thanks
"MySQL error number 1005 Cant create table 'tims.#sql17a8_c'(errno:121)"
It appears that when i try to create a foreign key for a table .... I've try many ways to solve it .. but it just wont work ...
Any suggestion will be much appreciated ... Thanks
Subscribe to:
Posts (Atom)