Why isn't my WHERE query working

[t5amec]

$query="SELECT * FROM malloysGigs ORDER BY date WHERE active='1' DESC Limit 1";

The above is the query I put at the beginning of my code. I personally can't see anything wrong with it... can you?

When i don't have rge WHERE syntax it works fine, but I need want it to show only the rows in the database where the active equals 1.

Any help?

Make Sense? I hope so (-:

 

[sleipnir214]

For one thing, "DESC" doesn't make sense unless it's adjacent to an ORDER BY column name.

Also, MySQL is picky about the order of clauses. WHERE clauses need to come before ORDER BY clauses.

I'd try:

$query="SELECT * FROM malloysGigs WHERE active='1' ORDER BY date DESC Limit 1";

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[t5amec]

thanks, big help!

Make Sense? I hope so (-:

 

[Olavxxx]

Also, dont use SELECT *, but SELECT only the fields you need.

You dont have to choose the fields that you want to run the WHERE on, as you can do something like:

SELECT `uid`, `fnam`, `lnam` FROM `malloysGigs` WHERE active='1' ORDER BY `date` DESC Limit 0, 1";

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster