MySQL Timestamp(14) still wont work properly

[wylim]

Here is what I have now:
$timestamp = $row['post_date'];
$post_date=date("l, F jS h:i:s a T Y", time($timestamp));

It posts the same date twice how do I get it to post the date that each item in the db that is pulled is equal to.

[bad_goose]

It would help if you were more specific - post a bigger chunk of code so that we can see what you're trying to do.

It sounds like your problem is just an error in the PHP - maybe it overwrites $post_date with the timestamp from a new row before "posting" them, or something. That's just a guess, though, because I don't get what your script is supposed to do.

[wylim]

while($row = mysql_fetch_array($result)) {
$userid = $row['userid'];
$subject = $row['subject'];
$timestamp = $row['post_date'];
$post_date=date("l, F jS h:i:s a T Y", time($timestamp));
$body = $row['body'];

	$db_name = "diablo";
	$table_name = "users";
	$connection = mysql_connect("65.26.138.33", "username", "password") or die(mysql_error());
	$db = mysql_select_db($db_name, $connection) or die(mysql_error());

	$sql = "
	SELECT *
	FROM $table_name
	WHERE userid = \"$userid\"
	";

	$result_one = mysql_query($sql, $connection) or die(mysql_error());

	while($row_one = mysql_fetch_array($result_one)) {
		$username = $row_one['username'];
	}

?>
<table bordercolor=#CCCCCC cellspacing=0 cellpadding=0 width=425
border=1 align="center" bgcolor="#000000">
<tbody>
<tr>
<td class=nobordercell bgcolor=#084e84>&nbsp;» News - (<? echo "$username"; ?>)</td>
</tr>
<tr>
<td class=nobordercell width="25%">
<div align="left">
<table width="100%" border="0" align="center">
<tr>
<td height="19">
<p><font size="2" color="#FFFFFF"><center><b><? echo "$subject"; ?></b></center><br><? echo "$body"; ?></font></p>
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td class=nobordercell width="25%" bgcolor="#084e84">
<div align="left">&nbsp;» <? echo "$post_date"; ?></div>
</td>
</tr>
</tbody>
</table>
<?
}
?>

[Weedpacket]

1. Are you really trying to connect to a database while you're connected to a database? (Another database, perhaps - but if so, why do it inside a loop, and create a new database connection with every iteration - especially if you're not closing any?)

2. Why is there a loop here:

   while($row_one = mysql_fetch_array($result_one)) {
   $username = $row_one['username'];
   }

   ?
   Could that (and the bit before) not just be

   $sql="select username from $table_name where userid='$userid'";
   $result_one=mysql_query($sql,$connection) or die(mysql_error());
   $row_one=mysql_fetch_array($result_one); // is it safe to assume there will 
   $username=$row_one['username']; //always be a row? Then drop the if().
   

3. time() does not take any arguments; as the manual notes, it returns the current time. If $timestamp is a Unix-style timestamp it's already in the right format. If it's a MySQL timestamp it will have to be changed out of MySQL format and into Unix style. There's a thread on exactly this subject three or four hours back. Oh, silly me; that's yours. Read it again.