Thanks for your reply...I read those links but I'm new to all this coding stuff. I sent you an Email anyway.
On Jul 21, 4:21 pm, Richard D Shank <[EMAIL PROTECTED]> wrote: > First, never insert input into a database with filter it first. It > makes you vulnerable for an attack. You can read this article to get a > better understanding. http://shiflett.org/articles/input-filtering > > Second, it looks like you are wanting to update the data in the database > (you are passing an id in). If this is the case, you will want to use > UPDATE instead of INSERT. If you go tohttp://dev.mysql.comyou can > search to find how to use the UPDATE syntax. > > If you are still stuck after search it out, email me off the list and > I'll try to help you through it. > > Richard > > Aureole wrote: > > I'm using the jEditable plugin which can be found here: > > >http://www.appelsiini.net/~tuupola/258/jeditable-in-place-editor-plug... > > > The examples files for saving to a database use Pear DB and SQL Lite > > or something... > > > I've been trying to get it to work with MYSQL but so far I've had no > > luck. > > > Here is the code I have for save.php > > > /////////////CODE > > > <?php > > require_once 'dbConnection.php'; > > function getLastID() { > > $id = mysql_fetch_row(mysql_query("SELECT LAST_INSERT_ID()", $this- > > >> linkId)); > > > return $id[0]; > > } > > $query="INSERT INTO edits(id, token, value) > > VALUES('$_POST[id]', '%s', '$_POST[value]')"; > > if(!mysql_db_query($dbname,$query,$link_id)) die(mysql_error()); > > (stripslashes($_POST['value'])); > > $result = mysql_query($query); > > usleep(2000); > > print $_POST['value']; > > ?> > > > /////////////END CODE > > > I really have no idea what I'm doing when it comes to PHP/MYSQL... > > > Can anyone help me get it working?
