Ask a Question related to PHP Notes, Design and Development.
-
didou@php.net #1
note 18689 deleted from function.mysql-result by didou
Note Submitter: [email]rob@clara.net[/email]
----
Dont forget you can always use count(*) with mysql_fetch_array() using good SQL querys..
$result = mysql_query("SELECT user,count(*) as count from users from screenshots group by user") or die(mysql_error());
$row = mysql_fetch_array($result);
$row[count] would be your count of $row[user]
didou@php.net Guest
-
note 11895 deleted from function.mysql-result by didou
Note Submitter: alec@brainpod.com ---- "select count(*) from users" will return a table with one row and one field whith the count of how many... -
note 26082 deleted from function.mysql-result by didou
Note Submitter: sedesignlinksnet ---- If you wish to select a field value in a SQL statement like: $sql = "SELECT uid FROM global_lookup... -
note 26738 deleted from function.mysql-result by didou
Note Submitter: fernando@unijui.tche.br ---- Here is one simple sample about how to use the mysql_result: <?php // Define the conexion... -
note 11074 deleted from function.mysql-result by didou
Note Submitter: squeezeboobies@digitalsorcery.net ---- If you have just performed an insert into a database with an auto incrementing field you... -
note 33639 deleted from function.mysql-connect by didou
Note Submitter: carp_a_dieum@yahoo.com ---- To extend amn -at- frognet.net comment. Here is a cool example of reusing mssql connections and...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
