[Wolves] Mysql join help

[Wayne Morris]

On 28/06/2013 18:48, Constantin Orăsan wrote:
>
> The problem is how you fetch the data from the database. 
> mysql_fetch_array returns only one row 
> (http://php.net/manual/en/function.mysql-fetch-array.php). You want to 
> warp it in a while:
>
> while($row = mysql_fetch_array($result)) {
> print("<TD wrap style=\"wrap: 1 solid #800000\">".$row["repairtype"]." 
> </td>");
> }
>
> Constantin
>
Quick extra for bonus point:
echo "All Repairs Needed<br>";
$query = "SELECT property.id, property.address1, property.address2, 
repairs.repairtype, repairs.lastinspectedby, repairs.timelogged, 
repairs.notes
FROM property, repairs
WHERE repairtype property.id = repairs.pid
ORDER BY repairs.lastinspectedby

works fine, if I change it to DESCending it misses out the very latest 
record?

cheers