Re: Warning Extract
| From: | Marek Kilimajer | Date: | Wed, 02 Apr 2003 16:35:55 +0000 |
| Subject: | Re: Warning Extract | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-142003@lists.php.net to get a copy of this message | ||
Andy wrote: (and Marek fixed)
$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 membersWHERE username='$logname'";$result = mysql_query($sql)or die("Couldn't execute query 1.");if($row = mysql_fetch_array($result,MYSQL_ASSOC)) extract($row); if $logname is not in members table, then your query returns zero rows and mysql_fetch_array returns false. First argument to extract (see manual) must be an array, but is false in your case, and php warns you about that.
echo "<html><head><title>New Member Welcome</title></head> etcThank you all again Andy