MySQL: would this work?

[GodSpeed]

//insert information
    $date = getdate();
    $insert_query = "insert into ladder
                     SET username=$username,
password=$password,
name=$name,
squad=$squad,
icq=$icq,
email=$email,
ip=$REMOTE_ADDR,
datelast=$date";
    
$results = mysql_query( $insert_query );
    if ( !$results = mysql_query($query) ) 
    {
       echo ( "<p>" . mysql_error() );
    } 

im trying to add those fields to my DB. i have it connected and selected. When i run that, it doesnt give me an error, but it when i run

mysql_affected_rows($insert_query) 

it shows 0?

[freddydoesphp]

Like I said before you'll need quotes around those elements

//insert information
    $date = getdate();
    $insert_query = "insert into ladder
                     SET username='$username',
password='$password',
name='$name',
squad='$squad',
icq='$icq',
email='$email',
ip='$REMOTE_ADDR',
datelast='$date'";
    
//for debugging
print $insert_query;

$results = mysql_query( $insert_query );
    if ( !$results = mysql_query($query) ) 
    {
       echo ( "<p>" . mysql_error() );
    } 

[GodSpeed]

ok thanks for the tip.