Retreive data from multiple columns by ['tablename.colname']

From: Date: Thu, 16 Oct 2003 15:57:28 +0000
Subject: Retreive data from multiple columns by ['tablename.colname']
Groups: php.db 
Request: Send a blank email to php-db+get-31081@lists.php.net to get a copy of this message
Hi, I use a query with multiple tables: SELECT * FROM cases,status,prio where cases.statusid=status.id && ..... I retreive the data into my variable $line like this. while ($line = mysql_fetch_array($result)) {..... How can I retreive data from $line without using the index value as integers for example $line[13] I would like to write $line['cases.id'] to retreive 'id' data from the table 'cases' in a SQL-manner. But I get an error message regarding unknown index 'cases.id'. Is there an easy solution to this? Is there another sign then '.' or should I use other names for my 'id'-columns such as c_id, s_id.... etc.? Regards Erik Björling

« previous php.db (#31081) next »