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, First

updated MySQL book

2003-02-04 Thread Lisi
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://www.mysql.com/manual.php

Re: Problem with LEFT JOIN

2003-02-03 Thread Lisi
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 if you had indented

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

2003-02-02 Thread Lisi
, 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 books are. I am

Problem with LEFT JOIN

2003-01-19 Thread Lisi
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. What am I doing wrong? Thanks in advance, -Lisi