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: <?php /* MySQL Connection Variables */ $host="localhost"; $user="arras_WebMaster"; $password="qwerty"; $dbase="arras_Members"; /* MySQL Connection String */ $Connection=mysql_connect ("$host", "$user", "$password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("$dbase"); /* Display Current Members */ echo "\n\n\n\n\n"; echo "<h3>active members should appear here</h3>"; $query = mysql_query("SELECT * FROM RegisteredMembers") or die("could not execute query"); while($result = mysql_fetch_array($query)){ echo $result['UserID']; } ?> Still no joy though. Any ideas...? -- ----------------------------- Michael Mason Arras People www.arraspeople.co.uk ----------------------------- "Craig Donnelly" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > $result is an array that has to be fetched...try this > > echo "<h3>active members should appear here</h3>"; > > $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' to whatever the fields are you are querying. > you could also: > > <pre> > <?php print_r($result); ?> > </pre> > > HTH > > Craig > > "Harlequin" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hi all... > > > > Despite being able to make a connection to the server and execute a query > I > > am unable to do this through PHP using the following commands: > > > > echo "<h3>active members should appear here</h3>"; > > $query = "SELECT * FROM RegisteredMembers"; > > $result = mysql_query($query) or die ("could not execute query"); > > echo "$result"; > > > > Any ideas...? > > > > -- > > ----------------------------- > > Michael Mason > > Arras People > > www.arraspeople.co.uk > > ----------------------------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php