Ok ok ok!! Thank you both for the pointers, they did of course yield the problem - as
bloody always
it's something completely different! As my old-dad always says: "Everything is about
something
else" (although this was always meant in a psychiatrist-patient relationship..)
Thank you again both, and I apologise for seemingly wasting your time, but I do value
people's
ideas and opinions, and hopefully others do of mine also.
Regards:
Russ Michell (APU Webteam)
On Wed, 19 Sep 2001 09:41:47 -0500 Rick Emery <[EMAIL PROTECTED]> wrote:
> 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]
#-------------------------------------------------------#
"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]