Simple database help please - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

DombroCJ · 05-05-2008, 12:54 AM

Hi guys,

I need help with some asp code for my web page. I have a small data table made with SQL. 3 collumns, one for month, type and name. 12 rows for each month of the year. I have the htm page that requests the month the user was born in done. From there i need to match the month with the month in the database and then display the corresponding type and name for that month. I know this is prolly easy but i cant get it right. If anyone could help me out it would be great.

Thank you very much!!

adMedia · 07-24-2008, 09:53 PM

"12 rows for each month of the year"? Are these months in a separate table? You can do it in various ways. You can use asp code to get the month and use hard coded months to decide. If you are using the database for that matter you could use a sql statement like this:

"select type,name from myTable where month = ' "+strMonth+" ' ";
strMonth is the value you are getting from user through querystring or whatever.