A little mySQL help please

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
lparnau
Forum Newbie
Posts: 15
Joined: Tue Aug 12, 2003 3:31 pm

A little mySQL help please

Post 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]
lostboy
Forum Contributor
Posts: 329
Joined: Mon Dec 30, 2002 8:12 pm
Location: toronto,canada

Post by lostboy »

select username form table where num_joined < 2 limit 1
Post Reply