Re: want to verify the data coming from a form with the data in database

2003-06-11 Thread Greg Jetter
On Wednesday June 11 2003 10:09 am, Greenhalgh David wrote: > On Wednesday, June 11, 2003, at 02:10 am, Annie wrote: > > no i want to ask what if someone enters a firstname and last name > > which doesnot exist in the database...in that case how i can verify > > and print an error msg that the dat

Re: want to verify the data coming from a form with the data in database

2003-06-11 Thread Greenhalgh David
On Wednesday, June 11, 2003, at 02:10 am, Annie wrote: no i want to ask what if someone enters a firstname and last name which doesnot exist in the database...in that case how i can verify and print an error msg that the data doesnot exist for this first name and last name. Well a fairly simp

Re: want to verify the data coming from a form with the data in database

2003-06-10 Thread Annie
no i want to ask what if someone enters a firstname and last name which doesnot exist in the database...in that case how i can verify and print an error msg that the data doesnot exist for this first name and last name. Greenhalgh David <[EMAIL PROTECTED]> wrote:Am I understanding you correctly?

Re: want to verify the data coming from a form with the data in database

2003-06-10 Thread Greenhalgh David
Am I understanding you correctly? Your form only has two fields, lastname and firstname? In that case SELECT * FROM table_name WHERE lastname = '$a2' AND firstname = '$a1' works on the command line. (Wasn't sure if you could use the AND like that, but it seems you can) so all you need to do is

want to verify the data coming from a form with the data in database

2003-06-09 Thread Annie
i have a perl file which is receiving the data from a form...and i want to verify the two fields $a2 and $a1 i m receiving from form to be checked in a table in database( using mysql)...and then if the data is verified in any of the row of the tablethe corresponding whole row data should be