Checking for multiple database entries

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 427,811 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,800 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 2626 | Replies: 1

•

Join Date: Jun 2004

Posts: 18

Reputation: Syneticus can only hope to improve

Rep Power: 0

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

Location: Long Island, NY

Posts: 1,134

Reputation: samaru is just really nice

Rep Power: 12

Solved Threads: 4

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

(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

If you need more help let us know.

_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor