sql query help

[friedice]

hi im having trouble with this query

i wana select 3 events that only contain seminar and are the next dates from NOW() date

Select * from Events WHERE EventType like '%seminar%' AND Date > NOW() DESC LIMIT 3 

 

thx

 

[gristoi]

Select * from Events WHERE EventType like '%seminar%' AND Date > NOW()  ORDER BY Date DESC LIMIT 3 

[friedice]

cool thx

hmm cant even make it ascending order

	$squery = "Select * from Events WHERE EventType like '%seminar%' AND Date > NOW() ORDER BY Date ASC DESC LIMIT 3 ";

 

[gristoi]

you can only have it in Descending or Ascending - not both

cool thanks

hmm cant even make it ascending order

	$squery = "Select * from Events WHERE EventType like '%seminar%' AND Date > NOW() ORDER BY Date ASC DESC LIMIT 3 ";

 

[friedice]

omg i just realised i used desc before  already

 

thx

 

solved