How Find a Record in mysql_fetch_array?

Anon

I need find a record in a mysql_fetch_array.

Ex.

table have 3 records

1 Mike 21
2 Billy 22
3 Karen 20

I have this table in $rs = mysql_fetch_array($Data)

Now i want know if have a 23 people in array, if have return true if not return false.

Ps. This example is just for explain, i know for this i can do mysql_query.

Thanks for all,

Julio Goncalves

kparker

You need to study a bit more about mysql and the php functions for accessing it. mysql_fetch_array() retrieves a single row from a mysql result set. The "array" part is that each column of the row is in a different array element.

Anon

Have you a solution for what i want to do?

Thanks,

Julio Goncalves

polson

So you have :

1 Mike 21
2 Billy 22
3 Karen 20

And you want to know if 23 exists in the column where 21, 22, 20 exists? Assuming the name of this column is "foo" then taking from your :

$rs = mysql_fetch_array($Data)

You would do something like :

if ($rs['foo'] != 23) { return false; }

kparker

Or maybe your query needs to say

select * from table where some_column = 23