i cannot save to my database

knightneo · November 24th, 2006, 05:17 AM

i cannot save to my database, the username and the table name has the same value so i put the session username to $tblname but when i call the $tblname the output is The data was not save, is there something wrong to the command in the red text... anyone can explain to me my error? thanks...

<?

include 'config.php';

$dbname = 'log';
$tblname = $_SESSION['username'];

mysql_select_db("$dbname") or die ("<h3>Cannot select the Database.</h3>");
$date = date('Y-d-m');
$time = date('h:i:s A');

$request = "insert into '$tblname' values ('$date', '$time', '$time')";
$results = mysql_query($request);

if($results)
{
echo "The data was saved";
}
else
{
echo "<h3>There was an error. The data was not saved.</h3>";
}

?>

<html>
<body>
<br>
<br>
<form method = post action = page1.php>
<input type = 'submit' value = 'Back to Admin Page'>
</form>
</html>
</body>

akremedy · December 3rd, 2006, 02:18 AM

It doesn't look like you have defined the columns that you want to insert your values into:

$request = "INSERT INTO $tblname(col1,col2,col3) VALUES('$date','$time','$time')";

Does that help?

talk2leo · December 6th, 2006, 02:28 AM

first of all check code in ur config.php file
is it giving valid connection resource.if no then deacre it as global in config.php.(if u have already done this) then do the following

$request ="insert into username values($date, $time, $time)";

reply me if still having prob.

davidc2p · January 29th, 2007, 08:06 AM

INSERT INTO $tblname(col1,col2,col3) VALUES('$date','$time','$time') would be used to insert into target columns of the table.
If the table has 3 columns only: INSERT INTO $tblname VALUES('$date','$time','$time') will do.

Visit my page: http://www.webrickco.com