show text type

[putraaridana]

hi
i have mysql table which has
field1=varchar
field2=text

how i can show the content of filed 2. it's seems diffrent from char
the way it's display here's my code

<?php 
	require_once("connect.php");
	mysql_select_db("dbname"); 

$result = mysql_query("SELECT countries_id, countries_name FROM countries "); 

while ($row = mysql_fetch_row($result)) { 

$c_id = $row[0]; 
$c_name =$row[1]; 

print($c_id);
print($c_name); 

} 
?>

[rachel2004]

I'm not sure what you're asking. Can you explain what you need help with?

Consider mysql_error() in your code to help you troubleshoot:

$result = mysql_query("SELECT countries_id, countries_name FROM countries ")
    or die(mysql_error());

[putraaridana]

i mean
why print($c_name); didn't show anything, is it because
it has text field type ?
thanks rachel

[rachel2004]

No, a column data type of "text" will work with your code.

Can you try the code I posted and tell me if you get an error message? Does print($c_id) display anything in your browser? If yes, then make sure you have values in the "countries_name" column of your table.

If nothing is being displayed (and in lieu of you describing what you are seeing so far), my next guess is that you are not connecting with your database via a link resource. You need something like this:

$result = mysql_query("SELECT countries_id, countries_name FROM countries", $db_conn)
    or die(mysql_error());