Re: Problem with LEFT JOIN

2003-02-13 Thread Lisi
Hi Bill, It worked! Thanks so much for your help, and for your suggestions about formatting queries. I haven't worked much with complicated queries, and this was my first time posting to this list. Thanks for the help! -Lisi At 05:11 AM 2/8/03 -0500, Bill Easton wrote: Lisi,

updated MySQL book

2003-02-04 Thread Lisi
r versions of the database, and I'd like to see what you've added to your new book, but I don't really need all the intro stuff all over again. Any thoughts? Thanks, -Lisi - Before posting, please check: http:/

Re: Problem with LEFT JOIN

2003-02-03 Thread Lisi
s this just too complicated to do with one query? Should I perhaps use different queries, and store the info somehow in an array by name, and display it that way? I'm really stumped here. Thanks, -Lisi At 07:31 AM 1/20/03 -0500, Bill Easton wrote: Shalom, Lisi, (Sure would have been nice

Re: What are the best MySQL and PHP resource books?

2003-02-02 Thread Lisi
cus on IIS, rather they assume Apache, but beyond the initial setup and configuration I don't think it matters. -Lisi At 05:16 PM 2/1/03 -0500, Loren McDonald wrote: HI Before I just go out and buy, I wanted to get some opinions / advice on what you all think the best MySQL and PHP resource b

Problem with LEFT JOIN

2003-01-19 Thread Lisi
te LEFT JOIN ads_clickrate ON ads_displayrate.name = ads_clickrate.name AND YEAR(ads_displayrate.date) = '2003' AND MONTH(ads_displayrate.date) = '01' GROUP BY ads_displayrate.name ORDER BY ads_displayrate.name it doubles the number from what it should be.