Re: Submit form Problems

[Jonathan Stephens]

$query = "SELECT * FROM ts1news WHERE ts1_title={$_GET['id']}";

$query = "DELETE FROM ts1news WHERE ts1_title={$_POST['id']} LIMIT 1";

If ts1_title is a string, then these need to be

$query = "SELECT * FROM ts1news WHERE ts1_title='{$_GET['id']}'";

$query = "DELETE FROM ts1news WHERE ts1_title='{$_POST['id']}' LIMIT 1";

Remember: STRINGS IN QUERIES MUST BE QUOTED.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle



Edited 1 time(s). Last edit at 06/09/2005 11:50PM by Jon Stephens.