[Mysql queries problem]

can\'t test it but maybe if you change

c.cat_id = 1

to

c.cat_id in (1,2,3,..)

[searching more than one field]

sry the second * must be % ofcourse

 

this works on my system but I don\'t use phpadmin

[searching more than one field]

more like this:

 

select * from hotels where \' *j%\' in (hotelname,hotelcountry,hoteladdress);

[mysql and php max()]

THX mtoynbee

 

It works except for the last line like you said.

 

I did it like I normally do

 

while($row = mysql_fetch_array($result)){

$max = $row[\'max(nr)\'];

}

 

But I still think there must be a better way as there is only one result with max.

[mysql and php max()]

Sorry for not being very clear.

 

When I do the following:

 

select max(nr) from table_test;

 

in mysql (via dosprompt) I get the result (f.i. 9)

 

now I try to do the same in php and normally I would do something like this:

 

$select = \"select nr from table_test\";

$result = mysql_query($select);

 

while($row = mysql_fetch_array($result)){

echo $row[\'nr\'];

}

 

but now its not nr but max(nr) but when I change all \'nr\' to \'max(nr)\' it doensnt seem to work.

 

I would like to now how I can get the value of max(nr) into a php variable. I think there is an easy way to do this but I\'m not seeing it.

[mysql and php max()]

select max(nr) from tablename;

 

but I want to get the max(nr) in php. How can I do this?