|
|
Posted by pritaeas on 07/27/06 19:53
If some things are truly unique, set those columns as unique in the table.
That way you get an error on inserting a duplicate.
hth, Hans
<sloane.irwin@gmail.com> wrote in message
news:1154029641.106719.270560@b28g2000cwb.googlegroups.com...
> Hello,
> I've just finished my first PHP/mySQL database and it's working great.
> I can enter info, change info, and delete it with no problem, all
> fields are working.
>
> Unfortunately, people are starting to add duplicate items, which is
> annoying me, as I have to go through and delete these duplicates. This
> is fine right now when there's only 30 entries in it, but by the end of
> the month there will be nearly 300 and that will be no fun to deal
> with.
>
> I know there is some code that I could add to search for both the
> inventory number and the serial number to see if either still exists,
> and if so, a button to see it or to cancel and go back.
>
> Any ideas? My code for the db_insert.php file follows:
>
> <html>
> <body>
> <?
> require('db_login.php');
> require('db_connect.php');
>
> // the table you want to add to
>
>
>
> $table = 'data';
>
>
> // begin the query
>
> $query = "INSERT INTO $table(";
>
>
> // add fieldnames to insert
>
> $query .= 'inventory' . ',';
> $query .= 'date_entered' . ',';
> $query .= 'first' . ',';
> $query .= 'last' . ',';
> $query .= 'serial' . ',';
> $query .= 'city' . ',';
> $query .= 'brand' . ',';
> $query .= 'model' . ',';
> $query .= 'email' . ',';
> $query .= 'buy_date' . ',';
> $query .= 'building' . ',';
> $query .= 'room' . ',';
> $query .= 'computer_name' . ',';
> $query .= 'pri_user' . ',';
> $query .= 'warranty' . ',';
> $query .= 'vendor' . ',';
> $query .= 'os' . ',';
> $query .= 'processor' . ',';
> $query .= 'memory' . ',';
> $query .= 'hd' . ',';
> $query .= 'drive1' . ',';
> $query .= 'drive2' . ',';
> $query .= 'drive3' . ',';
> $query .= 'drive4' . ',';
> $query .= 'bb_date' . ',';
> $query .= 'comments' ;
>
>
>
> // end fieldnames and begin values
>
> $query = $query . ') VALUES(';
>
>
> // get values from $_REQUEST
>
> $query = $query . '"' . $_REQUEST['inventory'] . '", ';
> $query = $query . '"' . $_REQUEST['date_entered'] . '", ';
> $query = $query . '"' . $_REQUEST['first'] . '", ';
> $query = $query . '"' . $_REQUEST['last'] . '", ';
> $query = $query . '"' . $_REQUEST['serial'] . '", ';
> $query = $query . '"' . $_REQUEST['city'] . '", ';
> $query = $query . '"' . $_REQUEST['brand'] . '", ';
> $query = $query . '"' . $_REQUEST['model'] . '", ';
> $query = $query . '"' . $_REQUEST['email'] . '", ';
> $query = $query . '"' . $_REQUEST['buy_date'] . '", ';
> $query = $query . '"' . $_REQUEST['building'] . '", ';
> $query = $query . '"' . $_REQUEST['room'] . '", ';
> $query = $query . '"' . $_REQUEST['computer_name'] . '", ';
> $query = $query . '"' . $_REQUEST['pri_user'] . '", ';
> $query = $query . '"' . $_REQUEST['warranty'] . '", ';
> $query = $query . '"' . $_REQUEST['vendor'] . '", ';
> $query = $query . '"' . $_REQUEST['os'] . '", ';
> $query = $query . '"' . $_REQUEST['processor'] . '", ';
> $query = $query . '"' . $_REQUEST['memory'] . '", ';
> $query = $query . '"' . $_REQUEST['hd'] . '", ';
> $query = $query . '"' . $_REQUEST['drive1'] . '", ';
> $query = $query . '"' . $_REQUEST['drive2'] . '", ';
> $query = $query . '"' . $_REQUEST['drive3'] . '", ';
> $query = $query . '"' . $_REQUEST['drive4'] . '", ';
> $query = $query . '"' . $_REQUEST['bb_date'] . '", ';
> $query = $query . '"' . $_REQUEST['comments'] . '"';
>
>
> // end query
>
> $query = $query . ')';
>
>
> // run INSERT query
>
> mysql_query($query, $db);
>
> include('db_close.php');
>
> ?>
>
> <script language="javascript">
> <!--
>
> location.href = 'display.php';
>
> //-->
> </script>
> </body>
> </html>
>
--
Posted via a free Usenet account from http://www.teranews.com
Navigation:
[Reply to this message]
|