Delete records

[ares1981]

Hi all

I have a site with regesterd members but I don't have a button for them to deleite there account,

need some code dudes.

hes what I got just not working ..........................

code try 1

if(isset($_POST['delete']))
{


$getuserinfo="SELECT * from b_users where username='$SESSION[user]";
$getuserinfo="SELECT * from wp_users where user_login='$SESSION[user]'";
$getuserinfo="SELECT * from usersgnet where name='$SESSION[user]'";


$delname="DELETE from wp_users where user_login='$SESSION[user]'";
mysql_query($delname) or die(mysql_error());

$delname="DELETE from usersgnet where name='$SESSION[user]'";
mysql_query($delname) or die(mysql_error());

$deluser="DELETE from b_users where username='$SESSION[user]'";
mysql_query($deluser) or die("Could not delete user");
print "User deleted";



Code try 2

$emp_id = $_SESSION['user'];

$sql = "DELETE * form usersgnet".
"WHERE emp_id = $name" ;

mysql_select_db('gnetuk_net');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not delete data: ' . mysql_error());
}
echo "Deleted data successfully\n";
mysql_close($conn);


peace

[Rksk]

there is no magic PHP MySQL Delete From

Frist learn. then code.

[ozziemale31]

re

$name = cleanQuery($_GET["name"]);
$sql = "DELETE * form usersgnet". "WHERE emp_id = $name" ;

a link querying the get function
http://sitename.com/delelete.php?&name=$name

just an example

[ares1981]

ok thanks all

i found it out in the end thanks XD

but how do i delete a record that matches a record from another table?

anyone got this?

[Rksk]

but how do i delete a record that matches a record from another table?

Use this way:
DELETE FROM table1 JOIN table2 ON table1.username = table2.username WHERE table1.username = "username";

SQL INNER JOIN Keyword
mysql - SQL DELETE with INNER JOIN - Stack Overflow