YES!!! Exactly!!!!
Russ...do what Steve syas...
-----Original Message-----
From: Steve Cayford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:32 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]