subject:"\[PHP\] accessing result\-set with associative array"

Re: [PHP] accessing result-set with associative array

2003-03-30 Thread Leif K-Brooks

It doesn't include the table name. Use name, albumid, etc. anders thoresson wrote: Hi, I've the query "SELECT albums.name, albums.albumid, accessrights.albumid, accessrights.userid FROM albums, accessrights WHERE accessrights.userid = '$id' AND albums.albumid = accessrights.albumid". It wor

[PHP] accessing result-set with associative array

2003-03-30 Thread anders thoresson

Hi, I've the query "SELECT albums.name, albums.albumid, accessrights.albumid, accessrights.userid FROM albums, accessrights WHERE accessrights.userid = '$id' AND albums.albumid = accessrights.albumid". It works allright. Using the result in a html -tag this way works: while($row = mysq