MySQL & PHP

**Voetsjoeba** · June 18th, 2003, 02:07 PM

Hi everybody, me again

I got the MySQL tables to work at last. What I have now is a table called news, in which there are 4 fields and two rows of data. See the image below:

[EDIT] Image taken out due to server downtime[/EDIT]

So I have this script to put the data in a table.

PHP Code:


<?php

mysql_connect("hostname","username","password");

mysql_select_db("mydatabase");



$qr = mysql_query("SELECT * FROM news");



$nrows = mysql_num_rows($qr);

for ($i=0; $i < $nrows; $i++) {

  $row = mysql_fetch_array($qr);

}



?>

<html><head></head><body>

<table border="0" cellpadding="0" width="50%" cellspacing="0" height="124">

  <tr>

    <td width="100%" bgcolor="#FFFFCC" height="21"><? echo "<b>".$row['titel']."</b>&nbsp;&nbsp;&nbsp;".$row['datum'];?></td>

  </tr>

  <tr>

    <td width="100%" bgcolor="#FFFFFF" height="103"><? echo $row['inhoud']."<br>";?></td>

  </tr>

</table>

</body>

</html>

This works fine so far, see an example of one the created table here. The problem is, how can I automatically add a table (in the PHP file, not in the database) when I add a new row of data to the database ? I had one row first, and it worked fine, but when I added one, the script I have now shows the second one one instead of the first.

Can someone help me out please ?

**Jubba** · June 18th, 2003, 02:24 PM

This code should work:

PHP Code:


<html><head></head><body>

<table border="0" cellpadding="0" width="50%" cellspacing="0" height="124">



<?

mysql_connect("hostname","username","password");

mysql_select_db("mydatabase");



$qr = mysql_query("SELECT * FROM news");



$nrows = mysql_num_rows($qr);

for ($i=0; $i < $nrows; $i++) {

  $row = mysql_fetch_array($qr);

  print "<tr><td width=\"100%\" bgcolor=\"#FFFFCC\" height=\"21\"><b>" . $row['titel'] . "</b>&nbsp;&nbsp;&nbsp;" . $row['datum'] . "</td></tr>";

  print "<tr><td width=\"100%\" bgcolor=\"#FFFFFF\" height=\"103\">" . $row['inhoud'] . "</td></tr>";

}

?>

</table>

</body>

</html>

**Voetsjoeba** · June 18th, 2003, 02:32 PM

Thanks Jubba

! Works like a charm !

**Voetsjoeba** · June 20th, 2003, 11:12 AM

Hey Jubba, is it possible to get this auto-add feature into Flash (MX)? I know I might be asking a lot, but it would make my life so much better ...

**Jubba** · June 20th, 2003, 11:37 AM

yes but its not really a simple process... i have to go now, I'll give you a hand later on.

**Voetsjoeba** · June 20th, 2003, 11:39 AM

Thanks m8

**eyezberg** · June 20th, 2003, 05:40 PM

replace the 2 print lines by
output="";

output.="&titel".$i."=".$row['titel'];
output.="&content".$i."=".$row['inhoud'];

print $output;

(not tested..)

then in flash, use the titel1="....", titel2="....", content1="....",
variables as you want...