Bug or query problem?

2005-04-30 Thread Ryan A
ause "pic1" for "from_cno" should be "r.jpg" but its somehow "cacheing" the above. Please advise. Thanks, Ryan A -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4

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 Ryan A
cated.ccno=1) OR > (reseller.user ='testing' and reseller.ccno=1) OR > (colocated.user ='testing' and ccolocated.cno=1) OR > (freehosting.user ='testing' and freehosting.ccno=1) OR > > > > Ryan A wrote: > > Hi guys, > > First of all let me war

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

NewbieALERT - Question/problem

2003-08-31 Thread Ryan A
Hi, Am pretty new to mysqls power so kindly excuse if some of the questions are very basic. I have a table Cusomer_Data with 13 fields, (for the sake of simplicity lets call the fields 1 to 13) I want add 5 more fields after the 13th one and add the default falues of 1,1,'no',1,'no' to all the ol

selecting count query (newbie alert)

2003-08-14 Thread Ryan A
Hi, This is my first post here so forgive me if its too simple or not right. basically what i do is: SELECT COUNT(*) FROM table1 where cno=3; (and dumping it into a variable $theResult - I am using PHP) and it gives me the result, but now i need to do this in 5 tables... I can of course run 5 cou

selecting multiple count statement (newbie)

2003-08-14 Thread Ryan A
Hi, This is my first post here so forgive me if its too simple or not right. basically what i do is: SELECT COUNT(*) FROM table1 where cno=3; (and dumping it into a variable $theResult - I am using PHP) and it gives me the result, but now i need to do this in 5 tables... I can of course run 5 cou