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

2001-09-19 Thread Russ Michell
I'm sorry but I must be missing something fundamental here. This is how my code looks, and if the SQL query yields nothing and emits no error (as it currently is) it simply reverts to error.php: $sql = SELECT * FROM $table_users WHERE usrName='$username' AND usrPswd=password('$password') AND

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

2001-09-19 Thread Rick Emery
To: Rick Emery Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: [PHP-DB] Query construction I'm sorry but I must be missing something fundamental here. This is how my code looks, and if the SQL query yields nothing and emits no error (as it currently is) it simply reverts to error.php: $sql = SELECT * FROM

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

2001-09-19 Thread Russ Michell
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

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

2001-08-21 Thread Russ Michell
Damn!! That'll be it.. I'm running phpMyAdmin 2.1.0 , php.4.0.3pl1 and MySQL 3.22.32 Then again I don't get an error message from your query..??? Perhaps it has to do with the query being embedded, that is *where* it's embedded: $totalsql = SELECT category,COUNT(*) FROM $Tpostings GROUP BY

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

2001-08-21 Thread Russ Michell
Damian Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: [PHP-DB] Query construction Damn!! That'll be it.. I'm running phpMyAdmin 2.1.0 , php.4.0.3pl1 and MySQL 3.22.32 Then again I don't get an error message from your query..??? Perhaps it has to do with the query being embedded

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

2001-08-21 Thread Alnisa Allgood
At 1:44 PM +0100 8/21/01, Russ Michell wrote: I always love that feeling when you beat a problem that refuses to go away. So do I - but I aint beaten it yet! :-( I'm still getting '2' as being the number of posts in each category when '2' is actually only the number of posts in *one* of the