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]

Reply via email to