Warning Extract
| From: | Andy | Date: | Wed, 02 Apr 2003 16:03:57 +0000 |
| Subject: | Warning Extract | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-142001@lists.php.net to get a copy of this message | ||
Help AGAIN!!!
Thank you for all the help so far, i am close to getting this members
section working correctly now i think!
I think i would have given up by now if it were not for the help i get from
you all, thank you.
I have a warning that i don't understand:
Warning: extract() expects first argument to be an array in
/home/.sites//New_member.php on line 23
I also find that although i get through to the new members page OK when
filling in the form it does not write to the mysql database with the new
details, yet if i enter a username that already exists it tells me, so the
php and mysql must be interacting.
Here is the code for the warning message, hope it helps:
$connection = mysql_connect($host, $user,$password)
or die ("Couldn't connect to server.");
$db = mysql_select_db($database, $connection)
or die ("Couldn't select database.");
$sql = "SELECT name FROM members
WHERE username='$logname'";
$result = mysql_query($sql)
or die("Couldn't execute query 1.");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
extract($row);
echo "<html>
<head><title>New Member Welcome</title></head> etc
Thank you all again
Andy