RE: RE: RE: [PHP-DB] Query construction
| From: | Rick Emery | Date: | Wed, 19 Sep 2001 14:40:18 +0000 |
| Subject: | RE: RE: RE: [PHP-DB] Query construction | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12587@lists.php.net to get a copy of this message | ||
You've created $sql. Good. Print it...display it...show its contents...
Does it contain the TEXT that you expect? Copy and paste it to the "mysql>"
command line in mysql.
-----Original Message-----
From: Russ Michell [mailto:r.j.michell@apu.ac.uk]
Sent: Wednesday, September 19, 2001 9:33 AM
To: Rick Emery
Cc: php-db@lists.php.net
Subject: Re: RE: RE: [PHP-DB] Query construction
I'm sorry but I must be missing something fundamental here. This is how my
code looks, and if the
SQL query yields nothing and emits no error (as it currently is) it simply
reverts to error.php:
$sql = "SELECT * FROM $table_users WHERE usrName='$username' AND
usrPswd=password('$password') AND affil_team RLIKE '$team+'";
$result = mysql_query($sql, $connection) or die(mysql_error());
$num = mysql_num_rows($result);
//User hasn't been found in DB with current details:
if ($num == 0) {
header("Location: error.php?err=n_player);
exit;
}
else {
while($row = mysql_fetch_array($result)) {
etc etc
Cheers again:
Russ
On Wed, 19 Sep 2001 09:26:07 -0500 Rick Emery <remery@excel.com> wrote:
> $query = "SELECT * FROM $table_users WHERE usrName='$username' AND
> usrPswd=password('$password') AND affil_team RLIKE '$team+'"
> print $query
>
> what were the contents of $query
>
> -----Original Message-----
> From: Russ Michell [mailto:r.j.michell@apu.ac.uk]
> Sent: Wednesday, September 19, 2001 9:19 AM
> To: Rick Emery
> Cc: php-db@lists.php.net
> Subject: Re: RE: [PHP-DB] Query construction
>
>
> If you mean did the pattern I'm trying to match: $team, contain what I
> though it should:
> 'footballSat' then yes it did. I also receieve no error message from
> MySQl....
>
> The string in the table field I can view/alter in phpMyAdmin and I've
tried
> matching $team in the
> query to the string as: footballSatfootballSun (etc etc) and also as:
> footballSat footballSun (etc
> etc)..
>
> Any ideas??
> Many thanks.
>
> Russ
>
> On Wed, 19 Sep 2001 09:12:36 -0500 Rick Emery <remery@excel.com> wrote:
>
> > When you printed-out the string variable containing the SELECT
statement,
> > what did it look like?
> >
> > -----Original Message-----
> > From: Russ Michell [mailto:r.j.michell@apu.ac.uk]
> > Sent: Wednesday, September 19, 2001 9:01 AM
> > To: php-db@lists.php.net
> > Subject: [PHP-DB] Query construction
> >
> >
> > Hi there:
> >
> > Further to a previous submission (which can be ignored), I'd like the
> > following query to 'search' a
> > table field of different team names (stored as a single string), but it
> > does't seem to work!
> >
> > "SELECT * FROM $table_users WHERE usrName='$username' AND
> > usrPswd=password('$password') AND affil_team RLIKE '$team+'";
> > (I've also tried: RLIKE '$team?' )
> >
> > This should match the string found in the variable: '$team' with the
some
> of
> > contents (string)
> > found in 'affil_team'.
> >
> > For example my test has been, trying to find 'footballSat', so $team =
> > 'footballSat'. 'footballSat'
> > exists as part of the string in the 'affil_team' field but the above
query
> > refuses to find
> > 'footballSat'!! (No error is received though)
> >
> > I'm using MySQL 3.22.32 + php4.0.3pl1
> >
> > Cheers
> > Russ
> >
> > #-------------------------------------------------------#
> >
> > "Believe nothing - consider everything"
> >
> > Russ Michell
> > Anglia Polytechnic University Webteam
> > Room 1C 'The Eastings' East Road, Cambridge
> >
> > e: r.j.michell@apu.ac.uk
> > w: www.apu.ac.uk/webteam
> > t: +44 (0)1223 363271 x 2331
> >
> > www.theruss.com
> >
> > #-------------------------------------------------------#
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
>
> #-------------------------------------------------------#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: r.j.michell@apu.ac.uk
> w: www.apu.ac.uk/webteam
> t: +44 (0)1223 363271 x 2331
>
> www.theruss.com
>
> #-------------------------------------------------------#
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: r.j.michell@apu.ac.uk
w: www.apu.ac.uk/webteam
t: +44 (0)1223 363271 x 2331
www.theruss.com
#-------------------------------------------------------#