PHP/MySQL help for posting

[Incubator]

I was wondering what I needed to do to display more then 1 post.

for example, id i have the following:

$name = mysql_querry(select name from database);
$msg = mysql_querry(select message from database);

do I have to put it in table then? and if so, how exactly?

and as you may have noticed, if I would execute the following querries, I would put several values in one variable, wich isn´t possible.
how do I solve that too?

Inc.

[cahva]

You got it wrong. The right way to do that query is:

$query=mysql_query("SELECT name,message FROM database")
while ($row=mysql_fetch_array($query))
{
echo 'Name:'.$row['name'].'<br>Message:'.$row['message'];
}

This is basic stuff. If you mean by putting it to html-table then just do this:

<table>
<?php
$query=mysql_query("SELECT name,message FROM database")
while ($row=mysql_fetch_array($query))
{
echo '<tr><td>Name:'.$row['name'].'<br>Message:'.$row['message'].'</td></tr>';
}
?>
</table>

[Incubator]

ah, now it makes sense to me 🙂
looks similar like writing output in a Javascript dynamic table.

thnx a lot 🙂

well, it may be basic, but I´m a noob for something, right? 😉

[cahva]

Hehe, didnt mean to be mean 😃 I do remember the times when those simple things feeled impossible to remember.

Now I have been a professional programmer for 2 years and still there comes times when I sometimes feel like a 'Noobie'. Its a continous journey and I still try to learn something new everyday.
Great way to learn is by reading this forum and try to solve peoples problems! The harder they are, the better 😉

[Incubator]

yes, thats true, and by the looks of it, I still have a long way to go 🙂