Displaying Results

Anon

I am working on a site http://www.laketravis360.com/dining.php

Do a simple search.

As you can see from the results page, it should show the restaurant name, address, map, email, etc..

If a particular restaurant does not have a email address or a website is there a way to not make a hyperlink?

Below is the printf statement I am using in my code.

{
printf("<td class=reg><span class=busname><A HREF=\"details.php?recordid=$row->recordid\">$row->company</A></span> -- (%s%s)</td></tr><tr><td class=reg>%s %s, %s %s %s</td></tr><tr><td class=listing><a href=\"$row->map\" target=\"_blank\">Map</a> | <a href=\"mailto:$row->email\">Email</A></td></tr><tr><td><hr></td></tr>\n",
$row->cuisine1, $row->cuisine2, $row->address, $row->city, $row->state, $row->zip, $row->phone);
}

Thanks - Mark

philsown

2 things:

Either make the word "Email" in to the actual email with

Then have the email var twice in your printf arg list. If the href is empty, it won't show up.

Or break up your statement in to smaller blocks and control the output with if statements:

echo ( ! empty ( $row['email'] ) ) ? "<a href=\"mailto:" . $row['email'] . "\">Email</a>" : null ;

Good luck.

Anon

Not exactly sure how to integrate the echo statement in my printf statement. Any thoughts?

Thanks - Shawn

Anon

There's no need for a printf at all, what you have there is kind of strange looking with the mixture of php variables and %s inside the quotes. Don't be afraid to mix HTML and php code; php was designed to produce HTML, just use it.

<tr>
<td class=reg><span class=busname>
<A HREF="details.php?recordid=<?=$row->recordid?>"><?=$row->company ?></A></span> -- (<?=$row->cuisine1 . " " . $row->cuisine2 ?>)</td></tr>
<tr><td class=reg><?=$row->address . " " . $row->city . ", " . $row->state . " " . $row->zip . " " . $row->phone?></td></tr>
<tr><td class=listing><a href="<?=$row->map?>" target="_blank">Map</a>
<? if ($row->email != null) {
?>
| <a href="mailto:<?=$row->email?>">Email</A>
<? } ?>
</td></tr>
<tr><td><hr></td></tr>

Anon

Still having trouble putting it into action.. Below is the code I am using.

<?
mysql_select_db($selectdb);

$query1 = "SELECT recordid, company, address, city, state, zip, phone, map, email, cuisine1, cuisine2 FROM restaurants ";

				if($cuisine != "Display All") 
				{ 
				$wherecuisine = "(cuisine1 LIKE '%$cuisine%' OR cuisine2 LIKE '%$cuisine%') "; 
				} 

				if($location != "Display All") 
				{ 
				$wherelocation = "(location LIKE '%$location%' OR city LIKE '%$location%' OR area LIKE '%$location%') "; 
				} 

				if($wherecuisine || $wherelocation) 
				$query1 .= "where "; 

				if($wherecuisine) 
				$query1 .= $wherecuisine; 

				if($wherecuisine && $wherelocation) 
				$query1 .= "and ".$wherelocation; 

				if(!$wherecuisine && $wherelocation) 
				$query1 .= $wherelocation;

				$query1 .= "limit $offset,$limit"; 

				$query_results = mysql_db_query("$selectdb","$query1");

				echo "<table width=100% border=0 cellspacing=0 cellpadding=3>\n";
				echo "<tr>\n"; 

				if ($row = mysql_fetch_array($result)) {
				while($row = mysql_fetch_object($query_results)) 

				{
				    	printf("<td class=reg><span class=busname><A HREF=\"details.php?recordid=$row->recordid\">$row->company</A></span> -- (%s%s)</td></tr><tr><td class=reg>%s %s, %s %s %s</td></tr><tr><td class=listing><a href=\"$row->map\" target=\"_blank\">Map</a> | <a href=\"mailto:$row->email\">Email</A></td></tr><tr><td><hr></td></tr>\n",
						$row->cuisine1, $row->cuisine2, $row->address, $row->city, $row->state, $row->zip, $row->phone);
				}

				} else printf("<td class=reg><font face=Verdana, Arial, Helvetica, sans-serif size=2>Sorry, no results were found! - <a href=dining.php>Start a new search</a></font></td>");

				echo "<tr>\n";
				echo "<td class=reg>\n";

Anon

Just replace your printf with what I posted before. Put >? <? around it so you are in HTML instead of php. Echoing or printing HTML is unnecessary, just drop out of.

It's an odd paradigm for someone used to normal programming languages, but it's a lot easier to mix script with HTML than to use the script to print or echo HTML.