Page 1 of 1

MYSQL and PHP - Quick Question

Posted: Sun Dec 06, 2009 3:14 pm
by azylka
How can you specify multiple requirements so I can delete a specific record in my database? Would I just list with a comma like:

Code: Select all

<?php
// GET variables
$email = $_GET['email'];
$file = $_GET['file'];
$folder = $_GET['folder'];
// Connect to MySQL
CONNECTION HERE
// Specify req's for delete
mysql_query("DELETE FROM uploads WHERE email=$email, file=$file, folder=$folder");
or die(mysql_error());  
?>
Thanks,
Alex

Re: MYSQL and PHP - Quick Question

Posted: Sun Dec 06, 2009 3:55 pm
by Mirge
mysql_query("DELETE FROM uploads WHERE email='$email' AND file='$file' AND folder='$folder'") or die(mysql_error());

Also see: http://www.php.net/mysql_real_escape_string/

Re: MYSQL and PHP - Quick Question

Posted: Sun Dec 06, 2009 4:19 pm
by azylka
That works well! Thank you SO much!
:drunk: :D