Asp .Net web application and MySql

Posted by sarithasi-16371 under ASP.NET on 6/20/2012 | Points: 10 | Views : 1643 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

I am trying to create a searching site with two user:guest and registered user.For guest only 5searches are allowed for a day.What is the best way to store the search details
of a day?I am using MySql database.
Please help.

Thanks,
Saritha.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Muralidosscm on: 6/25/2012 [Member] Starter | Points: 25

0	Hi Saritha ................ First create the table for the users like Create table user(user varchar(50),logindatetime Datetime)............. when the user login the searching site, 1. select count() from user 2.if count <5 mean allow to login else '" Already logined 4 times today " message to be shown in the login page.......... its very simple try this way...... if u have doubt mean contact muralicm1590@gmail.com Regards Muralidoss M sarithasi-16371, if this helps please login to Mark As Answer*. \| Alert Moderator

Hi Saritha ................

First create the table for the users
like Create table user(user varchar(50),logindatetime Datetime).............

when the user login the searching site,
1. select count(*) from user
2.if count <5 mean allow to login else '" Already logined 4 times today " message to be shown in the login page..........

its very simple try this way......
if u have doubt mean contact muralicm1590@gmail.com

Regards
Muralidoss M

sarithasi-16371, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts