using replace into - is it an efficient option
Hi, i decided to do a member status indicator for my script, such as brb, on phone, away, that sort of thing and so i made a small table to hold the status.
It only has two fields, mem_id and status. i didnt originally have a primary key but after doing some reading on this option i figured i needed one so i made the mem_id the unique primary key.
I know there are concerns regarding server stress for lack of a better word when using this option on larger tables, but since this table is so small, im wondering if it is efficient to use this option.
The mod is built and it works, but i did want to ask because i trust the feedback here.
Here is my query.
//update the status table
$query = "REPLACE INTO member_status VALUES ('$userid', '$status')";
$retvalu=mysql_query($query,$link) or die(mysql_error());