MySQL syntax help?

[DaveLinger]

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

[frijole]

you have to say where you are selecting from, ie which DB. and you don't need all the commas.

[DaveLinger]

I define which DB I'm selecting from in the connection code... as I said, the first code works, just not the second. So connection is not an issue, nor are commas.

[revraz]

What do you mean by "doesn't work"?

 

Does it error or not give you the result you expect?

[DaveLinger]

gives me a syntax error.

[revraz]

So I guess you're going to make me ask you to post the error....

[DaveLinger]

Never seen a generic SQL Syntax error before?

 

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

[DaveLinger]

looks like I had one too many commas, removed the one before "FROM" and it works

 

Solved.

[revraz]

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?

 

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