I've been having a lot of trouble getting this query to work:
PHP Code:
$sql "INSERT INTO multihoster (id, username, password, email, spaceused) SELECT unapproved.id, unapproved.username, unapproved.password, unapproved.email, unapproved.spaceused FROM unapproved WHERE username='$value'";
mysql_query($sql); 
All that I am trying to do is insert into table multihoster the values from table unapproved where row username = $value. I can't seem to figure this out. Can someone help?