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

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