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

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(SELECT * FROM

Is there a function to sort the result (after using ORDER BY)?

I do that via MySQL and if so, how? Thanks, SED - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

RE: Is there a function to sort the result (after using ORDER BY)?

, impoartance): 20020102, John, 3; 20020101, Smith, 5; 20010101, Sigmund, 1; 2101, Sigmund, 8; now I want to sort the result by importance (desc) so the final will be: 2101, Sigmund, 8; 20020101, Smith, 5; 20020102, John, 3; 20010101, Sigmund, 1; Do you have any way of doing it? SED

How do I select something distinct ordered by most frequent? (e.g. top 10)

Hi, I'm trying to make a query where I select something distinct ordered by most frequent? I found below example from the manual but I can not figure out how I should order them by most frequent - do you know how? SELECT DISTINCT owner FROM pet Regards, SED

[OT] Javascript Manual

Dadason SED - Graphic Design -- Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503 E-mail: [EMAIL PROTECTED] Homepage:www.sed.is

RE: is PHP list dead?

If you check out the www.php.net you will find out it temporally out of order. I sure hope it will be up soon :) Regards, Sumarlidi Einar Dadason SED - Graphic Design -- Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503

Is any limit on how many tables one database can have?

limit on how many tables one database can have? Regards, Sumarlidi Einar Dadason SED - Graphic Design -- Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503 E-mail: [EMAIL PROTECTED] Homepage:www.sed.is - New Homepage

Are all SQL-databases based on the same query-language?

Hi, I have only used MySQL. Today I read that all SQL use the same query-language, so if you program something, e.g. in PHP, you can also use is with other SQL-databases, with perhaps minor adjustments for the database-connections. Is this true? Regards, Sumarlidi Einar Dadason SED - Graphic

Can I have two (or more) different SQL-databases on the same server?

Hi, Can I have two (or more) different SQL-databases running at the same time on the same server (or same computer)? Does it varies between the systems? And if I can, are they all available to PHP at the same time? Regards, Sumarlidi Einar Dadason SED - Graphic Design

The function of auto_increment and Premier Key?

for and how does it work? Do I need it if I have a row ID like mentioned above? Regards, Sumarlidi Einar Dadason SED - Graphic Design -- Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503 E-mail: [EMAIL PROTECTED