Sorting Information

[neroag]

Hello All

I have a script that completes a mysql query and displays all the information & all works fine

The problem im having is that i only want it to display the information i tell it too ie...

there are 3 people with an age of 40 and the rest with various other ages, can someone point me in the right direction to get the script to display only those who are 40 & ignore the rest

many thanx

[dreamcatcher]

Hi neroag,

Something like this is what you want:

SELECT * FROM table WHERE age = '40'

Check out the MySQL manual for more information:
[dev.mysql.com...]

dc

[neroag]

Hi dreamcatcher
Thanx for that, just out of interest is there a way to also extract another piece of information at the same time sommit like...
SELECT * FROM table WHERE age = '40' & WHERE firstname = "Andy"

Thanx again

[ymasood]

Neroag,

That would be:

SELECT * FROM table WHERE age = 40 AND firstname = 'Andy'

Rgds,

YM

[neroag]

Thank you both Much appreciated again

Thanx

[dreamcatcher]

No problem, glad we could help. You might want to download a copy of the MySQL manual or look at some SQL tutorials to get the hang of some of the syntax.

dc