note 92454 deleted from function.mysql-result by danbrown
| From: | danbrown@php.net | Date: | Fri, 24 Jul 2009 18:30:59 +0000 |
| Subject: | note 92454 deleted from function.mysql-result by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-158705@lists.php.net to get a copy of this message | ||
Note Submitter: yusufsarigoz at gmail dot com
----
<?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>";