PHP Code help please

they are a pain aren't they!!!

http 500 error now :( DOH!!

Think i got the fix for it all hahaha (famous last words) once again silly " go back to the code from a while back (should just be copy and paste and see the fix in red.

Cheers
Josh

Quote:

Originally Posted by Phoenix

//connect to the database
$dbhandle = mysql_connect($hostname, $username, $password)or die("Unable to connect to MySQL");
//select a database to work with
$selected = mysql_select_db($dbname,$dbhandle) or die("Could not select examples");
$result = mysql_query("SELECT membership.membership_no, membership.name_public, membership.state"
. " FROM membership ");
//fetch tha data from the database
echo "<center><table width=600 border=0 cellspacing=8 cellpadding=0>";
while ($row = mysql_fetch_array($result)) {echo "
<tr bgcolor=#CCCCCC>
<td colspan=4>REMLR No. ".$row{'membership_no'}."
</td>
</TR>
<TR>
<td colspan=4>".$row{'name_public'}."
</td>
</TR>";
$result2 = mysql_query("SELECT arn.ARN, census.census_short, arn.vehicle_name"
. " FROM arn INNER JOIN"
. " mem2arn ON arn.ARN = mem2arn.ARN INNER JOIN"
. " census ON arn.census = census.census RIGHT OUTER JOIN"
. " membership ON mem2arn.membership_no = membership.membership_no"
. " WHERE mem2arn.membership_no = " . $row{membership_no}
. " ORDER BY arn.ARN");
while ($secondrow = mysql_fetch_array($result2)) {echo "
<tr>
<td width=150> 
</td>
<td>".$secondrow{'ARN'}."
</td>
<td> -
</td>
<td> ".$secondrow{'census_short'}. "
</td>
</tr>";
}
echo"
<TR>
<td colspan=4 align=right>".$row{'state'}."
</td>
</TR>";
}
echo "</table></center>";
?>

You are a LEGEND my friend, it works!!!!!!!!!!!!!

No problems a pleasure to help

Quote:

Originally Posted by josh aka sean

No problems a pleasure to help

I have let the thanks button do the talking. :)

Good on you for pitching in! ;)

Good one Josh

Sorry, I have been away all day so couldn't follow up on my first post.
Well done Josh, thats exactly what I meant. Thanks for taking the time to untangle the queries.

Mike