note 92454 added to function.mysql-result

From: Date: Fri, 24 Jul 2009 18:25:23 +0000
Subject: note 92454 added to function.mysql-result
Groups: php.notes 
Request: Send a blank email to php-notes+get-158704@lists.php.net to get a copy of this message
<?php $query = "SELECT username, mail FROM users"; $result = mysql_query($query); echo "<table><tr><td>Username</td><td>Mail</td></tr>"; $number = mysql_num_rows($result); if($number > 0) { for($i=0; $i<$number; $i++) { $usernames = mysql_result($result,$i,'username'); $mails = mysql_result($result,$i,'mail'); echo "<tr><td>".$usernames."</td><td>".$mails."</td></tr>"; } } else { echo "The database "users" is empty."; echo "</table>"; ---- Server IP: 160.75.100.7 Probable Submitter: 88.226.76.216 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-result.php Edit -- https://master.php.net/note/edit/92454 Del: integrated -- https://master.php.net/note/delete/92454/integrated Del: useless -- https://master.php.net/note/delete/92454/useless Del: bad code -- https://master.php.net/note/delete/92454/bad+code Del: spam -- https://master.php.net/note/delete/92454/spam Del: non-english -- https://master.php.net/note/delete/92454/non-english Del: in docs -- https://master.php.net/note/delete/92454/in+docs Del: other reasons-- https://master.php.net/note/delete/92454 Reject -- https://master.php.net/note/reject/92454 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#158704) next »