need some help, advanced coders maybe needed

nem

hi,

I have 2 main databases...

I have a table label ID.... now in the ID there are some tables in there with the same ID.

How can i put on my php page, the amount of IDs with the number "12" example?

so.... basically....

i use the code

<? echo($row['ID']); ?>

to show the ID, in each row of the table.... i want to calculate somehow how many messages there are with the same ID.

onion2k

$sql = "select id, count(id) as total_ids from table group by id";
$result = mysql_query($sql,$databaseLink);
while ($row = mysql_fetch_object($result)) {

echo "There are ".$row->total_ids." records with id ".$row->id;

}

nem

im creating a forum you see,.... it needs to be an echo....

so it can do same on every cell

TheDefender

im creating a forum you see,.... it needs to be an echo....
so it can do same on every cell

So nem, did onion answer your question then? Because onion's response sounds like what you are looking for. If not, then you need to go into a little more details to explain what exactly it is you are looking for.

nem

it didnt work, i need to put that code in a table cell... right? because it duplicates itself for the rest of the posts.

nem

look here for example

http://dhost.hopto.org/gmforum/display.php

where it says "replies" that is the topic ID.

Weedpacket

I think onion2k's code was to show you how to get the count you were asking for, rather than just being a "here: cut and paste this into your page" solution. You probably have to think a bit about your page and existing code to work out how to apply it in your situation. No-one knows your code better than you do.