simple mysql insert question

[Synergic]

i haven't figured why i'm getting unidentified variable with the following insert statements. i mean using values work fine but as soon as i stick a variable inside the insert clause i get unidentified variable:

[code]

<?php
include_once 'DatabaseClass.php';

class BookStoreClass extends DatabaseClass {

var $name = 'hello';
var $birthday = 'hello';

function registerUser($user)
{
parent::connect();

mysql_query ("INSERT INTO birthdays (name, birthday) VALUES ('$name','$birthday')");
parent::close();
}

}
?>

[/code]

Notice: Undefined variable: name in

Notice: Undefined variable: birthday in

[craygo]

i am not familiar with classes and such but something this simple why make it complicated

[code]<?php
$name = 'hello';
$birthday = 'hello';

$sql = "INSERT INTO birthdays (name, birthday) VALUES ('$name', '$birthday')";
  mysql_query($sql) or die(mysql_error());
?>[/code]

Ray

[Synergic]

actually i still want to use OO concepts. i still can't figure out why the original code doesn't work. If i remove the variables and insert values instead it works no problems. The funny thing is if i declare the variable locally and use it, it works.

[Synergic]

and if i pass a $user object with a username, password i can print it within the function, it works. However if i use it in the insert statement i get undefined variable:

$sql = "INSERT INTO birthdays (name, birthday) VALUES ('$user->getUserName()', '$birthday')";

[Synergic]

ok solution was to:

[code]

$sql = "INSERT INTO userinfo VALUES ('','".$user->getUserName()."')";

[/code]

???