RE: [PHP] Dynamic Pages and Google ???

2001-04-17 Thread Jeff Holzfaster
I too would be interested in learning what others on this list might have to say about this. Knowing how a search engine such as Google indexes a site or a page might be a good starting point in answering this debate: dynamic vs. static. Jeff So I was having a conversation with a manager/edu

RE: [PHP] MySQL Query Question

2001-04-15 Thread Jeff Holzfaster
> The MySQL manual has a chapter on date/time factions. Or is it > the 'order > by' clause that's giving you trouble...? I assume that 'date' is a > reserved word, so it may be confusing mysql. In which case, try using a > different alias, like 'f_date". This works: select date_format(dat

[PHP] MySQL Query Question

2001-04-15 Thread Jeff Holzfaster
Hi, I have a couple questions... first, is there a notable MySQL General List like this one? Second, how do you write this query properly, or can it be done? select concat(date_format(date, "%W, %e %M %Y")," ",time) as date from TABLE order by date DESC; Thanks! Jeff -- PHP General Mailing

RE: [PHP] Display Formatted Query Results

2001-04-14 Thread Jeff Holzfaster
Teemu, thanks for the input. I tried this with somewhat modified code (added all the fields) and perhaps you saw what I did on my last post to the list. I have actually been able to get the same results as this. I'm a little confused about how to get the info in the 'for' section to format to l

RE: [PHP] Display Formatted Query Results

2001-04-14 Thread Jeff Holzfaster
$my_row .= "$row[time]"; $my_row .= "$row[phone]"; $my_row .= ""; echo "$my_row\n"; } ?> Hi Jeff, @ 8:52:10 PM on 4/14/2001, Jeff Holzfaster wrote: > My apologies if this is too wordy.

[PHP] Display Formatted Query Results

2001-04-14 Thread Jeff Holzfaster
Hi All, My apologies if this is too wordy. This is driving me nuts. I have very little experience or knowledge of PHP and MySQL but have been put in a position that requires me to build several applications that require me to figure them out. I am making progress, though. Here is my first del