[Wolves] Mysql join help

Wayne Morris waynelists at machx.co.uk
Tue Jul 2 17:48:22 UTC 2013

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, 
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 


More information about the Wolves mailing list