[SOLVED] MySQL isset

[maxudaskin]

Is there a way to use isset on a MySQL LONGTEXT data?

 

<?php
		  $book_data_sql = mysql_query("select * from flights WHERE flight_num = '{$fltnum}'");
						while($book_data = mysql_fetch_array($book_data_sql)){
		  if(!isset($book_data['route'])){
                echo '<textarea name="route" rows="5" id="route" style="width:100%"></textarea>';
			}else{
			echo '<textarea disabled name="route_disabled" rows="5" id="route" style="background:url(../images/route_bkg.jpg) no-repeat; width:100%">'.$route.'</textarea>';
			echo '<input name="route" type="hidden" value="$route" />';
			}}
		  ?>

 

 

Even if there is no data in the table, it still shows the disabled text area.

[redarrow]

try empty

[maxudaskin]

What do you mean 'try empty'?

[revraz]

if(!empty($book_data['route'])){

 

isset checks to see if its set or not, not if it's empty.  So you can either check empty or ==""

[teng84]

double post  disable the other thread....!!

http://www.phpfreaks.com/forums/index.php/topic,175925.new.html#new