Dynamic Tables?

7724

Hi Guys,

I have a table with 3 rows which interrigates an MySQL database for data:

<table width="100%" border="0">
  <tr>
    <td width="33%"><?php echo $name; ?></td>
    <td width="33%"><?php echo $by; ?></td>
    <td width="33%">CLICK HERE LINK????</td>
  </tr>
</table>

Now this MySQL database can have lots of records in one table given unique id's as they are added in an admin section, so I want my php page to do two further things:

1) Dynamically insert another 3 rows or every record there is in my MySQL database table named 'cinema_reviews'.

2) In the last table row dynamically display the link or each particular record which reads 'click here'.

Not sure how to do this though - anyone got any ideas?

Chris

thorpe

easy enough. as you loop through your results, create the new rows. as for the link thing. ive got this link pointing to another php script called more.php. im passing an id, so that in the more.php script you could do another query based on that id.

while ($row = mysql_fetch_assoc($result)) {
  echo '  <tr>'.
       '    <td width="33%">'.$row['name'].'</td>'.
       '    <td width="33%">'.$row['by'].'</td>'.
       '    <td width="33%"><a href="more.php?id='.$row['id'].'">click here</a></td>'.
       '  </tr>';
}
echo '</table>';

hope this helps.

7724

Thanks,

That makes more sense, although it's throwing up an error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/website/public_html/ents/templates/reviews_index.php on line 81

Any ideas, I know it's something to do with the $result variable line. I don't understand where that comes from?

planetsim

thorpe was showing an example, you will need to change that to how you are calling the Query.

e.g.

$result = mysql_query("SELECT * FROM mytbl");

7724

agghh, I see! Thanks Guys 😃 😃 😃 😃