RE: RE: [PHP-DB] Query construction

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:r.j.michell@apu.ac.uk] Sent: Wednesday, September 19, 2001 9:56 AM To: Rick Emery Cc: php-db@lists.php.net 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 <remery@excel.com> wrote: > 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 #-------------------------------------------------------# "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 #-------------------------------------------------------#