nPage = CLng(Request.QueryString("Page"))

	
	Keyword = Trim(Request.QueryString("Keyword"))

p.area LIKE '%" & Replace(Keyword,

UPDATE tbl
SET website= LEFT(website, CHARINDEX('<', website) - 1)
WHERE CHARINDEX(';', website) > 0

<%@

<?php

// Where will you get the forms' results?
define("CONTACT_FORM", 'contact@mysite.co.uk');
?>

<?php

keywords_cmd.CommandText = "SELECT city,galleryimage1,galleryimage2,galleryimage3,galleryimage4,galleryimage5,galleryimage6 FROM databasetable where city like '%"  & Request.QueryString("term") & "%' and galleryimage1<>'' and galleryimage2<>'' and galleryimage3<>'' and galleryimage4<>''

lngprofileid=CLng(Request("profileid"))

SQLQuery = "select tbl.country from tbl group by country HAVING COUNT(country) > 1 order by count(country) desc"

(Select WatchingUserID from tblWatches where WatchedProfileID <>0 group by WatchingUserID HAVING COUNT(*) > 5)"

		                 
   SQLQuery="Select top 5 L.accept,etc,etc, "

SQLQuery= SQLQuery & "FROM tblAppsLoginDatabaseBySmo L INNER JOIN tblAppsProfilesDatabaseBySmo P ON L.UserId = P.UserId "
SQLQuery= SQLQuery & " inner join tblWatches T ON P.UserId = T.WatchingUserID "
SQLQuery= SQLQuery & "  and p.userid

select top 15 tblA.categories from tblA group by categories 
order by count(categories) desc

           SQLQuery = "SELECT DISTINCT tblA.categories"

order by datalength(workingmethods) desc,

order by datalength(workingmethods) desc, JoinDate desc