RE: [PHP-DB] Query construction
| From: | Rick Emery | Date: | Wed, 19 Sep 2001 14:41:47 +0000 |
| Subject: | RE: [PHP-DB] Query construction | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12588@lists.php.net to get a copy of this message | ||
YES!!! Exactly!!!!
Russ...do what Steve syas...
-----Original Message-----
From: Steve Cayford [mailto:steve_cayford@unioncab.com]
Sent: Wednesday, September 19, 2001 9:32 AM
To: r.j.michell@apu.ac.uk
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Query construction
Usually what I do when I'm having this type of problem is put the whole
sql statement into a string variable then print the variable out just
before running the query so you know exactly what's being sent to mysql.
Then I log into mysql from the command line and enter the query manually
to see what sort of response or error message I get.
-Steve
On Wednesday, September 19, 2001, at 09:01 AM, Russ Michell wrote:
> 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