RE: SV: [PHP-DB] i am lost (php warning)

try this: $sql = "SELECT * FROM cm_customer WHERE emial='$user'"; $sql_query = mysql_query($sql) or die($mysql_error()); bastien

From: "Henrik Hornemann" <HEH@DNLB.DK> To: <php-db@lists.php.net> Subject: SV: [PHP-DB] i am lost (php warning) Date: Tue, 18 Jan 2005 09:15:01 +0100 Hi, Probably because $user is not in the database. Regards Henrik Hornemann -----Oprindelig meddelelse----- Fra: Earl Clare [mailto:eclare@claremedia.bz] Sendt: 18. januar 2005 07:59 Til: php-db@lists.php.net Emne: [PHP-DB] i am lost (php warning) Prioritet: Høj Hi ya'll, I am lost as to why I am getting this error in my script. Can anyone kindly explain why this is so. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cm/public_html/cell/login.php ---------------------------------------------------------------------------- ---

                              My script

---------------------------------------------------------------------------- --- if($_POST['submit'] == '>Log In') {

            $user=$_POST["email"];

            $pass=$_POST["pass"];

            $sql_query = mysql_query("SELECT * FROM cm_customer WHERE emial='$user'");

            $sql_query = mysql_num_rows($sql_query);

            if (($sql_query) >0)

{

                                    $valid = $user;

                                    session_start();

                                    session_register("valid");

} } if (session_is_registered("reg")) {

              echo "ok";

} else {

     echo "sorry";

} -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php