RE: Blasted #$%$^$^ host has v3.23 when i need UNION

2003-09-15 Thread Andy Eastham
t; To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Blasted #$%$^$^ host has v3.23 when i need UNION > > > > Hey Andy, > True, but thats using 5 selects instead of just one, and since we > are expecting quite a bit of traffic to the site that can add up > pretty fast, expecial

Re: Blasted #$%$^$^ host has v3.23 when i need UNION

2003-09-15 Thread Ryan A
Hey Andy, True, but thats using 5 selects instead of just one, and since we are expecting quite a bit of traffic to the site that can add up pretty fast, expecially since we cant afford to have a dedicated server but are on a shared hosting package. If we have no other alternative we will be go

Re: Blasted #$%$^$^ host has v3.23 when i need UNION

2003-09-15 Thread Mixo Shiburi
You may also want to look at http://www.php.net/manual/en/function.mysql-num-rows.php Ryan A wrote: Hey, Thanks for replying. Nope, the whole reason for selecting the data is the count, i need to display to the client how many records of each category he has...if there is any other way to do that (

RE: Blasted #$%$^$^ host has v3.23 when i need UNION

2003-09-15 Thread Andy Eastham
TED] > Sent: 15 September 2003 11:25 > To: [EMAIL PROTECTED] > Cc: < > Subject: Re: Blasted #$%$^$^ host has v3.23 when i need UNION > > > Hey, > Thanks for replying. > > Nope, the whole reason for selecting the data is the count, i need to > display to the cl

RE: Blasted #$%$^$^ host has v3.23 when i need UNION

2003-09-15 Thread Andy Eastham
Sent: 15 September 2003 10:41 > To: < > Subject: Blasted #$%$^$^ host has v3.23 when i need UNION > > > Hi guys, > First of all let me warn you, i am very much a newbie to mysql, i > am pretty > good with the basics like selecting,deleting,updateing etc but > after that

Re: Blasted #$%$^$^ host has v3.23 when i need UNION

2003-09-15 Thread Ryan A
Hey, Thanks for replying. Nope, the whole reason for selecting the data is the count, i need to display to the client how many records of each category he has...if there is any other way to do that (me being a newbie to mysql) I would happy to know of it. Cheers, -Ryan > Without 'count' functio

Blasted #$%$^$^ host has v3.23 when i need UNION

2003-09-15 Thread Ryan A
Hi guys, First of all let me warn you, i am very much a newbie to mysql, i am pretty good with the basics like selecting,deleting,updateing etc but after that i get a dazed look in my eyes with complex sql :-D Now that you have been warned let me explain, on my local machine (win2k) i have php and