logname is not in my database.
It is a session variable used to hold the members login name.
In the form it is session_register('logname'); which is then set to a
variable with this code:
if ($num2 > 0) { // password is correct
$auth="yes";
$logname=$fusername;
$today = date("Y-m-d h:m:s");
$sql = "INSERT INTO login (username,loginTime)
VALUES ('$logname','$today')";
does that make any sense?
Andy
"Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> 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 members
> > WHERE 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> etc
> >
> >Thank you all again
> >
> >Andy
> >
> >
> >
> >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
