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
