|
|
Posted by Geoff Berrow on 12/21/06 06:49
Message-ID: <1166682191.046574.280090@f1g2000cwa.googlegroups.com> from
jay2006 contained the following:
>Warning: mysql_num_rows(): supplied argument is not a valid MySQL
>result resource in /insert.php on line 117
Your query is failing
>
>Warning: Cannot modify header information - headers already sent by
>(output started at /insert.php:117)
>in /insert.php on line 128
>
>Warning: Cannot modify header information - headers already sent by
>(output started at /insert.php:117)
>in /insert.php on line 129
These are created because php has echoed a warning before your header
call
>
>
> if($num3 != 0)
> {
> $msg = ("<b>Email Already Registered:</b><br>We are sorry but the
>email you have entered has already been registered, please use another
>or try to recover your previous account.");
> mysql_close($link);
> }
> else
> {
> $sql = mysql_query("SELECT C_USER_NAME FROM CUSTOMER where
>C_USER_NAME = '$cus[8]'", $link);
>line 117>>> $num = mysql_num_rows($sql);
Do this:
$s=SELECT C_USER_NAME FROM CUSTOMER where C_USER_NAME = '$cus[8]'";
$sql = mysql_query($s, $link);
That way your can debug the SQL statement by doing
echo $s;
Also you can do this which gives you more info
$sql = mysql_query($s, $link) or die(mysql_error());
You haven't shown your database connection section. Is that ok, did you
remember to include it?
--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011
Navigation:
[Reply to this message]
|