[Resolved] displayed results in table problem

mndwn

Hello, I have been trying to organise the results into a table, but am having problems.

Here is the code:

if ($GET['search_hub'])
{
$sql = "SELECT routes.routeid, depart.depart, depart.departcode, arrive.arrive, arrive.arrivecode
FROM (routes INNER JOIN depart
ON routes.departid = depart.departid)
INNER JOIN arrive ON routes.arriveid = arrive.arriveid
WHERE depart.departcode = '".$GET['search_hub']."'";
$result = mysql_query($sql, $db);
print "<table border=0>";
print "<th><p>Route Code</th><th><p>Departure Airport</th><th><p>Code</th><th><p>Arrival Airport</th><th><p>Code</th>";
while
($row = mysql_fetch_array($result)){
print "<tr><td>".$row['routeid']"</td>";
print "<td>".$row['depart']"</td>";
print "<td>".$row['departcode']"</td>";
print "<td>".$row['arrive']"</td>";
print "<td>".$row['arrivecode']"</td>;
print "</table>";
}

It always comes up as an error, so how do i organse the results into a table? Thanx

dbchip2000

What is the error you get? Is it MySQL or PHP? You should also end the row tag after each row (ex. </tr>)

barand

Also there is no <tr>...</tr> at start and end of the header cells.

echo "</table>" should be after the while loop, not inside

mndwn

This is the Error:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/michael/fly-ava-www/flight.php on line 165

which is this line:

print "<tr><td>".$row['routeid']"</td>";

N.B I made the adjustments like u said.

dbchip2000

You should have (I added a period after your $row)

print "<tr><td>".$row['routeid']."</td>";

Not at all to say don't ask more questions :-)...but if you have figured out this thread, help others get help by marking this thread as Resolved

barand

'dot' missing before "</td>". Try

print "<tr><td>" . $row['routeid'] . "</td>";

mndwn

Hello, I just solved it, but thanx for the help.

I was missing the . at the end of the selected array.

This is how it should be:

if ($GET['search_hub']) {
$sql = "SELECT routes.routeid, depart.depart, depart.departcode, arrive.arrive, arrive.arrivecode
FROM (routes INNER JOIN depart
ON routes.departid = depart.departid)
INNER JOIN arrive ON routes.arriveid = arrive.arriveid
WHERE depart.departcode = '".$GET['search_hub']."'";
$result = mysql_query($sql, $db);
print "<table border=0>";
print "<tr><th><p>Route Code</th><th><p>Departure Airport</th><th><p>Code</th><th><p>Arrival Airport</th><th><p>Code</th></tr>";
while
($row = mysql_fetch_array($result)){
print "<tr><td>".$row['routeid']."</td>";
print "<td>".$row['depart']."</td>";
print "<td>".$row['departcode']."</td>";
print "<td>".$row['arrive']."</td>";
print "<td>".$row['arrivecode']."</td></tr>"; }
print "</table>";
}

Thankyou again for your help, much appreicated

barand

You still don't want the end of table tag repeated at the end of every row in the table.

Put

print "</table>";

after the closing } of the while loop.

mndwn

There are, look closely

barand

Sorry, didn't notice it over there.