Linux Format forums

[huwgreen]

I've just started working with php and mysql, and seem to have fallen at the first hurdle. I have a table called authority holding userids and level of access to the database. If I run the following code directly on the mysql server it displays all the userids and the total row count

Code:

select userid from authority;

However, if I run it through php, and try to use mysql_fetch_array/assoc/result, and then try to display the result all that is returned is the first element of the array. This happens whatever I use to display the result, foreach, list, echo $varname[0]...[n].
mysql_num_rows returns the correct row count.
I've been trying to see where I've made a mistake for a couple of days now and I'm not getting anywhere.
The relevant php is:

Code:

$userID_sql = "select userID from authority"; $userID = mysql_query ($userID_sql,$conn); //$conn is the connection index $allowed = mysql_fetch_assoc($userID); foreach ($allowed as $membid) { echo ("The ids are:<br>$membid<br>"); }

I'm using php/mysql/apache that is installed with SLES9
I hope someone can help.
Many thanks in advance
John

[bigbee]

First of all mysql_fetch_assoc array returns a single row of your result your construction should be a little bit like this:

[huwgreen]

Many thanks bigbee, I've finally got it sorted. Sorry I haven't replied sooner, but I'm currently doing more things at once than I should!
Once again, many thanks