mysql/php problems

speede

I'm quite new in mysql/php and have a problem: I have done a web-interface using php which can be used to add/remove/modify table entries in MySQL database. I'd like to prevent adding a entry that contains same information as existing entry,so there's should not be dublicate entries in mysql table. Could i do this with php-script or should i somehow protect table entries in mysql or what?

amcgrath

You could put a unique index on the fields you want to identify a row as unique, or yea, you could do it in the code (select count(*) from table where unique_fields = unique_fields) though i wouldn't recommend that....

speede

the problem is different that i asked earlier, so i can't use unique or primary keys for fixing that. The database is ip-address-database which contains subnet field in one table (like 192.168.5) and in other table there's host,mac and description fields (like 6,ff.ff.ff.ff.ff.ff,serverX). These tables are related with id's in both tables. When adding entries,user chooses subnet to which he want to add entries,and then the given values are inserted on correct subnet based on id-number. So because all host numbers belong to same table,there can be same host-numbers, which are related to different subnet by using id's.
For example,if adding values x,x,x to host,mac,description fields with id related to subnet 192.168.5 and there already exists same host-value,but it's related to subnet 192.168.6, it should be allowed. BUT, when adding host-value related to subnet where it exists already, this should not be allowed.

Well, long story but try to get it and please send suggestions how can i make this work.I should propably change the structure of my database?

Anon

ok in your host table you have soemthing like this right:-

hostname , subnetID

ok? well before adding first
$duplicatehns = mysql_query("SELECT * FROM host WHERE hostname= '$newhostname'");

loop through the results sticking them into an array each time.

while ($row = mysql_fetch_array($duplicatehns) {

now in here check that $row[subnetid]<>$requestedsubnetid

if that is true there is already a hostname with that subnet. thus dont insert data.

Hope that makes sense + helps 🙂

Towner

speede

Thanks a lot! I didn't imagine that it would be so simple...