RE: [php-list] Date/Time Offset

2008-03-04 Thread Arne Stone
John Black wrote: Arne Stone wrote: Hallo all, Sorry for the n00b question! I am busy learning PHP and from the eBook I copied this code: When I open this in my browser I just see a blank screen not one of the echo's showsWhat could be the problem? Make sure you have error

RE: [php-list] URL retrieval through variable.

2008-03-04 Thread Lenny Davila
[EMAIL PROTECTED] mailto:listgroups08%40ozwebwiz.com wrote: - Original Message - From: Leelakh Ran Hi everybody, My site URL showing as http://www.sub.mysite.com/onetwothree.htm?get=name http://www.sub.mysite.com/onetwothree.htm?get=name I can access this URL on

Re: [php-list] Format date in left join

2008-03-04 Thread Bob
- Original Message - From: William Piper Bob wrote: snipped some message here The 1st DATE_FORMAT() is working fine. My trouble is when I try to add the 2nd DATE_FORMAT(): No matter where I add it, the query fails. Tried it in different places etc. $sql = SELECT *,

Re: [php-list] Format date in left join

2008-03-04 Thread listgroups08
- Original Message - From: William Piper Bob wrote: snipped some message here You need to group your selects together, also it is a good idea to name your tables in the join to keep from ambiguity issues though not mandatory. See below: SELECT *, DATE_FORMAT(h.msg_id,'%W %D %M %Y

Re: [php-list] Format date in left join

2008-03-04 Thread Bob
- Original Message - From: [EMAIL PROTECTED] Bob wrote: snipped some message here You need to group your selects together, also it is a good idea to name your tables in the join to keep from ambiguity issues though not mandatory. See below: SELECT *, DATE_FORMAT(h.msg_id,'%W %D