[RESOLVED] Automatically Adding Rows to an HTML Table

[M-78]

I am trying to code a script for a project that allows bands to add / edit / delete shows whenever they need to.

The script posts the most important information in an HTML table in the shows.php page, and in the last column of that table there's a link for "More info" which brings up a pop-up window.

How do I go about making the script add another row to my HTML table whenever a new show is added to the database?

Thanks in Advance

[jeepin81]

Post the code u are working w/ sooo we know where u are coming from.....

Best-
J.

[M-78]

<?php
  $dbh = mysql_connect ("localhost", "db", "pw") or die ("Couldn't connect to database.");
  mysql_select_db ("db", $dbh) or die ("<p>Could Not Select the database!");
/* write the SQL */
$sql = "SELECT * FROM showtest ORDER BY id desc";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
/* check for an error with the query */
if (!$result)
{
  /* if there is a problem with the query - tell me and display
     any error messages given then stop the program 
     gracefully */
  echo 'Error with the query.  Message returned: ' . 
    mysql_error();
  die;
}
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td><div align="center">DATE</div></td>
    <td><div align="center">COST</div></td>
    <td><div align="center">VENU</div></td>
    <td><div align="center">ADDRESS</div></td>
  </tr>
  <tr> 
    <td> 
      <? 
  echo $row['showdate'];
?>
      <div align="center"></div></td>
    <td><? echo $row['showcost']; ?> <div align="center"></div></td>
    <td> 
      <? 
  echo $row['showvenu'];
?>
      <div align="center"></div></td>
    <td> 
      <? 
  echo $row['showaddress'];
?>
      <div align="center"></div></td>
  </tr>
</table>

Obviously, the look isn't really that important right now. I just want to get the code working

[Popcorn]

Hi, i think i have a solution for you. To add a new row do something on the lines of ...

<?php

echo "<tr>";
echo "<td>";
echo "text goes in here";
echo "</td>";
echo "</tr>";

?>

Loop it if you want to add more rows.

[M-78]

Thanks for the response...i'm on the right track in terms of looping. This is what my code looks like, but it doesn't show any of my information from the database (please note that the SQL connection statement and the opening PHP tag was cut out, cuz they're irrelevant)

$sql = "SELECT * FROM showtest ORDER BY id desc";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
/* check for an error with the query */
if (!$result)
{
  /* if there is a problem with the query - tell me and display
     any error messages given then stop the program 
     gracefully */
  echo 'Error with the query.  Message returned: ' . 
    mysql_error();
  die;
}
  echo "<table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr>
         <th>Date</th>
         <th>Cost</th>
         <th>Venu</th>
		 <th>Address</th>
         </tr>";

/* begin loop */
$i=0;
while ($i < $num) {

/* define variables */
$variable1=mysql_result($result,$i,'showdate');
$variable2=mysql_result($result,$i,'showcost');
$variable3=mysql_result($result,$i,'showvenu');
$variable4=mysql_result($result,$i,'showaddress');

 echo "<td> $variable1 </td>
       <td> $variable2 </td>
       <td> $variable3 </td>
       <td> $variable4 </td>";

$i++;
}

echo "</table>";
?>

[Installer]

$sql = "SELECT * FROM showtest ORDER BY id DESC";
if (!($result = mysql_query($sql))) {
    die('Error with the query. Message returned: ' . mysql_error());
}

echo '<table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
      <th>Date</th>
      <th>Cost</th>
      <th>Venu</th>
      <th>Address</th>
      </tr>';
while ($row = mysql_fetch_assoc($result)) {
    echo '<tr>' .
         '<td>' . $row['showdate']    . '</td>' .
         '<td>' . $row['showcost']    . '</td>' .
         '<td>' . $row['showvenu']    . '</td>' .
         '<td>' . $row['showaddress'] . '</td>' .
         '</tr>';
}
echo '</table>';

[Popcorn]

Try this one.

$query = "SELECT * FROM showtest ORDER BY id desc";
$result = mysql_query($query) or die(mysql_error()) ;
$row = mysql_fetch_assoc($result) or die(mysql_error());
echo "<table width=100%> 
         <tr>
         <th>Date</th>
         <th>Cost</th>
         <th>Venu</th>
         <th>Address</th>
         </tr>";
while($r=mysql_fetch_array($result)) {

echo "<td> $r['showdate']; </td>
           <td> $r['showcost']; </td>
           <td> $r['showvenu']; </td>
           <td> $r['showaddress']; </td>";
}
 mysql_close();
 echo "</table>";
?>

Edit : Darn it, was too slow this time! 🙂

[M-78]

Thanks for your help guys

Couldn't have done it without you 🙂