mysql_query("DELETE FROM `users` WHERE `email`='omg@omg.com'");

<?PHP

$link = mysql_connect('localhost','root','');

if(!$link){

echo('Nevar savienoties ar datu bāžu serveri: '.mysql_error());

}

$db = mysql_select_db('data1',$link);

if(!$db){

echo('Nevar izvēlēties datu bāzi: '. mysql_error());

}

mysql_query("SET NAMES 'utf8';",$link);

/*

function random_string($garums){

$buffer = '';

for($i=0;$i<$garums;$i++){

$rand = rand(97,122);

$buffer .= chr($rand);

}

return $buffer;

}

$sql_buffer = "INSERT INTO `userlist` (`username`,`email`,`pasw`) VALUES".PHP_EOL;

for($i=0;$i<30;$i++){

$user = random_string(rand(7,9));

$password = sha1( random_string(2) );

$email = random_string(5).'@gmail.com';

$sql_buffer .= "('$user','$email','$password')";

if($i<29){

$sql_buffer .= ','.PHP_EOL;

}else{

$sql_buffer .= ';';

}

}

///echo $sql_buffer;

*/

///exit;

///mysql_query($sql_buffer);

///mysql_query("UPDATE `users` SET `email`='omg@omg.com' WHERE `id`='3'");

mysql_query("INSERT INTO `users` SET `email`='omg@omg.com', `username`='', `pasw`='';");

///mysql_query('TRUNCATE TABLE `userlist`;');

function lprint($link){

$rezultats = mysql_query("SELECT * FROM `users`;",$link);

while($liinija = mysql_fetch_object($rezultats)){

echo $liinija->ID.' - '.$liinija->username.' - '.$liinija->email.'<br>';

}

}

lprint($link);

mysql_query("DELETE FROM `users` WHERE `email`='omg@omg.com'");

lprint($link);

?>