MySQL query result in a table problem

[lardum]

> I'm having a little problem displaying the result of a SQL query in a
table.
> This is the PHP code i use:
>
> ----- PHP CODE -----
> $GBGet = "SELECT RegDate, RegTime, name, email, comment FROM guestbook";
> $GBResult = mysql_query($GBGet);
>
> print(&quot;<table border=1 cellpadding=2 cellspacing=2 bordercolor=000000>&quot;
> print(&quot;<tr><td width=20><b>Date:</b></td><td width=20><b>Time:</b></td><td
> width=100><b>Name:</b></td><td width=100><b>E-mail:</b></td><td
> width=200><b>Comment:</b></td></tr>&quot;
>
> while($rad = mysql_fetch_array($GBResult))
> {
> print(&quot;<tr><td>&quot;
> print($rad[&quot;RegDate&quot;]);
> print(&quot;</td><td>&quot;
> print($rad[&quot;RegTime&quot;]);
> print(&quot;</td><td>&quot;
> print($rad[&quot;name&quot;]);
> print(&quot;</td><td>&quot;
> print($rad[&quot;email&quot;]);
> print(&quot;</td><td>&quot;
> print($rad[&quot;comment&quot;]);
> print(&quot;</td></tr&quot;
> }
>
> mysql_free_result($GBResult);
> print(&quot;</table>&quot;
>
> ---- END OF PHP CODE ----
>
> The result of this will be only one row in a table where the 4 first
columns
> are correct then it puts the second row in my table in the same row.
>
> Anyone have any ideas of why?
> FYI: I'm quite new to PHP and MySQL
>
>
>

 

[dkdude]

lardum,

Hmmmm.... Looks like you may be using an array when you need an associative array. Have a look at the php.net mysql_fetch_assoc() referance example. Here's the link:

http://us2.php.net/manual/en/function.mysql-fetch-assoc.php

If that doesn't help you -> get back to us!

Good Luck §;O)


Jakob

 

[lardum]

Tried to change to mysql_fetch_assoc but still get the same result. I.e 2 columns called Name and E-mail.
Result is:

Name: E-mail:
John john@email.com Jane jane@email.com

I want it to be:
Name: E-mail:
John john@email.com
Jane jane@email.com

 

[dkdude]

lardum,

Okay -I just noticed that your

</TR>

looks like this :

</TR

That's gonna cause confusion and is probably the reason why §;O)

Good Luck


Jakob

 

[lardum]

Hahaha

sorry. thanks. sometimes one really can be blind.

 

[dkdude]

Heh! No prob! Nice with an extra pair of eyes, sometimes §;O)


Jakob