[RESOLVED] Conditional Region

[RobertSmith]

Hi,
Trying hard to get a conditional region issue resolved. Sorry to post a lengthy code, but won't help none if I don't. What I want is to show "There wasn’t a result for your search." if the db query result is empty. Basically the code was written by someone else, whom I don't have access now. Thanks in advance for any help. The code is as below:

<?php
require( 'lib/config.php' );
$table_name = 'tablename';
$action = $_REQUEST['action'];
$result = "";

function truncate ($string, $rep = '', $max = 50) {
$leave = $max - strlen ($rep);
return substr_replace($string, $rep, $leave);
}

if($action == 'search'){

$event = $_POST['event'];
switch ($event) {
	case 1:
	  $dat1 = " (type = 1 or type = 4 or type = 0) ";
	  break;
	case 2:
	  $dat1 = " (type = 1 or type = 0) ";
	  break;
	case 3:
	  $dat1 = " type = 4 ";
	  break;
	default:
	  $dat1 = "";
}

$meeting = $_POST['meeting'];
switch ($meeting) {
	case 1:
	  $dat2 = " meetingCap >= 10 and  meetingCap <= 50 ";
	  break;
	case 2:
	  $dat2 = " meetingCap >= 50 and  meetingCap <= 100 ";
	  break;
	case 3:
	  $dat2 = " meetingCap >= 100 and  meetingCap <= 500 ";
	  break;
	case 4:
	  $dat2 = " meetingCap >= 500 and  meetingCap <= 1000 ";
	  break;
	case 5:
	  $dat2 = " meetingCap > 1000 ";
	  break;
	default:
	  $dat2 = "";
}

$loc = $_POST['loc'];
switch ($loc) {
	case 1:
	  $dat3 = " location = 'City' ";
	  break;
	case 2:
	  $dat3 = " location = 'Beach' ";
	  break;
	case 3:
	  $dat3 = " location = 'Country' ";
	  break;
	case 4:
	  $dat3 = " location = 'Marina' ";
	  break;
	default:
	  $dat3 = "";
}

$stars = $_POST['stars']; 
switch ($stars) {
	case 1:
	  $dat4 = " rating = 5 ";
	  break;
	case 2:
	  $dat4 = " rating = 4 ";
	  break;
	case 3:
	  $dat4 = " rating = 3 ";
	  break;
	default:
	  $dat4 = "";
}

$where = "";
if ($event != 0 || $meeting != 0 || $loc != 0 || $stars != 0) {
	$where = " where ";
}

$SQL_Q = "SELECT * FROM " . $table_name. $where. $dat1;

if ($dat1 != "") {
	if ($dat2 != ""){
		$SQL_Q .= "and ". $dat2;
	}
} else {
	if ($dat2 != ""){
		$SQL_Q .= $dat2;
	}
}

if ( $dat2 != "") {
	if ($dat3 != ""){
		$SQL_Q .= "and ". $dat3;
	}
} else if ( $dat1 != "") {
	if ($dat3 != ""){
		$SQL_Q .= "and ". $dat3;
	}
} else {
	if ($dat3 != ""){
		$SQL_Q .= $dat3;
	}
}

if ( $dat3 != "") {
	if ($dat4 != ""){
		$SQL_Q .= "and ". $dat4;
	}
} else if ( $dat2 != "") {
	if ($dat4 != ""){
		$SQL_Q .= "and ". $dat4;
	}
} else if ( $dat1 != "") {
	if ($dat4 != ""){
		$SQL_Q .= "and ". $dat4;
	}
}else {
	if ($dat4 != ""){
		$SQL_Q .= $dat4;
	}
}

// Testing
	//$SQL_Q = "SELECT * FROM " . $table_name;
	$result = mysql_query($SQL_Q);




}
?>

