Jump to content

MySQL syntax help?


DaveLinger

Recommended Posts

Here's what IS working:

 

SELECT *, UNIX_TIMESTAMP(`starttime`) as starttime FROM wrlf_auction_config ORDER BY datetime DESC LIMIT 1

 

however, I also need to select endtime as a unix timestamp, and don't know how to tell it multiple things. For example, this doesn't work:

 

SELECT *, UNIX_TIMESTAMP(`starttime`) as starttime, UNIX_TIMESTAMP(`endtime`) as endtime, FROM wrlf_auction_config ORDER BY datetime DESC LIMIT 1

Link to comment
https://forums.phpfreaks.com/topic/90535-mysql-syntax-help/
Share on other sites

Never seen a generic SQL Syntax error before? :P

 

Problem with the querySELECT *, UNIX_TIMESTAMP(`starttime`) as starttime, UNIX_TIMESTAMP(`endtime`) as endtime, FROM wrlf_auction_config ORDER BY datetime DESC LIMIT 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wrlf_auction_config ORDER BY datetime DESC LIMIT 1' at line 1

Link to comment
https://forums.phpfreaks.com/topic/90535-mysql-syntax-help/#findComment-464161
Share on other sites

No such thing as a "Generic Syntax Error".

 

With that error, its telling you exactly where the error is.

 

Never seen a generic SQL Syntax error before? :P

 

Problem with the querySELECT *, UNIX_TIMESTAMP(`starttime`) as starttime, UNIX_TIMESTAMP(`endtime`) as endtime, FROM wrlf_auction_config ORDER BY datetime DESC LIMIT 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wrlf_auction_config ORDER BY datetime DESC LIMIT 1' at line 1

Link to comment
https://forums.phpfreaks.com/topic/90535-mysql-syntax-help/#findComment-464166
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.