Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2003022

[PHP] Re: database selection From: Hans Prins (HPrins <email protected>)
Date: 02/17/03

One more question about this:

If I wanted to select the last row, would I use this code?

$query = "SELECT * FROM polls ORDER BY pollID DESC LIMIT 0,1";

"Hans Prins" <HPrins <email protected>> schreef in bericht
news:20030216135727.52586.qmail <email protected>
> thank you,
>
> that did the trick :)
>
> "Thomas Seifert" <thomas.seifert <email protected>> schreef in bericht
> news:20030216141748.6aa1753d.thomas.seifert <email protected>
> > On Sun, 16 Feb 2003 12:51:58 +0100 HPrins <email protected> (Hans Prins) wrote:
> >
> > > 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:
> > >
> > > $query = "SELECT * FROM polls ORDER BY pollID ASC";
> > > $result = mysql_query($query);
> > > for ($count = 0; $count < 1 $count++) {
> > > $data = mysql_fetch_array($result);
> > > $pollID = $data['pollID'];
> > > }
> > > $query = "SELECT * FROM polls WHERE pollID = $pollID";
> > >
> > > Does anyone now a solution for this that requires less code?
> > >
> > > Thx
> > >
> > >
> >
> > $query = "SELECT * FROM polls ORDER BY pollID ASC LIMIT 1";
> >
> >
> > Thats the only row.
> >
> >
> >
> > Regards,
> > --
> > Thomas Seifert
> >
> > mailto:thomas.seifert <email protected>
> > http://www.MyPhorum.de
>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php