Re: [PHP] database selection

2003-02-16 Thread Kevin Waterson
This one time, at band camp, "H Prins" <[EMAIL PROTECTED]> wrote: > Hello, > > Im trying to select only one row in a mysql database (in this case a poll > with the smallest pollID)... $query = "SELECT * FROM polls ORDER BY pollID ASC LIMIT 1"; Kevin -- __

[PHP] database selection

2003-02-16 Thread Hans Prins
Hello, Im trying to select only one row in a mysql database (in this case a poll with the smallest pollID)... Each row has a field called "pollID" which is the primary key and is auto incremented when a new row is inserted. I could possible do the following but I think its a bit extensive

[PHP] database selection

2003-02-16 Thread H Prins
Hello, Im trying to select only one row in a mysql database (in this case a poll with the smallest pollID)... Each row has a field called "pollID" which is the primary key and is auto incremented when a new row is inserted. I could possible do the following but I think its a bit extensive