$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

Reply via email to