Hot Deals

<% 'Start the ASP Tag Set conn = server.createobject("adodb.connection") 'Define the location of your database and your Password conn.connectionstring = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=tamersherif.easycgimysql.com; DATABASE=continental; UID=tamersherif;PASSWORD=titi2000; OPTION=3" 'Open Connection conn.Open Set rs=Server.CreateObject("ADODB.recordset") 'Enter your SELECT Statement rs.open "Select * from hotdeals", conn do until rs.EOF x_HotDealsID = rs("HotDealsID") x_HotDealsImage = rs("HotDealsImage") x_HotDealsTitle = rs("HotDealsTitle") x_HotDealsDuration = rs("HotDealsDuration") x_Cities = rs("Cities") x_SpecialPrice = rs("SpecialPrice") x_HotDealsDescription = rs("HotDealsDescription") %>

" style="text-decoration: none"> <% Response.Write x_HotDealsTitle %>

<% If Not IsNull(x_HotDealsImage) Then %> <% End If %>
<% Response.Write x_HotDealsDuration %>
<% Response.Write x_Cities %>
 

 
<% Response.Write x_SpecialPrice %>
<% 'Move to the Next Record in the database rs.movenext loop %>