PHP MYSQL INSERT not working?

Question

<?php
require "dbconnect.php";
$resultno = mysql_query("SELECT `time` FROM syslog");

while($row = mysql_fetch_array($resultno))
 {
$mysqltime = $row['time'];
$timestamp = strtotime($mysqltime);
$update = date("Y-m-d H:i:s", $timestamp);
echo $update;
 }
$mysqlupdate = mysql_query("INSERT INTO (`datetime`) VALUES ('$update')");

The results stream by but no updates? I must be missing something...

Thanks

$mysqlupdate = mysql_query("INSERT INTO syslog (datetime) VALUES ('$update')"); Still no luck? Hmm.. — mrlayance
– mrlayance, Commented Jan 11, 2011 at 19:18
Could you tell me what kind of type do you have for datetime column in your mysql table ? — Paulraj
– Paulraj, Commented Jan 11, 2011 at 19:25
I see the problem, I am adding just new rows and not add to the end of each row... — mrlayance
– mrlayance, Commented Jan 11, 2011 at 19:32
Do you have time and datetime both fields in syslog table ? Brief about your table structure? — Paulraj
– Paulraj, Commented Jan 11, 2011 at 19:38

Paulraj · Accepted Answer · 2011-01-11 19:06:59Z

4

You have missed the table name in insert statement.

INSERT INTO tablename (`datetime`) VALUES ('$update')

answered Jan 11, 2011 at 19:06

Paulraj

3,4173 gold badges38 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

johngreen · Accepted Answer · 2011-01-11 19:05:55Z

0

You need to specify a table-name after INTO in the SQL query.

answered Jan 11, 2011 at 19:05

johngreen

2,7545 gold badges32 silver badges49 bronze badges

Comments

Samuel · Accepted Answer · 2011-01-11 19:07:23Z

0

Perhaps you should look at the UPDATE command instead of insert. If you are looking to update, you shouldn't be using insert.

answered Jan 11, 2011 at 19:07

Samuel

17.3k6 gold badges65 silver badges77 bronze badges

Comments

Divya Sankaran · Accepted Answer · 2014-02-03 21:16:50Z

0

Besides what @Paulraj correctly pointed out, you are also passing your php variable as a string.

It should be "INSERT INTO (datetime) VALUES ('" . $update . "')"

answered Feb 3, 2014 at 21:16

Divya Sankaran

154 bronze badges

Collectives™ on Stack Overflow

PHP MYSQL INSERT not working?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related