Search found 6 matches

by grandroyal
Thu Feb 12, 2009 5:23 pm
Forum: PHP - Code
Topic: Update issues
Replies: 5
Views: 278

Re: Update issues

John 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.
Thank you so much
by grandroyal
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'
by grandroyal
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(&...
by grandroyal
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.
by grandroyal
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...
by grandroyal
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...