Member Avatar for diafol 
if(!mysql_affected_rows() >= 1)

Does not work with SELECT, only INSERT, UPDATE, REPLACE or DELETE.

Also you're trying to loop twice.

The function you're looking for is mysql_num_rows:

<?php
$connect=mysql_connect("localhost","root","");
$db_selected = mysql_select_db("ong_assessment", $connect)
$query = "SELECT Agent_ID,Address,Bedrooms,Price FROM suburbs";
$result = mysql_query($query) or die(mysql_error());
if(!mysql_num_rows($result) >= 1)
{
    echo 'There are no entries inside the database';
}
else
{
    echo "<table>";
    while($row = mysql_fetch_assoc($result))
    {
        echo '<tr><td>'. $row['Agent_ID'].'</td>';
        echo '<td>'. $row['Address'].'</td>';
        echo '<td>'. $row['Bedrooms'].'</td>';
        echo '<td>'. $row['Price'].'</td></tr>';
    }
    echo '</table>';
}
?>
Edited by diafol
Member Avatar for dean.ong.14 
    <head>
    </head>
    <body>
    <table border='1'>
    <tr>
    <th>Agent_ID</th>
    <th>Address</th>
    <th>Bedrooms</th>
    <th>Price</th>
    <?php
    $connect=mysql_connect("localhost","root","");
    $db_selected = mysql_select_db("ong_assessment", $connect);
    $query = "SELECT Agent_ID,Address,Bedrooms,Price FROM harcouts";
    $result = mysql_query($query) or die(mysql_error());
    if(!mysql_affected_rows() >= 1)
    {
    echo 'There are no entries inside the database';
    }
    while($row = mysql_fetch_array($result))
    {
    echo '<tr>';
    echo '<td>'. $row['Agent_ID'].'</td>';
    echo '<td>'. $row['Address'].'</td>';
    echo '<td>'. $row['Bedrooms'].'</td>';
    echo '<td>'. $row['Price'].'</td>';
    }
    echo '</table>';
    ?>
    </body>
    </html>

Unknown column 'Bedrooms' in 'field list'

Member Avatar for dean.ong.14

ignore the post i already fix it

Member Avatar for phorce

If this is solved now, please mark it so and give rep to those who helped you :)!

Member Avatar for dean.ong.14

`

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name = "description" content = "Wellington Real Estate"/>
<meta name = "keywords" content = "home, housing, Karori, Mirimar, Te Aro, Thorndon, Farcourts, Jonnys, Relax"/> 
<title> Agents </title>
<link rel = "stylesheet" type = "text/css" href = "assessment.css"/>
</head>

<body>
<div id = "wrapper">
<div id = "container">
<div id = "banner">
<h1>The Wellington Real Estate Company</h1>
</div>
<div id = "left">
<a href = "Index.html">Home</a>
<a href = "Agents.html">Agents</a>
<a href = "Suburbs.html">Suburbs</a>
</div>
<div id = "right">
<br/>
<h2>Listing of Houses by Agent</h2>
<p>All our agents are currently listing a range of properties. Please click on one of the links to see that agent's listings: </p><br/>
<a href = "Farcourts.php">Farcourts</a>

<a href = "Jonnys.html">Jonnys</a>
<a href = "Relax.html">Relax</a>
</div>
</div>
</div>
</body>
</html>

how can i link that php to html?`

Member Avatar for phorce

IF this thread has been solved, please mark is as solved and give rep to those who helped you :)!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.