note 5579 deleted from mysql_num_rows by ronabop
| From: | ronabop@php.net | Date: | Sat, 19 Aug 2000 04:13:36 +0000 |
| Subject: | note 5579 deleted from mysql_num_rows by ronabop | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-2624@lists.php.net to get a copy of this message | ||
I have a table that looks as follows:
mysql> select sp_name from sp_frame;
+----------+
| sp_name |
+----------+
| SP-BLUE |
| SP-WHITE |
| SP-RED |
+----------+
3 rows in set (0.00 sec)
When I try to look it up like this:
$query = "select sp_name from sp_frame";
$res = mysql_query($query, $dbh) or die ("Invalid Query to DB");
$sp_frame_names = mysql_fetch_array($res);
echo "0: $sp_frame_names[0] 1: $sp_frame_names[1]<br>";
I get output only for the first table entry:
0: SP-BLUE 1:
Do I have a problem with PHP or am I going about this incorrectly?
Thanks