Thank you so muchJohn Cartwright wrote:group is a reserved word. Either wrap it in backticks "`" or change the column name. I would seriously recommend you pass all your input variables atleast through mysql_real_escape_string() for strings, and typecast to (int) or intval() for numerical data.
Search found 6 matches
- Thu Feb 12, 2009 5:23 pm
- Forum: PHP - Code
- Topic: Update issues
- Replies: 5
- Views: 278
Re: Update issues
- Thu Feb 12, 2009 5:17 pm
- Forum: PHP - Code
- Topic: Update issues
- Replies: 5
- Views: 278
Re: Update issues
update photo set group = 'Personal', title = 'hello', notes = 'erigeorijg' where photoID='31'
- Thu Feb 12, 2009 4:19 pm
- Forum: PHP - Code
- Topic: Update issues
- Replies: 5
- Views: 278
Update issues
I get this error: Unable to 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 'group = 'Personal', title = 'hello', notes = 'erigeorijg' where photoID=31' at line 1 when i submit a form to this: <?php include(&...
- Thu Feb 05, 2009 3:29 pm
- Forum: PHP - Code
- Topic: PHP/Jquery/MySQL Delete a row
- Replies: 4
- Views: 1749
Re: PHP/Jquery/MySQL Delete a row
Thank you so much , that did it.
- Thu Feb 05, 2009 9:11 am
- Forum: PHP - Code
- Topic: PHP/Jquery/MySQL Delete a row
- Replies: 4
- Views: 1749
Re: PHP/Jquery/MySQL Delete a row
So I have it alert the groupid before the ajax call and that works fine, and i also used the delete_groups.php on its own and it works fine too. The only thing I can think of is the ajax call messing things up but the page refreshes meaning it was successful right? I can try to use jquery's post ins...
- Wed Feb 04, 2009 11:16 pm
- Forum: PHP - Code
- Topic: PHP/Jquery/MySQL Delete a row
- Replies: 4
- Views: 1749
PHP/Jquery/MySQL Delete a row
So i have a page that displays groups with delete links that use Jquery to determine ID and then submit a PHP script through AJAX for the PHP delete function and then refresh the page. But all it does is refresh. I know its grabbing the variable containing the ID correctly through testing but I'm no...