Page 1 of 1

SQL Query

Posted: Wed Jan 28, 2009 2:51 pm
by hewstone
Hey guys,

I have the code below which inputs data in a database, however instead of inputted the values i want, it inputs the string: Is there someting wrong with $RowName?

$ColName = "Col1,Col2,Col3";
$RowName = "'$line[0]','$line[1]','$line[2]'";

$data = file_get_contents($table);
$rows = explode("\n", $data);
foreach($rows as $row){
$line = explode(',', $row);
$SQLCODE = "INSERT INTO TempData($ColName) VALUES($RowName)";
$rS = $db_conn->execute($SQLCODE);

}

Re: SQL Query

Posted: Wed Jan 28, 2009 3:04 pm
by califdon
echo out $SQLCODE and see what you get. Also, add
or die(mysql(error)); to your execute command.

Re: SQL Query

Posted: Wed Jan 28, 2009 3:37 pm
by requinix
You can't "prepare" a variable for use later. When you define it, that's when it gets a value - PHP won't go back and fill in the blanks.

Talking about $RowName here. It gets the value "'','',''" (since $line is undefined) and you never change that.