php mysql fetch once from multiple result

phpCow

Php and mysql problem:

i have a table where i save users comment,his name and url where he comment:

id,name,comment,url,time.

So in one url (in one post) anyone can comment many times.

Now i wan to fetch name once for each url.
And i insert that name into another table.
But How(php and mysql)?
Please help me.

johanafm

SELECT name, url
FROM tbl
GROUP BY url

tomhath

Php code is the same as with any other sql query.

SELECT DISTINCT name, url
FROM tbl
ORDER BY name, url

phpCow

Thank you tomhath.

Actually i did not knew how to fetch unique data.DISTINCT help me a lot of because i solv my proble with a long prosses.

First i make an array:

$test=array();

Than fetch all result and chack with function in_array.

while($row=mysql_fetch_array($resust)){
$ttp=$row['name'];
if(!in_array($ttp,$test)){
$test[]=$ttp;
}
}

Than i insert with foreach ...

foreach($test as $ins){
$sql2=mysql_query("INSERT INTO ... ... ...");
}

ha....ha....i am really a Cow....THANK you...Now just use DISTINCT.

Thank you both for help me...

Derokorian

A little side note: if you are selecting data so that you can run an insert statement(s) with the returned rows then it would probably be more efficient to just do a INSERT ... SELECT

johanafm

Why didn't you try this, which is the efficient way to do what you want? Or in case I missunderstood what you want, GROUP BY url, name. It's the same principle that applies, except now for a group of data instead of just one field.

johanafm;10997638 wrote:
SELECT name, url
FROM tbl
GROUP BY url

Once you do that, you can follow Derokorian's advice.

Weedpacket

johanafm wrote:
Or in case I missunderstood what you want, GROUP BY url, name.

SELECT name, url
FROM tbl
GROUP BY url

In most DBMSs this would be an error, because "name" is neither grouped by nor aggregated. The DBMS would complain, effectively, "but which name for each url?"