> Learning is NEVER a waste of time...
No, of course not, but having been on these lists for sometime, I get the feeling some
people (as I
would, and do) get pi**ed off if someone doesn't at least try first before asking
questions..
> p.s. Your father is a psychiatrist??? Now, there, I could use some help...
No he isn't he just thinks he is ;-)
Many thanks.
Russ
On Wed, 19 Sep 2001 10:01:07 -0500 Rick Emery <[EMAIL PROTECTED]> wrote:
> It wasn't a waste of time. Now, the next time you have a similar problem
> with a mySQL query, you'll follow this procedure.
>
> Learning is NEVER a waste of time...
>
> p.s. Your father is a psychiatrist??? Now, there, I could use some help...
>
> -----Original Message-----
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 9:56 AM
> To: Rick Emery
> Cc: [EMAIL PROTECTED]
> Subject: Re: RE: [PHP-DB] Query construction
>
>
> 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]
>
#-------------------------------------------------------#
"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]