why wont this echo work

[Shadowing]

why cant I get this to echo?

something so simple i dont understand what im doing wrong. can i simply not beable to display a sql timestamp with out converting

2011-12-19 14:57:45

 

 

<?php

$ban3 = "SELECT date FROM banned WHERE id = '".mysql_real_escape_string($_SESSION['user_id'])."'";
$ban2 = mysql_query($ban3) or die(mysql_error());
$ban1 = mysql_fetch_array($ban2);

		$pop = $ban1['date'];

	echo $pop;

?>

[melloorr]

echo "$pop";

[Shadowing]

thanks for the responce melloorr

 

i tried that before posting doesnt work either

[melloorr]

while ($ban1 = mysql_fetch_array($ban2))
{
                $pop = $ban1['date'];

	echo $pop;
}

[Shadowing]

still blank page. hmm i almost about had it with sql timestamps

 

 

 

<?php	$ban3 = "SELECT date FROM banned WHERE id = '".mysql_real_escape_string($_SESSION['user_id'])."'";
$ban2 = mysql_query($ban3) or die(mysql_error());


while ($ban1 = mysql_fetch_array($ban2))		
{

	$pop = $ban1['date'];

	echo "$pop";


}

?>

[Shadowing]

well I ruled out timestamp being the issue I just tried grabing a name and echoing and it didnt work.

user matches session id too check that also

[Stickie]

try

<?php	$ban3 = "SELECT date FROM banned WHERE id = '".mysql_real_escape_string($_SESSION['user_id'])."'";
$ban2 = mysql_query($ban3) or die(mysql_error());


while ($ban1 = mysql_fetch_array($ban2))		
{

	$pop = $ban1['date'];

	echo $pop;


}

?>

[melloorr]

 

<?php	$ban3 = "SELECT date FROM banned WHERE id = '".mysql_real_escape_string($_SESSION['user_id'])."'";
$ban2 = mysql_query($ban3) or die(mysql_error());


while ($ban1 = mysql_fetch_array($ban2))		
{

	$pop = "{$ban1['date']}";

	echo "$pop";


}

?>

 

Try this, I have done this and it worked with me

[Shadowing]

ahh I figured out whats wrong the field simply didnt exist.

[melloorr]

ahh I figured out whats wrong the field simply didnt exist.

 

Its an honest mistake

 

So its all working now?

[Shadowing]

Yah im good now, thanks alot

 

it wasnt the field missing i meant to say the entire row was missing.

 

I really appreciate the responces from everyone