Re: Row count in a query

Hmmm... I would not bet money on John Holmes bad coding. (disclaimer: I have no financial stake in PHP|A, other than being a happy subscriber) More likely the original question was not well formulated. cheers Ignatius _________________________ ----- Original Message ----- From: "Martín Marqués" <martin@bugs.unl.edu.ar> To: <holmes072000@charter.net>; "Shaun" <shaun@mania.plus.com> Cc: <php-db@lists.php.net> Sent: Saturday, January 31, 2004 18:00 Subject: Re: [PHP-DB] Row count in a query El Dom 01 Feb 2004 12:54, John W. Holmes escribió: > Shaun wrote: > > > Is it possible to have an incrementing row count in my query that is not > > part of the table data? > > > > i.e. > > > > 1 data data > > 2 data data > > 3 data data > > ... > > > > This has to be done in the query not the PHP!! > > If you _have_ to get this in your query I'd say you have a flaw in your > logic somewhere. However, you can do it in MySQL using these two queries. > > SELECT @a:=0; > > SELECT @a:=@a+1, * FROM table; This isn't very good SQL coding. If you use a database with sequences, built a temptable to put the data in temporarly, with an INT field at the begining, and a sequence to have the autoincremental. Very easy, and compatile with any relational DB. :-) -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; --------------------------------------------------------- Martín Marqués | Programador, DBA Centro de Telemática | Administrador Universidad Nacional del Litoral --------------------------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php