Re: [PHP] PHP + MySQL, how to get total rows matched when using LIMIT 0, 10?

2002-11-05 Thread 1LT John W. Holmes
> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10", > but I only get the number 10, when the total should be around 100. So, > can I get total matched rows without doing a separate query using > count()? > > Here is an example of my current query: > > $result = mysql_query("SEL

Re: [PHP] PHP & MySQL

2001-07-20 Thread John Meyer
At 12:30 PM 7/20/01 -0400, you wrote: >on 7/20/01 12:32 PM, Erich Kolb at [EMAIL PROTECTED] wrote: > > > When you query a MySQL Database, how do you set the order alphabetically? > > >If it's a text field just say DESC > >Susan > isn't that reverse alphabetical ASC is (default) alphabetical Joh