ballhogjoni Posted July 4, 2007 Share Posted July 4, 2007 I want to update or insert data into my mysql table depending on if information exists or not. Right now I can update and insert the data, but my question is how do I update data in one column of my table without updating the data of another column in the same table? I have the issue that if I submit my form without any data entered in the field on the form it will delete/update the data in my table with nothing. here is my code <?php $First_category_title = $_POST['First_category_title']; $First_Link_URL = $_POST['First_Link_URL']; $First_Link_Title = $_POST['First_Link_Title']; $view_form = $_POST['view_form']; if (!isset($view_form)) { ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Admin Only</title> </head> <body> <table> <tr> <td> <table> <tr> <td> <fieldset><legend>First Category Links and Titles</legend> <form action="" method="post"> <table> <tr> <td> First Category Title: </td> <td> <input type="text" name="First_category_title" value=""/> </td> </tr> <tr> <td> First Link URL: </td> <td> <input type="text" name="First_Link_URL" value=""/> </td> <td> First Link Title: </td> <td> <input type="text" name="First_Link_Title" value=""/> </td> </tr> <tr> <td colspan="4" align="center"> <input type="hidden" name="view_form" /> <input type="submit" value="Submit" /> </td> </tr> </table> </form> </fieldset> </td> </tr> </table> </td> </tr> </table> </body> </html> <?php } elseif (!empty($First_category_title) || !empty($First_Link_URL) || !empty($First_Link_Title)) { $username="xxxx"; $password="xxxx"; $database="xxxx"; mysql_connect('localhost',$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $result = mysql_query("SELECT * FROM leftNavigation"); $num_rows = mysql_num_rows($result); if ($num_rows) { mysql_query("UPDATE leftNavigation SET First_category_title = '$First_category_title',First_Link_URL = '$First_Link_URL',First_Link_Title = '$First_Link_Title'") or die(mysql_error()); echo 'you did it'; echo '<FORM><INPUT TYPE="button" VALUE="Go Back" onClick="history.go(-1)"></FORM>'; } else { mysql_query("INSERT INTO leftNavigation (First_category_title,First_Link_URL,First_Link_Title) VALUES ('$First_category_title','$First_Link_URL','$First_Link_Title')") or die(mysql_error()); echo 'you added the right stuff'; echo '<FORM><INPUT TYPE="button" VALUE="Go Back" onClick="history.go(-1)"></FORM>'; } unset($First_category_title,$First_Link_URL,$First_Link_Title); } else { echo 'every field was empty, please <FORM><INPUT TYPE="button" VALUE="Go Back" onClick="history.go(-1)"></FORM> and enter information into the fields'; } ?> Quote Link to comment Share on other sites More sharing options...
mmarif4u Posted July 4, 2007 Share Posted July 4, 2007 This is easy if u want to update one field not all then just mention one field in ur query like: mysql_query("UPDATE leftNavigation SET First_category_title = '$First_category_title'") or die(mysql_error()); This is just an example, edit it to ur desire query. Quote Link to comment Share on other sites More sharing options...
ryeman98 Posted July 4, 2007 Share Posted July 4, 2007 Or you could make if statements like... if (!$column) { } else { mysql_query Or the other way around... you could do that for each one. I'm sure there's a better way though. 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.