Loop data into tables and links(newbie alert!)

[doucie]

OK, I need to get all the results from the database and enter into a table, which the code below does quite nicely, however, I need one of the fileds to be a link in each row.  How do I change the loop??



$query="SELECT query_number, query_type, query_status, client, client_ref, debt_ref, query_date, user
FROM query
ORDER BY query_number";

$results=mysql_query($query)
or die(mysql_error());

echo "<table width=\"100%\" border=\"3\" align=\"center\" bordercolor=\"#000099\" cellspacing=\"0\" cellpadding=\"5\"
<tr><td>Query Number</td>
<td>Query Type</td>
<td>Status</td>
<td>Client</td>
<td>Client Ref</td>
<td>DebtRef</td>
<td>Date/Time Entered</td>
<td>User</td>
</tr> ";

while ($row=mysql_fetch_assoc($results)){
echo "<tr>";
foreach($row as $value){
echo "<td>";
echo $value;
echo "</td>";
}
echo "<tr>";
}
echo "</table>";
?>

[Solarpitch]

Try Something like...

[code]
while($row = $result->fetch_assoc())
  {
 
 
  echo "<tr  >";
 

echo "<td></td>";

  echo "<td>" . $row['Column_name_1'] . "</td>";
  echo "<td>" . $row['Column_name_1'] . "</td>";
  echo "<td>" . $row['Column_name_1'] . "</td>";
  echo "<td>" . '€' . $row['Column_name_1'] . "</td>";

  echo "<td'><a href=\"newpage.php?member=". $row['database_id'] ."\">Next Page</a></td>";

  echo "</tr >";
 
  }
[/code]

This code might be missing a bracket or two so I wouldnt recommend a copy and paste job!

[doucie]

It didn't like line 34(Fatal error: Call to a member function fetch_assoc() on a non-object in C:\wamp\www\Query System\index.php on line 34)

Line 34 is
while($row = $result->fetch_assoc())
  {

[Solarpitch]

Heres some code the way I implement it. This code works for me.

[code]

$mysql_connect = new mysqli("localhost", "root", "password");
$mysql_connect->select_db('myDatabaser');

$result = mysqli_query($mysql_connect, "SELECT * FROM Table ");

while($row = $result->fetch_assoc())
{

  echo "<tr>";
  echo "<td>" . $row['header'] . "</td>";
  echo "<td>" . $row['offwant'] . "</td>";
  echo "<td>" . $row['price'] . "</td>";
  echo "<td>" . $row['class'] . "</td>";

  echo "<td><a href=\"newpage.php?member=". $row['member_id'] ."\">View New Page>></a></td>";

  echo "</tr >";

  }

echo "</table >";
}

[/code]

[doucie]

Stumbles at

while($row = $result->fetch_assoc())
{

every time.  What does -> mean or do??  I did say newbie!!