[SOLVED] if statement in QUERY

[Canman2005]

Hi all

 

I have the following QUERY

 

SELECT * FROM news WHERE title LIKE '%".$_GET['q']."%' OR content LIKE '%".$_GET['q']."%' AND pageid != 3496

 

How can I mod this QUERY so that if pageid does = 3496 then it just returns the last 10 rows for any rows containing 3496 but still keep it returning *

 

Does that make sense?

 

Any help would be ace

 

Thanks

 

Ed

[paul2463]

SELECT * FROM news WHERE title LIKE '%".$_GET['q']."%' OR content LIKE '%".$_GET['q']."%' AND pageid = 3496 ORDER BY pageid DESC LIMIT 10

[Canman2005]

Thanks