Thank you - this helps a lot - its good to also know that the SQL problem I
was having is a mySql thing - not me !!!!!
From: "R. Joseph Newton" <[EMAIL PROTECTED]>
To: Anadi Taylor <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: jumping to the end of a loop
Date: Sat, 01 Mar 2003 11:26:46 -0800
Anadi Taylor wrote:
> Hi all,
>
> I have written a script that reads in information from a database: name,
> email, password and username.
> I am then searching through this information to match an email address
> entered by a user ( this script is web based ) against the email address
> pulled off the database. This all works fine except (ha ha - there is
always
> a BUT !!! ) when I find the email address I am looking for i want to
jump to
> the end of the 'while()' loop. I am sure this can be done but I just
cant
> figure it out !!!
HI Stefan,
Try using the flag value, $passcheck:
while (!($passcheck) and @dbdata = $sth1->fetchrow_array())
> {
> $dbname =$dbdata[0];
> $dbemail =$dbdata[1];
> $dbpwd =$dbdata[2];
> $dbusrname =$dbdata[3];
>
> ## check to see if emails match
> if ($usremail eq $dbemail)
> {
> $passcheck = "True";
> replyTo($usremail, $dbusrname, $dbpwd, $dbname);
> }
> }
>
> Also: the only reason I am having to pull all this data from the mySql
> database is because for some very strange reason mySql doent like the
'@'
> and the '.' characters in a sql statement: I actually started with a SQL
> query like:
>
> SELECT name, email, password, username FROM members WHERE
> email='[EMAIL PROTECTED]';
>
> BUT - it really doesnt like this, any ideas why ???
That is really a mySQL problem. Since the address is passed within single
quotes, Perl will pass it on as a literal, without attempting to
interpolate. Any hangup would therefore occur in the DB engine. I had no
problem offering that syntax to Access.
HTH
Joseph
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Stay in touch with MSN Messenger http://messenger.msn.co.uk
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
