Need a simple SQL Query

[kevinkhan]

I need to modify this query

 

"INSERT INTO `bebo` VALUES(null, '$user', 'No Comment Posted')

 

so that it will only insert $user if it not already there...

 

Does any one know how i can do this?

 

Thanks

[lovelyvik293]

first select the row where you have to insert the $user.And then insert it.

[scarhand]

<?php

$usercount = mysql_result(mysql_query("select count(*) from users where username='$user'"), 0);

if ($usercount == 0)
  // insert using another mysql query

?>