<div dir="ltr">Hello,<div class="gmail_extra"><br><br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
Thanks for that - getting there now - now have:<br>
<br>
<br>
echo "All Repairs Needed";<br>
$query = "SELECT <a href="http://property.id" target="_blank">property.id</a>, property.address1, property.address2, repairs.repairtype, repairs.lastinspectedby, repairs.timelogged<br>
FROM property, repairs<br>
WHERE <a href="http://property.id" target="_blank">property.id</a> = repairs.pid";<br>
<br>
Which as a mysql select query gives me what I want, having trouble with creating page<br>
<br>
adding this<br>
$result = mysql_query($query);<br>
$num_rows = mysql_num_rows($result);<br>
$row = mysql_fetch_array($result);<br>
for($i=1; $i <= $num_rows; $i++)<br>
<br>
{<br>
print("<TD wrap style=\"wrap: 1 solid #800000\">".$row["repairtype"]<u></u>." </td>");<br>
(more rows)<br>
}<br>
<br>
just prints the first line of data over and over again.<br>
<br>
how do I get it to clock up and print the next row?<br>
<br></blockquote><div><br></div><div>The problem is how you fetch the data from the database. mysql_fetch_array returns only one row (<a href="http://php.net/manual/en/function.mysql-fetch-array.php" target="_blank">http://php.net/manual/en/function.mysql-fetch-array.php</a>). You want to warp it in a while:</div>
<div><br></div><div>while($row = mysql_fetch_array($result)) {</div><div> print("<TD wrap style=\"wrap: 1 solid #800000\">".$row["repairtype"]<u></u>." </td>");</div>
<div>}</div><div><br></div><div>Constantin</div></div></div></div>