[Resolved] Testing for EMPTY feild in table

[dcjones]

Hi all,

I have had a good look around the board for posts on empty records but have not been able to find a solution.

I have the following code:

mysql_select_db($database_Chandos, $Chandos); 
$recordID = $_GET['recordID'];     

$query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");  


$row = mysql_fetch_array($query_DetailRS1);  

$broken = explode("*", $row_DetailRS1['key_features']);  

$countbroken = count($broken);  

echo "<uL>";  

FOR($i = 0; $i < $countbroken; $i++){  

  echo "<LI>".$broken[$i]."</LI>";  

}  

echo "</uL>"; 

I need to test the "key_features" feild in the table to find out if it is empty.

If it is empty do not complete the script.

Can anyone help

[devinemke]

$row = mysql_fetch_assoc($query_DetailRS1); 
if ($row['key_features'])
{
// do something
}
else
{
// don't do something...or perhaps do something else
}

[dcjones]

Hi all,

Can anyone see what is wrong with this code, it shows an error "Parse error: parse error, unexpected T_ELSE in /homepages/41/d43000764/htdocs/chandos/catalogue/record_detail.php on line 352" Line 352 is where the ELSE statement is.

$row = mysql_fetch_assoc($query_DetailRS1);  

if ($row['key_features']) 
{

$broken = explode("*", $row_DetailRS1['key_features']);  

$countbroken = count($broken);  

echo "<uL>";  

FOR($i = 0; $i < $countbroken; $i++){  

  echo "<LI>".$broken[$i]."</LI>";  

}  

echo "</uL>";
else 
{ 
echo $row_DetailRS1['content'];
}

[Weedpacket]

Originally posted by dcjones
...unexpected T_ELSE in /homepages/41/d43000764/htdocs/chandos/catalogue/record_detail.php on line 352" Line 352 is where the ELSE statement is.

You're missing a } after echo "</ul>";

[dcjones]

Hi and thanks for your reply.

Just as your reply came I spotted the error, but thanks anyway for looking.

I have correct the script but it is still not doing what I want it to do.

When the script runs I want to test for data in the "key_features" feild. What I have is :

$row = mysql_fetch_assoc($query_DetailRS1);  

if (empty($row['key_features']) )
{
echo;

} else { 
$broken = explode("*", $row_DetailRS1['key_features']);  

$countbroken = count($broken);  

echo "<uL>";  

FOR($i = 0; $i < $countbroken; $i++){  

  echo "<LI>".$broken[$i]."</LI>";  

}  

echo "</uL>";
}

But when I run the script it does not show any data for the "key_features" feild even when there is data to display.

Any ideas.

[tsinka]

Hi,

I think it should be

$broken = explode("*", $row['key_features']);

instead of

$broken = explode("*", $row_DetailRS1['key_features']);

Additionally, you might want to put either error_reporting(E_ALL) or ini_set("error_reporting",E_ALL) on top of your scripts.

Thomas

[dcjones]

Hi, thanks for your reply.

If I use the following code:

$row = mysql_fetch_array($query_DetailRS1);   

$broken = explode("*", $row_DetailRS1['key_features']);   

$countbroken = count($broken);   

echo "<uL>";   

FOR($i = 0; $i < $countbroken; $i++){   

  echo "<LI>".$broken[$i]."</LI>";   

}   

echo "</uL>";

the output is correct, ie any data in the "key_features" feild is displayed useing bullet points.

IF there is NO data in the "key_features" feild it just displays an empty bullet point which looks untidy.

What I want the script to do is display the data when there is data and to display nothing when there is no data.

Can this be done, I 'm sure it can.

[tsinka]

Hi,

one more question:

You have

$row = mysql_fetch_array($query_DetailRS1);

but then
$broken = explode("*", $row_DetailRS1['key_features']);

using $row_DetailRS1 ... looks suspicious ...

To solve your problem:
Just insert some code that checks if $row_DetailRS1['key_features'] contains some data (strlen, empty,....).

If it is not empty echo the complete <ul>bullets</ul> part.

Thomas

[dcjones]

Hi all,

I have solved my problem useing the following code:

$row = mysql_fetch_array($query_DetailRS1);   

if (strlen ($row_DetailRS1['key_features']) == 0)
{
echo "";
}
else
{
$broken = explode("*", $row_DetailRS1['key_features']);   

$countbroken = count($broken);   

echo "<uL>";   

FOR($i = 0; $i < $countbroken; $i++){   

  echo "<LI>".$broken[$i]."</LI>";   

}   

echo "</uL>";
}

It works as I need it to. It may be untidy code but it works.

Anyone have any comments.

Thanks All.

[tsinka]

Hi,

a shorter way is:

$row = mysql_fetch_array($query_DetailRS1);    

if (strlen ($row_DetailRS1['key_features']) > 0)  { 
  $broken = explode("*", $row_DetailRS1['key_features']);    

  $countbroken = count($broken);    

  echo "<ul>";    

  for ($i = 0; $i < $countbroken; $i++){    

    echo "<li>".$broken[$i]."</li>";    

  }    

  echo "</ul>"; 
}

Thomas

[dcjones]

Hi Thomas.

Thanks for your help. I will now use your last reply.