[SOLVED] count url

Fire-Fox · Post by **Fire-Fox** » Sat Mar 03, 2012 5:16 pm

what is wrong here :

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

Post by **nml375** » Sat Mar 03, 2012 5:38 pm

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

Code: Select all

SELECT COUNT(DISTINCT(siteurl))

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

Code: Select all

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.

Johannes13 · Post by **Johannes13** » Sat Mar 03, 2012 6:23 pm

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

Post by **nml375** » Sat Mar 03, 2012 6:28 pm

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

Fire-Fox · Post by **Fire-Fox** » Sat Mar 03, 2012 6:43 pm

Thanks nml375

Did it like this :

Code: Select all

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

and returned 715 urls