DaniWeb Forum Index > Web Development > PHP

Checking for multiple database entries

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2004

Posts: 19

Reputation: Syneticus can only hope to improve

Solved Threads: 0

Syneticus

Offline

Newbie Poster

Checking for multiple database entries

Jun 10th, 2004

Hey, I've written a script in PHP that writes data into a MySQL database upon request, but what I'd also like to include is a script that will go in after the request is made, and check to make sure that the same entry does not already exist... and I have no clue where to start. I've never tried to do anything like this before, and am not sure what to do. If I could get some ideas from anyone it would be greatly appreciated. Thanks!

•

Join Date: Feb 2002

Posts: 1,135

Reputation: samaru is just really nice

Solved Threads: 6

samaru

Offline

a.k.a inscissor

Re: Checking for multiple database entries

Jun 10th, 2004

All you have to do is run a select statement looking for the value you just inserted. This goes right after your insert statement.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
Here's some pseudo code:
 
1. insert into table(field1) values('value')
2. y = select count(field1) from table where field1 = 'value'
3. if (y == 1)
	  just one exists
   elseif( y > 1)
	  multiple exist
 
Here's some pseudo code:
 
1. insert into table(field1) values('value')
2. y = select count(field1) from table where field1 = 'value'
3. if (y == 1)
	  just one exists
   elseif( y > 1)
	  multiple exist