Jump to content

Echo query results


rdub

Recommended Posts

Probably should have shown this

 

<?

// If you have selected from list box.

if(isset($select)&&$select!="" && $select != "--select--" ){

 

// Get records from database (table "members").

$result=mysql_query("select * from members where Category_Listing='$select'");

 

echo "<h1>".$select."</h1><br>";

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

 

 

 

 

?>

</p>

<table width="250" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>

    <td><span class="style1"><strong>

      <?

 

 

echo $row['Customer']; ?></strong></span></td>

  </tr>

  <tr>

    <td align="left"><span class="style1"><? echo $row['Sub_Category']; ?></span></td>

  </tr>

 

  <tr>

    <td><span class="style1"><? echo $row['Phone']; ?></span></td>

  </tr>

  <tr>

    <td><span class="style1">

<?

if( $row['Fax'] != "") {

echo "Fax " . $row['Fax'];

}

?>

</span></td>

  </tr>

  <tr>

    <td><span class="style1">

<?

if( $row['Description'] != "" && $row['Email'] != "") {

echo '<a href="mailto:'.$row['Email'].'">'.$row['Email']."</a>";

}

?>

</span></td>

Link to comment
https://forums.phpfreaks.com/topic/93615-echo-query-results/#findComment-479694
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.