note 2862 deleted from mysql_fetch_array by danbeck
| From: | danbeck@php.net | Date: | Thu, 07 Sep 2000 15:34:05 +0000 |
| Subject: | note 2862 deleted from mysql_fetch_array by danbeck | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-4377@lists.php.net to get a copy of this message | ||
mysql...
well, to the problem with row names.. try <pre>select col1 AS anything, could
work..</pre>
and joins are dangerous: if you have an heavy-load system, mySQL LOCKS the tables if you join, so
you can't access data while one query is running.
i made an walkaround:
"select * from anywhere"
and then <pre>while ($row=mysql_fetch_*($connID):
echo $row[1] //assume this is our ID which is linked to the other table
$moreinfo=mysql_query("select * from table2 WHERE ID='$row[1]");
while ($row2=mysql_fetch_array($moreinfo):