Re: RE: RE: [PHP-DB] Query construction

> 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 <remery@excel.com> 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: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 > > #-------------------------------------------------------# > > -- > 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 #-------------------------------------------------------#