Dreamweaver MX and MySQL - setting up a table...

[Rivulent]

I would like to have a table which retrieves all the results. this is the code I'm using the retrieve the data:

<table width="100%" border="0" cellspacing="0" cellpadding="3">
  <tr>
    <td><?php echo $row_Skils['skill_id']; ?></td>
    <td><?php echo $row_Skils['skill_name']; ?></td>
    <td><?php echo $row_Skils['skill_description']; ?></td>
    <td><?php echo $row_Skils['skill_picture']; ?></td>
    <td><?php echo $row_Skils['class']; ?></td>
  </tr>
</table>

However, it only comes back with the first result of the database table. I would like it to repeat row by row however many entries it's going to display, and then display all the results. How would i go about doin this?

Thanks!

[snoopy13]

hy

you just do the fallowing:

after making the mysql_query you do:

<?php

while(mysql_fetch_array($query)){;?>

<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td><?php echo $row_Skils['skill_id']; ?></td>
<td><?php echo $row_Skils['skill_name']; ?></td>
<td><?php echo $row_Skils['skill_description']; ?></td>
<td><?php echo $row_Skils['skill_picture']; ?></td>
<td><?php echo $row_Skils['class']; ?></td>
</tr>
</table>
<?php
}
?>
the while thing makes the table to repeat itself for every row.

[Rivulent]

When I use that code, nothing appears.

I connect via this code :

<?php 

mysql_connect("host","name","pass") or die ("Unable to connect to MySQL server."); 
$db = mysql_select_db("database") or die ("Unable to select requested database."); 
?> 
<?php require_once('Connections/WarcraftGenerations.php'); ?>

Now of course I do have my host name/name/pass filled out right, I just shielded it for security.
What am I missing? Something to declare the variables?

[snoopy13]

the code I've posted was just the second part of the whole thing..

in total it would say:

<?php require_once('Connections/WarcraftGenerations.php'); 

$query=mysql_query("SELECT * FROM table");
if (!$query) echo "Something wrong";

while ($array=mysql_fetch_array($query)){
?>

<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td><?php echo $array['skill_id']; ?>[/code]</td>
<td><?php echo $array['skill_name']; ?></td>
<td><?php echo $array['skill_description']; ?></td>
<td><?php echo $array['skill_picture']; ?></td>
<td><?php echo $array['class']; ?></td>
</tr>
</table>

<?php
}
?>

better?

[MasonAtom]

If you are using Dreamweaver - you can cheat by having it write the php code for you. The easiest way is to build the table, then select the entire row in your editor window, then pop over to the applications palette, click on server behaviors, then click the + bottom and select "repeat region". From there, it will ask you how many records to display from your recordset. Piece of cake. Hope this works for you.

Mason