Outputting data?

[7724]

Hi all,

I’m looking for some very easy(!) tutorials that will teach me how to take data from ‘x’ rows in a MYSQL table and output values in each field, so if for example if I had a html table like this:

<table width="95%" border="0">
  <tr bgcolor="#eeeeee"> 
    <td><span class="black_text"><?php echo $firstname; ?></span></td>
  </tr>
  <tr>
    <td><span class="black_text"><?php echo $lastname; ?></span></td>
  </tr>
  <tr>
    <td><span class="black_text"><?php echo $dob; ?></span></td>
  </tr>
</table>

It would replicate that html table and output it on the page depending on how many records were saved in the database table, outputting all the relevant data for each record ?

Can anyone please provide links?

Thanks

Chris

[devinemke]

tweak as necessary:

<?php
mysql_connect('host', 'user', 'password') or exit(mysql_error());
mysql_select_db('dbname') or exit(mysql_error());

$result = mysql_query('SELECT * FROM table') or exit(mysql_error());
echo '<table width="95%" border="0">';
while ($row = mysql_fetch_assoc($result))
{
	echo '
	<tr bgcolor="#eeeeee"><td><span class="black_text">' . $row['firstname'] . '</span></td></tr>
	<tr><td><span class="black_text">' . $row['lastname'] . '</span></td></tr>
	<tr><td><span class="black_text">' . $row['dob'] . '</span></td></tr> 
	';
}
echo '</table>';
?>

[7724]

Hi,

Thanks for that - got the table working, but one simple question I can't get it work.

I want to add a line break at the end of the table, so I thought i'd just add:

echo '</table><br />'; 

But that does not seem to work when I thought it would?

Ta

[bpat1434]

If you have no content after the table, it wont' be "visible" when viewed through a browser. If you look at the source, it will be visible.

If you're talking about a line-break in the source so that your code begins a new line when you view the source, use:

echo '</table>'."\n";

~Brett

[7724]

Hi Guys,

May be being thick here but:

<?php 
mysql_connect('localhost', '*****', '*****') or exit(mysql_error()); 
mysql_select_db('*******') or exit(mysql_error()); 

$result = mysql_query('SELECT * FROM offers') or exit(mysql_error()); 
echo '<table width="95%" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC" align="center">'; 
while ($row = mysql_fetch_assoc($result)) 
{ 
    echo ' 
      <tr><td bgcolor="#CC0000">' . $row['title'] . '</td></tr>
      <tr><td>' . $row['full_details'] . '</td></tr>
      <tr bgcolor="#eeeeee"><td>' . $row['redemption'] . '</td></tr>
      <tr bgcolor="#eeeeee"><td>' . $row['restrictions'] . '</td></tr>
    '; 
}  

echo '</table>'."\n"; 
?> 

Still just outputs the table one after the other - no space in-between?

Any idea Thanks

Chris

[bpat1434]

Oh... you want sapce in between each table? Well, why didn't you say so?!?! (Wizard of Oz allusion).

while($row = mysql_fetch_assoc($result))
{
  echo '<table width="95%" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC" align="center">';
    echo '
      <tr><td bgcolor="#CC0000">' . $row['title'] . '</td></tr>
      <tr><td>' . $row['full_details'] . '</td></tr>
      <tr bgcolor="#eeeeee"><td>' . $row['redemption'] . '</td></tr>
      <tr bgcolor="#eeeeee"><td>' . $row['restrictions'] . '</td></tr>
    ';
  echo '</table><br />';
}

~Brett