http://www.php.net/manual/en/function.mysql-num-rows.php
jack
Jason Lotito wrote:
>
> Look in the script...
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 16, 2001 10:50 PM
> > To: 'PHP General List. (E-mail)'
> > Subject: Re: [PHP] Re: Invalid or Valid because the same.
> >
> >
> > //HTML headers here
> >
> > <?
> > if ($Submit == "Submit") { // If form has been submitted
> > $errormsg = array();
> >
> >
> > if (!$email)
> > {
> > $errormsg[] = "Please fill in your email address";
> >
}
> >
> >
> > $count = count($errormsg);
> >
> > #echo $count."<br>";
> >
> > if ($count > 0) {
> > for ($i=0; $i<count($errormsg); $i++) {
> > echo $errormsg[$i]."<br>";
> >
> > }
> >
> > }
> >
> > elseif ($count == 0)
> > {
> > #Insert Database checking ( NO ERROR )
> >
> > $host="localhost";
> > $dbuser="root";
> > $dbpassword="root";
> >
> > mysql_connect($host, $dbuser, $dbpassword)
> > or die ("Unable to Connect to Database");
> > mysql_select_db("secretDB");
> > $query = "Select username,password from
> > users where email = '$email'";
> > $sqlquery = mysql_query($query);
>
> Now, maybe this is just me, but...I would take a strong look at your
> mysql_numrows() function...their is an msql_numrows, but unless I am off my
> rocker...there is no mysql_numrows function. That might be part of the
> problem...
>
> > $num = mysql_numrows($sqlquery);
> >
> > if ($num == 0) #Not valid
> > {
> > ?>
> > <center>So sorry, your
> > email is not
> > valid.</body></html>
> > <?
> >
> >
> > }
> > else if ($num == 1) #Valid
> > {
> > ?>
> > <center>Sent mail.</body></html>
> >
> >
> > <?
> >
> > }
> >
> > }
> >
> > }
> > if ($reset == "Reset"){
> > $username = "";
> > $real_name = "";
> > $password = "";
> > $email = "";
> > }
> >
> >
> > ?>
> >
> > // Form here
> >
> >
> > ----- Original Message -----
> > From: "Jason Lotito" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, March 17, 2001 5:59 PM
> > Subject: RE: [PHP] Re: Invalid or Valid because the same.
> >
> >
> > > I have attached a php file together with this email.
> > >
> > > I apologize if you are having to download an extra 2k with this message.
> > >
> > > Please help me out. Thank you.
> > >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, March 16, 2001 10:36 PM
> > > To: [EMAIL PROTECTED]; 'PHP General List. (E-mail)'
> > > Subject: [PHP] Re: Invalid or Valid because the same.
> > >
> > >
> > > Sorry, heres the attached file.
> > >
> > >
> > > Nope, still no file. You might want to just paste the important stuff
> > into
> > > the email to the group.
> > >
> > > Jason Lotito
> > > [EMAIL PROTECTED]
> > > www.newbienetwork.net
> > >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]