smsulliva

I figure out what I was doing wrong thanks anyany

I figure out why is wasn't posting but I am now getting a syntax error here. Can anybody see what I am doing wrong. $sql = "UPDATE helpfiles SET category='$category',entry='$entry', related_entries='$related_entries', required_level='$required_level',changed_by='$changed_by', last_changed='$last_changed', WHERE name = '".$name."'"; I get this error mysql_query(): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE name = 'Building_credit''

Can someone tell me what is wrong with this? <? //if ($_POST['update'] == "help") //echo "Thank you! Information updated."; //} if ($_POST['update'] == "help") { $name = $_POST["name"]; $category = $_POST["category"]; $entry = $_POST["entry"]; $related_entries = $_POST["related_entries]"; $required_level = $_POST["required_level"]; $changed_by = $_POST["related_entries"]; // Need to change $last_changed = $_POST["related_entries"]; // Need to change $sql = "UPDATE helpfiles SET category='$category',entry='$entry', related_entries='$related_entries', required_level='$required_level',changed_by='$changed_by', last_changed='$last_changed', WHERE name=$name"; $result = mysql_query($sql); echo "Thank you! Information updated."; } ?> The variables on the form input types are being filled out correctly elsewhere in the code. <form name="form_Add_rating" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <input type="hidden" name="update" value="help"> <table align='center' width='95%'> <tbody> <tr> <td class="tableBar" colspan="2"> </td> </tr> <tr> <td><label for="name">Name</label></td> <td><input name="name" readonly="true" value="<?php echo $item ?>" size="25" type="text" style="background-color:#EFEFEF"> You cannot edit this field.</td> </tr> <tr> <td><label for="category">Category</label></td> <td><input name="category" value="<?php echo $helpArr['category'] ?>" size="25" type="text"></td> </tr> <tr> <td><label for="entry">Description</label></td> <td><textarea name="entry" cols="73" rows="10" value="<?php echo parse_string($helpArr['entry']) ?>" ><?php echo parse_string($helpArr['entry']) ?></textarea> </tr> <tr> <td><label for="related_entries">Related Entries</label></td> <td><input name="related_entries" value="<?php echo parse_string($helpArr['related_entries']) ?>" size="68" type="text"></td> </tr> <tr> <td><label for="required_level">Required Level</label></td> <td><input name="required_level" value="<?php echo parse_string($helpArr['required_level']) ?>" maxlength="1" size="25" type="text"></td> </tr> <tr> <td><label for="changed_by">Changed By</label></td> <td><input name="changed_by" readonly="true" value="{USERNAME}" size="25" type="text" style="background-color:#EFEFEF"> You cannot edit this field.</td> <!-- <td><input name="changed_by" readonly="true" value="<?php echo parse_string($helpArr['changed_by']) ?>" size="25" type="text" style="background-color:#EFEFEF"> You cannot edit this field.</td> --> </tr> <tr> <td><label for="last_changed">Last Changed</label></td> <td><input name="last_changed" readonly="true" value="<?php echo $t_date ?>" size="25" type="text" style="background-color:#EFEFEF"> You cannot edit this field.</td> <!-- <td><label for="last_changed">Last Changed</label></td> <td><input name="last_changed" readonly="true" value="<?php echo parse_string($helpArr['last_changed']) ?>" size="25" type="text" style="background-color:#EFEFEF"> You cannot edit this field.</td> --> </tr> <tr> <td align="center" colspan="2"><input value="Update" type="submit"> <input name="reset" value="Reset" type="reset"> <input type="button" value="Cancel" onclick="javascript:hideBlock('editform')"></td> <!-- <td align='center' colspan='2'><input name='submit' value='Edit ".$item."' type='submit'> <input name='reset' value='Reset' type='reset'> <input type='button' value='Cancel' onClick='javascript:hideBlock(\"editform\")'><input type='hidden' name='cmd' value='edit'></td> --> </tr> </tbody> </table> </form>