Tilted Forum Project Discussion Community - View Single Post

FaderMonkey · 07-13-2004, 03:57 PM

I ended up doing it this way and it seems to be working:

PHP Code:


			
$query ="SELECT entrytitle, entrytext, entrydb,";

$query.=" DATE_FORMAT(entrydate, '%M %d, %Y %T') AS date";

$query.=" FROM weblog2 ORDER BY entrydate DESC LIMIT 10";

$result=mysql_query($query);

while (list($entrytitle,$entrytext,$entrydb,$entrydate) = 

mysql_fetch_row($result))

I have another question about this though. I got this code from someone else....a website about making a simple weblog....so I want to understand exactly how it's working. The seperate lines for defining the query ($query= and then $query.=)....is that just a way of setting different queries to the same variable? Does that question make sense?

07-13-2004, 03:57 PM	#17 (permalink)
FaderMonkey Psycho Location: Orlando, FL	I ended up doing it this way and it seems to be working: PHP Code: `$query ="SELECT entrytitle, entrytext, entrydb,"; $query.=" DATE_FORMAT(entrydate, '%M %d, %Y %T') AS date"; $query.=" FROM weblog2 ORDER BY entrydate DESC LIMIT 10"; $result=mysql_query($query); while (list($entrytitle,$entrytext,$entrydb,$entrydate) = mysql_fetch_row($result))` I have another question about this though. I got this code from someone else....a website about making a simple weblog....so I want to understand exactly how it's working. The seperate lines for defining the query ($query= and then $query.=)....is that just a way of setting different queries to the same variable? Does that question make sense?