RE: [PHP] Re: MySQL QUERY Results Not Appearing[Scanned]

2004-07-02 Thread Michael Egan
uot;.mysql_error().""; } if(!$query = @mysql_query("SELECT * FROM RegisteredMembers")) { echo "Couldn't execute query: ".mysql_error().""; } else { while($result = mysql_fetch_array($query)) { echo $result['UserID']; } } HTH, Mich

[PHP] Re: MySQL QUERY Results Not Appearing

2004-07-02 Thread Harlequin
Craig. Thanks for the response and sorry I've been delayed in getting back to you. I put a new page together and dropped all the peripheral code and this is what I ended up with: active members should appear here"; $query = mysql_query("SELECT * FROM RegisteredMembers") or die("could not execute

[PHP] Re: MySQL QUERY Results Not Appearing

2004-06-30 Thread Craig Donnelly
$result is an array that has to be fetched...try this echo "active members should appear here"; $query = mysql_query("SELECT * FROM RegisteredMembers") or die("could not execute query"); while($result = mysql_fetch_array($query)){ echo $result['YOUR_DB_FIELDNAME']; } change YOUR_DB_FIELDNAME