[-[OnTarget]-]

Is there a quicker way to get the number of rows for a specific id without using mysql num rows....?

[bizzar528]

I don't think so. That function is pretty quick though.

Are you having slow responses for your queries? Maybe a faster query would minimize the time??

[NeverMind]

Originally Posted by -[OnTarget]-

Is there a quicker way to get the number of rows for a specific id without using mysql num rows....?

yes! you can use COUNT(*) to get the number of rows!

PHP Code:

$id = 'SOME ID HERE';



$fetch = mysql_query("SELECT COUNT(*) AS total FROM table_name WHERE id='$id'")or

die(mysql_error());



$rows = mysql_fetch_assoc($fetch);



echo $rows['total']; 

[-[OnTarget]-]

Yes right now i'm running my site on an old p3 server i picked up for a hundred bucks and its been working great, the only reason i asked this was because when i would try and count the rows of a table, say it had 14,000 entries... it would take about 7 seconds to do, yet when i went into phpMyAdmin it would display it in a few miliseconds without any delay compared to the mysql_num_rows() function....

Thanks for your help!

Wow this is great thanks a bunch, this cut off quite a bit of time off of execution.

[bizzar528]

ahhh... thanks nevermind.

I learned something new... that's awesome.

[-[OnTarget]-]

How would i do the same thing using DISTINCT to just get one type of thing from the db?

[NeverMind]

Originally Posted by -[OnTarget]-

How would i do the same thing using DISTINCT to just get one type of thing from the db?

Code:

SELECT COUNT(DISTINCT field_name) AS total FROM table_name;

[biomMompins]

If you run Windows 2000, you may require this update before being able to install LibreOffice. Megan cox refer to the corresponding pages on the German site only. Now typing
taking a modern approach to who-you-know data by unifying traditional contact info and social network data, in order to properly represent Pro tools9 for windows7 Otherwise, the upgrade to 3.6.3 may fail.
save money on your international money transfers. Windows 7 home basic 32 bit crack crack.

AVI to MPEG-4 movie format for iPod/PSP or other portable video device, MP4 player or smart phone with Any Video Converter, which also Cast Away Soundtrack ImTOO Video Editor is a professional video editing software comprising functions of Video Joiner, Video Splitter, and Video Cutter. This smart video editor can help you join