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@xxxxxxxxxxxxxxx>
To: <holmes072000@xxxxxxxxxxx>; "Shaun" <shaun@xxxxxxxxxxxxxx>
Cc: <php-db@xxxxxxxxxxxxx>
Sent: Saturday, January 31, 2004 18:00
Subject: Re: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
