Adding ORDER BY after variable in MySQL query

Question

I currently have this line of code, which works perfectly:

$data2 = mysql_query("SELECT * FROM notes WHERE HiveID=" . $HiveID) or die(mysql_error());

I want to reverse the order of my listing, so I tried adding the ORDER BY after WHERE. I tried the following code:

$data2 = mysql_query("SELECT * FROM notes WHERE HiveID=" . $HiveID  . "ORDER BY Date DESC") or die(mysql_error());

This code gave me the 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 'BY Date DESC' at line 1.

I am unaware of how I can get this to work, and any help will be greatly appreciated.

You know the MySQL extension has been deprecated, right? You should not be writing code with this extension. Use PDO or MySQLi instead — Phil
– Phil, Commented Dec 3, 2012 at 3:12

Ryan · Accepted Answer · 2012-12-03 03:10:36Z

4

You are missing a space after the open quotes.

Should be . $hive . " ORDER BY...

answered Dec 3, 2012 at 3:10

Ryan

1448 bronze badges

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

1 Comment

Michael Over a year ago

I though it was going to be something simple, but I didn't think it was something that small. Thank you for your help and very fast response.

NullPoiиteя · Accepted Answer · 2012-12-03 03:10:56Z

1

your query is HiveID=" . $HiveID . "ORDER which will be like 5ORDER (if hiveid is 5) so it wont give you result there must be a space before the ORDER try

"SELECT * FROM notes WHERE HiveID=" . $HiveID." ORDER BY Date DESC"

or

"SELECT * FROM notes WHERE HiveID='".$HiveID."' ORDER BY Date DESC"

answered Dec 3, 2012 at 3:10

NullPoiиteя

57.3k23 gold badges130 silver badges148 bronze badges

Collectives™ on Stack Overflow

Adding ORDER BY after variable in MySQL query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related