Page 1 of 1

A little mySQL help please

Posted: Fri Jul 23, 2004 2:47 am
by lparnau
I have built a site using PHP and mySQL. I need to call the db and look for the first instence of a value of <2 in a field called "num_joined". I then need to collect the field "username" form that record. I just do not seem to be able to get this on together. Most all the records will have a value of <2 I just need a way to get the first instence.

Leonard[/mysql_man]

Posted: Fri Jul 23, 2004 11:17 am
by lostboy
select username form table where num_joined < 2 limit 1