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);
}
SQL Query
Moderator: General Moderators
Re: SQL Query
echo out $SQLCODE and see what you get. Also, add
or die(mysql(error)); to your execute command.
or die(mysql(error)); to your execute command.
Re: SQL Query
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.
Talking about $RowName here. It gets the value "'','',''" (since $line is undefined) and you never change that.