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

Reply via email to