DougK

adding a crime panel in admin panel OK, I just tested out this mod. It seems that SQL/PHP does not like it when a quote shows up in one of the text boxes (in my case, text areas). Is there any way to make it so this works no matter what goes in the text boxes? Or is this just something I will have to train the admins on when editing a crime?

adding a crime panel in admin panel     function edit_crime_form() { global $ir,$c,$h,$userid; $d=mysql_query("SELECT * FROM crimes WHERE crimeID={$_POST['crime']}",$c); $itemi=mysql_fetch_array($d); print "<h3>Editing Crime</h3> <form action='admin.php?action=editcrimesub' method='post'> <input type='hidden' name='crimeID' value='{$_POST['crime']}' /> Crime Name: <input type='text' name='crimeNAME' value='{$itemi['crimeNAME']}' /> Crime Brave Cost: <input type='text' name='crimeBRAVE' value='{$itemi['crimeBRAVE']}' /> Crime PERCFORM: <input type='text' name='crimePERCFORM' value='{$itemi['crimePERCFORM']}' /> Success Money: <input type='text' name='crimeSUCCESSMUNY' value='{$itemi['crimeSUCCESSMUNY']}' /> Crime Group: <input type='text' name='crimeGROUP' value='{$itemi['crimeGROUP']}' /> CrimeITEXT: <textarea rows=4 cols=40 name='crimeITEXT' />'{$itemi['crimeITEXT']}'</textarea> Crime Success TEXT: <textarea rows=4 cols=40 name='crimeSTEXT' />'{$itemi['crimeSTEXT']}'</textarea> Crime Failure TEXT: <textarea rows=4 cols-40 name='crimeFTEXT' />'{$itemi['crimeFTEXT']}' </textarea> crime ITEM Number(0 for none): <input type='text' name='crimeITEM' value='{$itemi['crimeITEM']}' /> <input type='submit' value='Edit Crime' /></form>"; }   You need to make a small change to the edit crime form func to make it work. I also changed the success and failure text textboxes into textareas, as you can see.