insert into reviews (upc, rate, review, username) values ('#upc#', #rate_it#, '#URLDecode(review)#', '#client.username#')
select distinct genre
from dvd
where format <> 'MERC'
order by genre
select distinct collection
from dvd
where featured = 4 and format <> 'MERC'
order by collection
SELECT DISTINCT COLLECTION
FROM dvd
WHERE (collection IS NOT NULL) AND (collection <> '')
ORDER BY COLLECTION
select count(username) As TotalRecords
from users
where username = '#client.username#' and logged = 1
select distinct subgenre
from dvd
where format = 'MERC'
order by subgenre
Advanced Search - Rareflix.com
