Forum Moderators: coopster
<?php
require ('dbconnect.inc');
$query_state = "select state from States;";
$result_state = mysql_query($query_state);
$query_city = "select city from Cities;";
$result_city = mysql_query($query_city);
$query_venue = "select venue from Venues;";
$result_venue = mysql_query($query_venue);
if (mysql_num_rows($result_state) == 0 ¦ mysql_num_rows($result_city) == 0 ¦ mysql_num_rows($result_venue) == 0){
echo 'nothing here...';
}
else{
while ($row1 = mysql_fetch_assoc($result_state) ¦ ($row2 = mysql_fetch_assoc($result_city) ¦ ($row3 = mysql_fetch_assoc($result_venue)){
echo "<tr>";
$out = "<td width='33%' align='center' valign='top'>"."<div align='center'>";
echo $out;
echo $row1['state'];
echo "</td>";
$out = "<td width='33%' align='center' valign='top'>"."<div align='center'>";
echo $out;
echo $row2['city'];
echo "</td>";
$out = "<td width='34%' align='center' valign='top'>"."<div align='center'>";
echo $out;
echo $row3['venue'];
echo "</td></tr>";
}
}
?>
and here is what I am seeing:
"; $out = ""; $out = ""; $out = ""; } }?>
Some Artist State Some Artist City Some Artist Venue
"."
"; echo $out; echo $row1['state']; echo "
"."
"; echo $out; echo $row2['city']; echo "
"."
"; echo $out; echo $row3['venue']; echo "
each appear in the row they should
And welcome to Webmaster World