note 28866 modified in function.mysql-fetch-assoc by philip
| From: | philip@php.net | Date: | Thu, 20 Feb 2003 07:55:30 +0000 |
| Subject: | note 28866 modified in function.mysql-fetch-assoc by philip | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-44246@lists.php.net to get a copy of this message | ||
[[[Editors note: Or you can make a query such as:
SELECT
foo.bar AS anything,
baz.bar AS bazabar
...
And call, for example, $row['bazabar']; ]]
if you use this SQL query:
SELECT
start_super_super_collections.name,
start_super_collections.name
.......
and then get the result with mysql_fetch_assoc() then you'll get only ONE result collumn keyed
by 'name'. use mysql_fetch_row() instead, then you'll get TWO collumns keyed 0 and 1.
--was--
if you use this SQL query:
SELECT
start_super_super_collections.name,
start_super_collections.name
.......
and then get the result with mysql_fetch_assoc() then you'll get only ONE result collumn keyed
by 'name'. use mysql_fetch_row() instead, then you'll get TWO collumns keyed 0 and 1.
http://www.php.net/manual/en/function.mysql-fetch-assoc.php