I know that if the where clause is blank in an update or delete statement, you could lose the whole table.
If I have a query in PHP: UPDATE page_bodies SET page_body = '$html_body' WHERE page_id = '$page_id'
and the variable page_id is not set when the script executes, am I in trouble? Should I check that the variable is set before the query executes, or does the fact that the where statement is present save me from inadvertant damage (even though page_id is not set)?
Thanks,
Aaron
If I have a query in PHP: UPDATE page_bodies SET page_body = '$html_body' WHERE page_id = '$page_id'
and the variable page_id is not set when the script executes, am I in trouble? Should I check that the variable is set before the query executes, or does the fact that the where statement is present save me from inadvertant damage (even though page_id is not set)?
Thanks,
Aaron