[RESOLVED] Formatting Output from query

thejrod03

I am trying to format the data I get from a query, i can get the data to appear when I dont format it but when I try to put it into a table it doesnt work

<html>
<body>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>Origin State</th>
<th>Area</th>
<th>Destination State</th>
<th>Area</th>
<th>Load Description</th>
<th>Pay Rate</th>
<th>Contact Number</th>
</tr>
<?php


$conn = mysql_connect("mysql18.ixwebhosting.com","username","password");
mysql_select_db("jarodd_currentloads",$conn);
$query="SELECT * FROM loads_now WHERE origin_state='$_POST[origin_state]' AND origin_area='$_POST[origin_area]' AND dest_state='$_POST[dest_state]' AND dest_area='$_POST[dest_area]'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>Origin State</th>
<th>Area</th>
<th>Destination State</th>
<th>Area</th>
<th>Load Description</th>
<th>Pay Rate</th>
<th>Contact Number</th>
</tr>

<?
$i=0;
while ($i<$num){

$originstate=mysql_result($result,$i,"origin_state");
$originarea=mysql_result($result,$i,"origin_area");
$deststate=mysql_result($result,$i,"dest_state");
$destarea=mysql_result($result,$i,"dest_area");
$loaddescript=mysql_result($result,$i,"loaddescription");
$payrate=mysql_result($result,$i,"pay_rate");
$contactnum=mysql_result($result,$i,"contact_number");
?>

<tr><? echo $originstate; ?></td>
<td><? echo $originarea; ?></td>
<td><? echo $deststate; ?></td>
<td><? echo $destarea; ?></td>
<td><? echo $loaddescript; ?></td>
<td><? echo $payrate; ?></td>
<td><? echo $contactnum; ?></td>
</tr>

<?
$i++;
}

echo "</table>;
?>
</body>
</html>

cgraz

First thing I noticed was the varying use of php opening tags.

I think by default, short tags (<?) are disabled. I would try changing all of your short tags to the standard

<?php

and see if there is any difference.

I would also change your call to mysql_query( ) to this:

$result = mysql_query($query) or die(mysql_error());

and I would also

print $query . "<br />";

just to see what your query looks like that you are sending to MySQL.

Finally, if that doesn't get you the solution

print "Rows: " . mysql_num_rows($result);

and make sure you're not getting a zero. This should help you isolate your problem.

NogDog

This line...

<tr><? echo $originstate; ?></td>

...should be...

<tr>
<td><? echo $originstate; ?></td>

...(possibly changing to <?php tags as noted above).

Personally, I'd use a while loop and mysql_fetch_assoc() instead of a for loop and mysql_result():

<?php
while($row = mysql_fetch_assoc($result))
{
   echo <<<EOD
<tr>
<td>{$row['origin_area']}</td>
<td>{$row['dest_state']}</td>
<td>{$row['dest_area']}</td>
<td>{$row['loaddescription']}</td>
<td>{$row['pay_rate']}</td>
<td>{$row['contact_number']}</td>
</tr>
EOD;

}
?>