Re: RE: [PHP-DB] Query construction
| From: | Russ Michell | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: RE: [PHP-DB] Query construction | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12582@lists.php.net to get a copy of this message | ||
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
#-------------------------------------------------------#