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