Sorting data into a table.....HELP!

Agusta

HI,

I am having some trouble with entering the data I call into a table and making it hang together correctly...

In my database I have a table called forum and three fields called 'email', 'exhibition' and 'text'. The user can go in and insert data into these three fields. What I need is for them to be posted on my index all hanging together organized in a table. When I post what I have on my index it all comes out a mess, squished together....

How do I call what each user has entered at a time? I think it must have something to do with arrays but I am not sure how I would do it.

This is my code

<?
mysql_connect("localhost","","");
mysql_select_db("Trapholt");
$get=mysql_query("select * from forum");

while($row=mysql_fetch_array($get)){

print "$row[email]"."$row[exhibition]"."$row[text]";
}
?>

Hope someone can help, I am in a real pickle!

TomD

How about

<? 
mysql_connect("localhost","",""); 
mysql_select_db("Trapholt"); 
$get=mysql_query("select * from forum"); 

while($row=mysql_fetch_array($get)){ 

echo "$row['email']     $row['exhibition']     $row['text']"; 
} 
?>

or something like

<? 
mysql_connect("localhost","",""); 
mysql_select_db("Trapholt"); 
$get=mysql_query("select * from forum"); 
echo "<table>";
while($row=mysql_fetch_array($get)){ 
echo "<tr>";
echo "<td>$row['email']</td>";
echo "<td>$row['exhibition']</td>";
echo "<td>$row['text']</td>"; 
echo "</tr>";
}
echo "</table> ;
?>

Note: I have not tested either of these but I hope you get the idea.

Agusta

Thank you for your reply!

But it I cant seem to be able to post a table within php...I have tried breaking up the code and putting it into seperate <td>'s and with 's and to fit it, but that still leaves me sort of out of porportion....

Anyone?

NSH

How are you trying to organize it?
You can set pre-defined sizes for each table if you want

<td width=10>
or a percentage <td width=10%>

Same works for other table tags...

How are you trying to make it work?

TomD

Originally posted by Agusta
Thank you for your reply!

But it I cant seem to be able to post a table within php...I have tried breaking up the code and putting it into seperate <td>'s and with 's and to fit it, but that still leaves me sort of out of porportion....

Anyone?

Post some code so we can see what you are doing.

Agusta

yeah...of course....:p kind of new in this...sorry


<table border="1"  >
<tr>
<td height="200" width="50" valign="top" >
<?
mysql_connect("localhost","","");
mysql_select_db("Trapholt");
$get=mysql_query("select * from forum");

while($row=mysql_fetch_array($get)){
	print "<p>$row[email]<br><br></p>";

}
?>
</td>
<td valign="top">
<?
mysql_connect("localhost","","");
mysql_select_db("Trapholt");
$get=mysql_query("select * from forum");

while($row=mysql_fetch_array($get)){
print "<p>$row[exhibition]<br></p>";

}
?>
</td>
<td valign="top">
<?
mysql_connect("localhost","","");
mysql_select_db("Trapholt");
$get=mysql_query("select * from forum");

while($row=mysql_fetch_array($get)){
	print "<p>$row[text]<br></p>";

}
?>
</td>
</tr>
</table>

This works ok I guess, still I find the code is not quite as beautiful as I hoped for it to be
:rolleyes:

Agusta

NSH

print "$row[email] ";

That is likely why. Don't use a as this essentially double spaces for a new Paragraph.

I also see you are using two breaks...
Do you want the text in the middle(vertical) of the cell?
If so you do a valign=center (or middle can't remember which at the moment)

I am not sure what you want it to look like.