</td>
    <td width="664" bgcolor="#FFFFFF" valign="top"><img src="images/search-results.gif" width="664" height="88" />
      <div id="hold">
        <div id="wn">
          <div id="lyr1" class="content">
			<?php 
			if($result != "NULL") {
			while($rec = mysql_fetch_assoc($result)){
			$star = $rec['rating'];
			$pid = $rec['id'];
			$hname = $rec['name'];
			$hloc = $rec['location'];
			if($hname == 'Hotel1' or $hname == 'House') {
				$hloc = 'Marina';
			}
			?>
            <table width="664" border="0" cellspacing="0" cellpadding="0">
              <tr>

            <td width="140" rowspan="2" align="center" valign="top"><?php if (($star != 3) && ($event != 4)) {?>
            <a href="search_more.php?id=<?= $pid?>"><img src="images/logos/<?= sprintf("%03d",$pid)?>.jpg" /></a><?php } else {?><img src="images/logos/3star.jpg" /><?php } ?></td>
            <td width="304" bgcolor="#A83825" class="tableHead"><?= $hname ?></td>
            <td width="120" bgcolor="#A83825" class="tableHead"><?= $hloc ?></td>
            <td width="100" align="center" bgcolor="#A83825"><img src="images/stars<?= $star?>.gif" width="76" height="27" /></td>
          </tr>
          <tr>
            <td width="250" valign="top" bgcolor="#F0F0F0" class="table1"><?php if (($star != 3) && ($event != 4)) {?><?= truncate($rec['details'], '', 100) ?>
              <a class="more" href="search_more.php?id=<?= $pid?>">...More Details</a>                  <?php } ?></td>



<td width="200" valign="top" align="left" bgcolor="#F0F0F0" class="table1"><?php if (($star != 3) && ($star != 0)) {?>Guest Rooms:<?= $rec['guestrooms']?><?php }
else {?><a class= "more" href="http://<?= $rec['web']?>" target="_blank"><?= $rec['web']?></a>





<?php } ?><br />
                  </td>



            <td width="10" valign="top" bgcolor="#F0F0F0" class="table1">
              </td>
          </tr>
        </table>
        <?php }
		} else {?>
        <div id="lipsum">
        <table width="664" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td class="table1"><h1>There wasn’t a result for your specific search.</h1>

</td>
              </tr>
            </table>

        <?php }?>
</td>

  </tr>
</table>
</body>
</html>

[bpat1434]

Since mysql_query() will return a boolean FALSE on failure or a resource otherwise, you can simply do:

if($result)
{
    // There were results
}
else
{
    // There were no results
}

[NogDog]

bpat1434;10927057 wrote:

Since mysql_query() will return a boolean FALSE on failure or a resource otherwise, you can simply do:

if($result)
{
    // There were results
}
else
{
    // There were no results
}

Hmmm....that depends on what is meant by "There wasn't a result..." The above would be correct if an invalid query were submitted to MySQL, but not if the issue is a valid query that returned 0 rows (no matches). In that case, [man]mysql_num_rows/man would be your friend.

if($result == false)
{
   echo "Bad query. Bad query.";
}
elseif(mysql_num_rows($result) == 0)
{
   echo "No match found for your query";
}
else
{
   // display the query results....
}

[RobertSmith]

Thanks for your help. I understood the concept, but while doing the script I fail. Lack of PHP knowledge :mad:

However I identified the region where it happens.

		<?php 
			if($result != "NULL") {
			while($rec = mysql_fetch_assoc($result)){
			$star = $rec['rating'];
			$pid = $rec['id'];
			$hname = $rec['name'];
			$hloc = $rec['location'];

		?>

After $hloc = $rec['location'];, I added

if(mysql_fetch_assoc($result) == 0)
			{
   			echo "No match found for your query";
			} 

But this didn't echo "No match..." for empty results.

Should it be mysql_fetch_assoc or something else? Again, is it ($result) or $rec?

Sorry for being dump.

[bpat1434]

You would check in between if($result != "NULL") and while(). So your code could look like:

<?php
if($result != "NULL") {
  if(mysql_num_rows($result) > 0) {
    while($rec = mysql_fetch_assoc($result)){
            $star = $rec['rating'];
            $pid = $rec['id'];
            $hname = $rec['name'];
            $hloc = $rec['location'];
    }
  } else {
    // No results
  }
}
            ?>

[RobertSmith]

			<?php 
			if($result != "") {
			while($rec = mysql_fetch_assoc($result)){
			?>

is what I wanted. Struggled a lot to get this:evilgrin:

Thanks for all the help guys.

[bpat1434]

Don't forget to mark this as resolved if it is