how to print out table content?

bull

how can i print table content from mysql database like this, and with all data:

+--------------------+
|       |            |
+--------------------+
|       |            |
+--------------------+

Houdini

You would echo out the html like

echo"<table border='1'><tr>
<td>{$row['fieldname1']}</td></tr>
<tr><td>{$row['fieldname2']}</td></tr>
</table>";

where $row['fieldname1-2'] are field names fetched by a MySQL query of an array.

bull

okey, but is it possible to print it out not with <table>... but just how i showed with +-----...... so it would be easy to copy/paste database structure in forums when its needed to explain something. i hope you get my point.

Houdini

Not too goo at formatting stuff like that with HTML but kind of like

$space ="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;";
$graphic="+-------------------------------+";
echo "$graphic<br />|$space{$row['fieldname']}$space|<br />$graphic";

then adjust the number of dashes in the $graphic till it looks right or the numer of spaces in $space. Just an idea cause I have never tried something like that even though with a four letter word it worked, but would make a nightmare of trying to make it look right with more or less letters or characters.

bull

okey, thanks for help. seems that its not so easy to do.

bogu

When formating text u may look into this too ...
str_pad
It might help u (I'm sure it will) ...