The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
small request
I am trying to get this to get the date a thread was started in this format: Monday, November 18, 2002, How do I get it in that format?
Thanks. Code:
$connection = mysql_connect("$servername","$dbusername","$dbpassword") or die ("Cannot connect to server."); //select database $db = mysql_select_db("$dbname", $connection) or die ("Could not select database."); // create sql statement $sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, iconid FROM thread WHERE forumid = \"$newsforums\" ORDER BY threadid DESC LIMIT $newsitems"; //execute sql query $sql_result = mysql_query($sql, $connection) or die ("Could not execute query."); if (!$sql_result) { echo "<p>Could not get record."; } while ($row = mysql_fetch_array($sql_result)) { $threadid = $row["threadid"]; $thetitle = $row["title"]; $forumid = $row["forumid"]; $postusername = $row["postusername"]; $postuserid = $row["postuserid"]; $iconid = $row["iconid"]; echo "<font face=\"Verdana\" size=\"2\"><a href=\"$forumspath/showthread.php?s=&threadid=$threadid\">$thetitle</a> by <a href=\"$forumspath/member.php?s=&action=getinfo&userid=$postuserid\">$postusername</a></font><br>"; } mysql_free_result($sql_result); mysql_close($connection); |
#2
|
||||
|
||||
$mydate=date("l, F d, Y",$row['dateline']);
|
#3
|
||||
|
||||
Thanks dude.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|