Re: Re: Invalid or Valid because the same.
| From: | Jack Dempsey | Date: | Sat, 17 Mar 2001 07:08:39 +0000 |
| Subject: | Re: Re: Invalid or Valid because the same. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-44371@lists.php.net to get a copy of this message | ||
http://www.php.net/manual/en/function.mysql-num-rows.php
jack
Jason Lotito wrote:
>
> Look in the script...
>
> > -----Original Message-----
> > From: techzeus@pacific.net.sg [mailto:techzeus@pacific.net.sg]
> > 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" <Jason@lehighweb.com>
> > To: <techzeus@pacific.net.sg>
> > 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: techzeus@pacific.net.sg [mailto:techzeus@pacific.net.sg]
> > > Sent: Friday, March 16, 2001 10:36 PM
> > > To: techzeus@pacific.net.sg; '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
> > > jason@lehighweb.com
> > > www.newbienetwork.net
> > >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-general-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net