Mysql help

[Cronus]

Can anyone help me how do I list ids SELECT id,name,country FROM ranks WHERE id = 7 ORDER BY id DESC I how would i list just 7 and 8 I am making a local development site for my self trying to learn mysql

please help?

 

[Ecko]

WHERE id = '7' OR id = '8'

 

[Markshall]

WHERE id = '7' AND '8'

 

[Ecko]

WHERE id = '7' AND '8'

That wouldn't work...

 

[ViiTactiiCZz]

That wouldn't work...

Why would it not work? the OP is wanting BOTH 7 and 8 not 7 or 8

 

[Cronus]

Why would it not work? the OP is wanting BOTH 7 and 8 not 7 or 8

Thank you, But I have got this to work with Trevors script, Please close thread.

 

[Ecko]

Why would it not work? the OP is wanting BOTH 7 and 8 not 7 or 8

OP wants to list from that table that has an id of 7 OR 8. Why would one row have both ids in that table?

 

[ViiTactiiCZz]

OP wants to list from that table that has an id of 7 OR 8. Why would one row have both ids in that table?

actually
"I how would i list just 7 and 8"