MySQL error with dates

Question

MySQL tells me I have a wrong syntax, but I don't know where. Can anyone help me?

$dt = $xml->item->parameter[2];
$to = date('Y-m-d H:i:s',strtotime($dt));
$query = sprintf("select * from me,val where group_id=%s AND m_id= me_id AND time_stamp <= $to",mysql_real_escape_string($gid));
$result= mysql_query($query) or die(mysql_error());

while ($row=mysql_fetch_array($result)){

The parsing to a date works. Thanks in advance.

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '23:59:59' at line 1

Community · Accepted Answer · 2023-11-17 19:32:19Z

3

you have to put the date ($to) in single quotes:

"select * from me,val where group_id=%s AND m_id= me_id AND time_stamp <= '$to'"

to avoid these kind (and a lot of other) problems, you might want to think about using prepared statements (take a look at PDO or mysqli) instead of the old (and deprecated) mysql_*-functions.

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered Jul 10, 2012 at 10:08

oezi

51.9k10 gold badges102 silver badges119 bronze badges

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

2 Comments

Baloo Over a year ago

Thanks at first, it fixed that problem but brought me a knew. ^^ To be honest, I already had PDO in use but I couldn't find out how this "($row=mysql_fetch_array($result)" has to look like in PDO. May you can help me?

Quicksilver Over a year ago

$row = $result_object->fetch()

Quicksilver · Accepted Answer · 2012-07-10 10:35:44Z

1

$query = sprintf("select * from me,val where group_id=%s AND m_id= me_id AND time_stamp <= '$to'",mysql_real_escape_string($gid));

or

$query = sprintf("select * from me,val where group_id=%s AND m_id= me_id AND time_stamp <= %s",mysql_real_escape_string($gid),$to);

you should enclose date in single quotes

edited Jul 10, 2012 at 10:35

answered Jul 10, 2012 at 10:09

Quicksilver

2,7403 gold badges25 silver badges38 bronze badges

Collectives™ on Stack Overflow

MySQL error with dates

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related