PHP and MySQL table population

[-Karl-]

I have a table created containing the following.

 

name url members date

 

I want to populate a table like so:

 

Dates name1 name2 name3

date  membersforname1 membersforname2 membersforname3

anotherdate  membersforname1 membersforname2 membersforname3

 

So I need the dates to form each of the rows, but also, have the members in the correct places for the names.

 

Not sure if any of that made sense, if you want me to go in to more detail just ask.

[-Karl-]

Hopefully this will help:

 

I'm just not sure which type of query would be best for this.

[-Karl-]

Any ideas?

[ober]

Your question doesn't make ANY sense.  Try again.

[-Karl-]

Look at the images? Pretty much explains it, the top is the database, the second image is what I'm aiming to achieve. Simples.

[mattal999]

$prevdate = NULL;
$query = mysql_query("SELECT * FROM tablename ORDER BY date ASC");
echo "<table><tr>";
while($row = mysql_fetch_array($query)) {
    if($row['date'] == $prevdate) {
        echo "<td>BLAH BLAH BLAH</td>";
    } else {
        echo "</tr><tr>";
        echo "<td>BLAH BLAH BLAH</td>";
    }
    $prevdate = $row['date'];
}
echo "</tr></table>";

 

It won't work as you expect, but you should be able to see my logic.

[ober]

Am I the only one not seeing images?

[-Karl-]

Maybe?

 

http://i37.tinypic.com/2mhvh2r.png

 

That image is in my second post.

[ober]

When I click that link, I get this:

 

An HTTP error occurred while getting:

 

http://i37.tinypic.com/2mhvh2r.png

 

Details: "connect timed out".

[-Karl-]

Try this image please, I've reuploaded him.

 

http://img517.imageshack.us/img517/4491/exampleqm.png

[MatthewJ]

Mattal answered you already... are you not willing to try and understand what he posted?

[-Karl-]

Mattal answered you already... are you not willing to try and understand what he posted?

I'm working on it now, I'm just making sure the image works. Try not to jump the gun?

[MatthewJ]

Well, it was a half hour ago.. and you've posted three times since

 

But you're right... I'm somehow "jumping the gun"

[-Karl-]

Anyway, I've had a little mess around

 

$prevdate = NULL;
$query = mysql_query("SELECT * FROM tracked ORDER BY date ASC");
$query2 = mysql_query("SELECT * FROM tracked GROUP BY name ASC");
echo "<table><tr>";
echo '<tr>
            <td>Date</td>';
while($row2 = mysql_fetch_assoc($query2)) {
            echo '<td>'.$row2['name'].'</td>';
}
echo '</tr>';
while($row = mysql_fetch_assoc($query)) {
    if($row['date'] == $prevdate) {
        echo '<td>'.$row['members'].'</td>';
    } else {
        echo "</tr><tr>";
        echo '<td>'.$row['date'].'</td>';
    }
    $prevdate = $row['date'];
}
echo "</tr></table>"; 

 

It's got the correct layout now, however, no members appear for name2, when there are numbers in the database. Can't figure out why.

 

EDIT: Actually, the members that come under name1, are actually the members for name2.

[-Karl-]

Any ideas?