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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Shaun" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED], * 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

Reply via email to