This is what I am using here:
$db = DB::connect("mysql://$username:$password@$hostName/$databaseName");
if (DB::iserror($db))
die($db->getMessage());
$sql = "SELECT idnum, title, DATE_FORMAT(date, '%W, %M %D \@ %l:%i%p'),
news FROM newslist ORDER BY idnum DESC";
$query = $db->query($sql);
if (DB::iserror($query))
die($db->getMessage());
while ($query->fetchInto($row)) {
echo "\n<table>" .
"\n<tr>\n\t<td>$row[1] ID#$row[0]</td></tr>" .
"\n<tr>\n\t<td>Added $row[2]</td></tr>" .
"\n<tr>\n\t<td>$row[3]</td></tr>" .
"\n</table>";
}
I took out all the font formatting and stuff so its not so cluttered here.
but it works just dandy, although I know what you are talkng about, when
using the other way to connect it returns the name as whatever (like a
COUNT(*) does). Although, I never knew the AS var thing, so that will help
me with other stuff down the road!
I know this is nothing fancy, but it is just what I've been wanting to do
since before I started learning php and mysql. :)
Bryan
On Mon, 30 Sep 2002, Jason Young wrote:
|No problem!
|
|Refresh MY memory here.. I noticed you didn't return the DATE_FORMAT
|column "AS <var>" .. is that working okay? I seemed to think that it
|returned a long unwieldy column name.. maybe things are good.. let me
|know :-D
|
|--Jason
|
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
