The ASP code below connects to a MySQL database, and produces a simple table output from the database.

” & whatever.name & “”
next
response.write ” ”
response.write cellstart & Name & “”
rstemp.movenext
LOOP
%>

From here you can easily modify the SELECT statement to look for specific results, much as you would from a Search box. So this modified SELECT statement:
mySQL=”select * from asptest where phone LIKE ‘555%’”
produces a subsection of the results from the first code example.

====================================

for more info visit
http://216.147.98.109/support_aspdb.html

=====================================