SQL Query
Posted: Wed Jan 28, 2009 2:51 pm
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);
}
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);
}