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-09-19 Thread Rick Emery
9, 2001 9:33 AM 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 err

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: 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* o

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

2001-08-21 Thread Russ Michell
ichell [mailto:[EMAIL PROTECTED]] > > Sent: 21 August 2001 13:23 > > To: Lunny Damian > > Cc: [EMAIL PROTECTED] > > Subject: Re: RE: RE: [PHP-DB] Query construction > > > > > > Damn!! > > > > That'll be it.. > > > > I'm run

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 c