Multiple rows returned ?. . .
| From: | Mrvball008 | Date: | Wed, 14 Mar 2001 18:20:34 +0000 |
| Subject: | Multiple rows returned ?. . . | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7462@lists.php.net to get a copy of this message | ||
Hi I have little tiny script like so..
---------
<?
$dbName = "somedb";
$dbPass = "somepass";
$dbUserName = "someuser";
$host = "localhost";
$db = mysql_connect($host, $dbUserName, $dbPass) or die ("Could not connect
to database");
mysql_select_db($dbName,$db);
$sql = "SELECT * FROM downloads";
$result = mysql_query($sql, $db);
$row = mysql_fetch_array($result);
$row1 = mysql_fetch_array($result);
?>
-----------
no I know there has to be a more efficient way of returning the $row and
$row1 without writing it down like so..
anyone one can throw me a clue? :)
Thank
Andre