note 78195 deleted from function.mysql-result by ezyang
| From: | ezyang@php.net | Date: | Wed, 03 Oct 2007 01:21:03 +0000 |
| Subject: | note 78195 deleted from function.mysql-result by ezyang | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-131001@lists.php.net to get a copy of this message | ||
Note Submitter: dcez at land dot ru
Reason: useless
----
<?php
include('connect.php'); //including connection script
$query = mysql_query("SELECT * FROM users");
$rows = mysql_num_rows($query); //counting rows
$fields = mysql_num_fields($query); //counting fields
for($i=0;$i<$rows;$i++){
for($a=0;$a<$fields;$a++){
echo mysql_result($query, $i, $a).' '; //You can use single space if you
want
}
echo "<br />\r\n"; //Breaking result to rows
}
/*
We will get something like:
1 Andrew MaD HamsteR 29945382 1
2 Viki Akella 29966173 3
*/
?>