selecting only two URLs

[mcalpine]

i have a DB with urls in it ....
and i want an SQL statement that will select only 2 results from the same domain...

-m

[barand]

$sql = "SELECT ... WHERE url = '$url' LIMIT 2"

will limit the selection to 2 records

hth

[laserlight]

there's also the "same domain" restriction.
maybe must use LIKE, e.g.

SELECT * FROM tablename WHERE url LIKE '%phpbuilder.com%'

since the domain is part of the URL
that might translate to:

$sql = "SELECT * FROM tablename WHERE url LIKE '%$domain%' LIMIT 2";

[mcalpine]

baran - you think i didnt think of LIMIT....

thanks webnessa....
but theres more.....
think of this: how does google only show 1 sub domain result per search when the parent domain is in the results....

search "bill clinton".... and you'll see on some of the top level results... it only shows 1 subresult....

-m

[barand]

My apologies. Guess my psychic powers are a bit dull today.

[pha2er]

Are you using mySQL or SQL or what? If you're using SQL you could use cursors to do this, if you're using mySQL then it's gonna be a bit of a headache.

[mcalpine]

i might be using both....

dont you et cursors in mysql ?

anyway , please explain both...

thanks.
-m

[sdjensen]

Just an idea

select distinct hostname,..... from <tablename> WHERE url LIKE '%phpbuilder.com%'