SELECT Issue

[ainoy31]

Hello-

 

I have a simple select statement:

 

$ml_id = $_POST['ml_id'];

$sql = "SELECT listname FROM ml_lists WHERE ml_id = '$ml_id'";

 

$result = mysql_query($sql) or die("Error: " . mysql_error());

$row = mysql_fetch_array($result);

$listname = $row['listname'];

 

I have echo out the $ml_id and it is giving me the correct number.  I can not echo the $listname but get the message of Resource id #5.  I have looked over this multiple times and can not figure it out.  Much appreciation.

 

 

 

[fenway]

See how many rows you're getting back... also, I don't know if _array() defaults to ASSOC.