[PHP-DB] Row count in a query

2004-01-31 Thread Shaun
Hi, 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!! Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Row count in a query

2004-01-31 Thread Ignatius Reilly
The best way I can think of is: - create a temporary table T with an autoincrement field + desired output column structure - perform a INSERT INTO T SELECT 0, desired output in the temp table - you now have the desired result in your temp table HTH Ignatius _ -

[PHP-DB] Re: Subject: getting font size from browser

2004-01-31 Thread Neil Smth
Read this then go away, this is not a CSS or javascript list. http://www.alistapart.com/articles/elastic/ At 13:23 30/01/2004 +, you wrote: Message-ID: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Reply-To: Roy G. Vervoort [EMAIL PROTECTED] From: Roy G. Vervoort [EMAIL PROTECTED] Date: Fri, 30

Re: [PHP-DB] Row count in a query

2004-01-31 Thread John W. Holmes
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

RE: [PHP-DB] Problema con MySQL

2004-01-31 Thread Marco A. Ortiz
Buenos días a todos: Espero que alguno de ustedes hable español y me pueda ayudar a descubrir qué está mal en el siguiente código: El objetivo de la función es acceder a una base de Datos (MySQL) y mostrar los registros que cumplan cierta condición. Si no existe ningún registro que cumpla la

Re: [PHP-DB] Row count in a query

2004-01-31 Thread Martn Marqus
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

Re: [PHP-DB] Row count in a query

2004-01-31 Thread Ignatius Reilly
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: Martn Marqus

Re: [PHP-DB] getting font size from browser

2004-01-31 Thread Roy G. Vervoort
thanks, wil use a java group next time, did not know that roy Miles Thompson [EMAIL PROTECTED] schreef in bericht news:[EMAIL PROTECTED] PHP is SERVER side, not browser side. That's a Javascript question. Miles At 11:14 AM 1/30/2004 +0100, Roy G. Vervoort wrote: Is it possible to retreive

[PHP-DB] mysql date/time question

2004-01-31 Thread js
ok, 2 questions. first, how do i do a mysql query that orders by date? like, say i want to have 5 newest members who have signed up? i want it to display only 5 also. how do i do that? like this? $newestquery = SELECT artid,title,artdate,artauthor FROM article WHERE artdate = $today ORDER BY

Re: [PHP-DB] mysql date/time question

2004-01-31 Thread John W. Holmes
js wrote: ok, 2 questions. first, how do i do a mysql query that orders by date? like this? $newestquery = SELECT artid,title,artdate,artauthor FROM article WHERE artdate = $today ORDER BY artdate DESC LIMIT 5; Honestly, you could have taken the two seconds to try that and see if it worked

Re: [PHP-DB] Row count in a query

2004-01-31 Thread John W. Holmes
Martn Marqus wrote: 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? 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

RE: [PHP-DB] [Resolved] Unable to connect to MSSQL with PHP through a firewall

2004-01-31 Thread Ricky Boone
Okay, the problem was the MSSQL Client Tools wasn't installed. Once it was installed script connected perfectly. What I had done prior to installing the MSSQL Client Tools was copied ntwdblib.dll from the SQL Server to the Web Server. According the the PHP documentation for Microsoft SQL Server