I found the following code for deleting data from a MySQL database...

<?php
mysql_connect("localhost","Username","Password")  
or 
die("could not connect"); 
mysql_select_db(users); 

	$sql = "DELETE FROM users WHERE userid=7";
    $result = mysql_query($sql);
?>

So in this case i want to be deleting the row where the userid is 7 in the users table...

Although it doesn't seem to work, is there an error in the code or anything???

Thanks

-James

You need to have quotes around 'users' in mysql_select_db, for starters.

PHP Code:

mysql_select_db('users'); 


And you can always place an if to see if anything happened.

PHP Code:

if(mysql_affected_rows() < 1)
    die('Nothing happened!'); 


Thanks

I also noticed i had put the table name instead of the database name

-James

Yeah, it reminds me of the ThinkGeek shirt:

SELECT FROM users WHERE clue > 0
0 Rows Returned.