Checking the database.....?

[Hartmann]

Hi,
Can anyone post some code on how to test the database to see if the information that was just entered was already in the database? Could you also post an explanation?

Thanks,

[Hartmann]

Ohh forgot what language... I would like to use PHP.. Many thanks,

[TWTCommish]

You'd have to be more specific - would all fields need to be the same, or just one? Would you be using a MySQL database?

[Hartmann]

Yes I am going to be using MySQL.... There are two fields that need to be checked... "Name" and "E-mail".

Sincerely,

[TWTCommish]

Try a query like this:

SELECT * FROM dbname WHERE Name='$theName' AND Email='$theEmail'

Once you've selected the record, use an if statement:

if ($Name == "$theName" && $Email == "$theEmail") {do stuff}

I think that ought to work, at least

[Hartmann]

I'll try it
Many thanks!

[TWTCommish]

Don't thank me - odds are there are at least fifty other ways to achieve the same thing...all more efficient than mine. And thats assuming it works.