pcbguy Posted December 5, 2007 Share Posted December 5, 2007 I have the below form that calls the below php script. The 'position' entry is the primary key and is what I use to call each record. How can I input another record with the same 2 digit position number and have it over write the previous entry? Thanks. <html> <head> <title>Form to Add Car For Sale</title> </head> <body> <form enctype="multipart/form-data" method="post" action="add.php"> Position<br> <input type="Text" name="position" size="2"><br> Year<br> <input type="Text" name="year" size="25"><br> Make<br> <input type="Text" name="make" size="25"><br> Model<br> <input type="Text" name="model" size="40"><br> Price<br> <input type="Text" name="price" size="25"><br> Description<br> <input type="text" name="description" size="200"><br> Picture<br> <input type="File" name="picture" size="40"><br><br> <input type="hidden" name="MAX_FILE_SIZE" value="30000"> <input type="submit" name="submit" value="Upload"> </form> </body> </html> <?php //This is the directory where the images will be saved $target="images/"; $target=$target.basename($_FILES['picture']['name']); //This gets all the other information from the form $position=$_POST['position']; $year=$_POST['year']; $make=$_POST['make']; $model=$_POST['model']; $price=$_POST['price']; $description=$_POST['description']; $picture=($_FILES['picture']['name']); //Connects to Database include "connect.php"; //Writes the information to the database mysql_query("INSERT INTO for_sale (position,year,make,model,price,description,picture) VALUES ('$position','$year','$make','$model','$price','$description','$picture')"); //Writes photo to the server if(move_uploaded_file($_FILES['picture']['tmp_name'],$target)) { //Tells you if its all okay echo "The file" .basename($_FILES['uploadedfile']['name']). "has been uploaded, and your information has been added to the directory"; } else{ //Gives and error if its not echo "Sorry, there was a problem uploading your file."; } ?> Quote Link to comment Share on other sites More sharing options...
revraz Posted December 5, 2007 Share Posted December 5, 2007 Use the MySQL UPDATE statement. Quote Link to comment Share on other sites More sharing options...
pcbguy Posted December 5, 2007 Author Share Posted December 5, 2007 Can it be written into the same script so that it will automatically delete the old entry if someone puts in the same 'position'? Quote Link to comment Share on other sites More sharing options...
pcbguy Posted December 5, 2007 Author Share Posted December 5, 2007 Maybe some sort of If statement that says if position=? then it replaced all the other columns with the current information. Quote Link to comment Share on other sites More sharing options...
runnerjp Posted December 5, 2007 Share Posted December 5, 2007 $sql = "DELETE FROM `table` WHERE `cell`={$Clean['cell']}"; $q = mysql_query($sql); if($q === FALSE){ dbg_out('ERROR: ' . mysql_error()); }else{ dbg_out('Database delete successful'); Quote Link to comment Share on other sites More sharing options...
pcbguy Posted December 5, 2007 Author Share Posted December 5, 2007 That will delete it? I put that at the beginning of the script? Quote Link to comment Share on other sites More sharing options...
runnerjp Posted December 5, 2007 Share Posted December 5, 2007 yer it will obviusly chnage ur table name ect Quote Link to comment Share on other sites More sharing options...
revraz Posted December 5, 2007 Share Posted December 5, 2007 Why do you want to make 2 statements, one to delete and one to insert when you can just update? Its easy to check to see if it exists and then update, if not, insert. Quote Link to comment Share on other sites More sharing options...
pcbguy Posted December 5, 2007 Author Share Posted December 5, 2007 That is what I want to do. I just started another thread. Quote Link to comment Share on other sites More sharing options...
runnerjp Posted December 5, 2007 Share Posted December 5, 2007 sorry just gave a delete one Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.