egghelp/eggheads community

[SOLVED] count url

2012-03-03T18:43:24-04:00

Thanks nml375
Did it like this :

Code:

#Urlset sqlsiteurl "SELECT COUNT(DISTINCT(siteurl)) FROM pred"set siteurl [mysqlsel $mysql_(handle) $sqlsiteurl -flatlist]

and returned 715 urls

Statistics: Posted by Fire-Fox — Sat Mar 03, 2012 6:43 pm

[SOLVED] count url

2012-03-03T18:28:59-04:00

Johannes13, since there are no variable substitutions within the query of the posted code, I don't see the relevance of sql injections.

Statistics: Posted by nml375 — Sat Mar 03, 2012 6:28 pm

[SOLVED] count url

2012-03-03T18:23:55-04:00

sql injection ftw. Make sure you escape the user given variables

Statistics: Posted by Johannes13 — Sat Mar 03, 2012 6:23 pm

[SOLVED] count url

2012-03-03T17:38:48-04:00

Well, that'd depend on the database structure and contents, as well as the expected results...
Anyhow...

Code:

SELECT COUNT(DISTINCT(siteurl))

Return the number of unique siteurl's from the filtered set.

Code:

WHERE siteurl='siteurl'

Filter the results to only return rows where the field siteurl is equal to the string "siteurl".

If you expect this to return anything other than 0 or 1, then you need to rethink your query.

Statistics: Posted by nml375 — Sat Mar 03, 2012 5:38 pm

[SOLVED] count url

2012-03-03T19:28:22-04:00

what is wrong here :

Code:

#Urlset sqlsiteurl "SELECT COUNT(DISTINCT(siteurl)) FROM home WHERE siteurl='siteurl'"set siteurl [mysqlsel $mysql_(handle) $sqlsiteurl -flatlist]

Statistics: Posted by Fire-Fox — Sat Mar 03, 2012 5:16 pm