Ok, I'm trying to do a delete tables thing, I have a system working where there is a list of arrays down a page, anyways, when I use this script, I get "Can't Delete". I made it myself and I'm pretty new so I know it probably has some errors, any help would be nice.
It's deleting by date, and the date is entered in the browser by a Request function, ex..
www.site.com?utm=1223032:22
the UTM in the mysql script is USERTIME. the usertime is achived in the method i showed you above.
Thank you.
<?php
require("/home/brayden/public_html/includes/config.php");
mysql_connect ($hostname, $db_login, $db_pass);
mysql_select_db($database);
$utm1 = $_REQUEST['utm'];
# $reqid = $_REQUEST['id'];
$select_data=("SELECT clan_name, clan_rank, socom_rank, gb_id, member_num, home_server, first_name, last_name, age, leaders_name, email, email_confirm, aim, yahoo, msn, opmsg, date_time, guest_ip FROM cfrecords");
$ver=mysql_query($select_data);
$delete_data=("DELETE FROM cfrecords WHERE `date_time` = `utm1` LIMIT 1;");
$ver=mysql_query($delete_data) or die("Can't Delete?");
echo "Deleted Successfully!";
echo($utm);
?>
