mysql_query("UPDATE `users` SET `email`=

<?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);

///exit;

///mysql_query($sql_buffer);

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

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

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

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

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

}

echo (':)');

?>

_______________________________________________________________________