note 2863 deleted from mysql_fetch_array by danbeck

sorry 4 the 1st posting :) hit it with da mouse 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): echo $row2[1]; //additional info endwhile; endwhile; </pre> this works fine @ www.klammeraffe.at, an austrian web-guide