Trying to add user profile to user_system ( register system)

[wizzuriz]

Hello All,

I´v tried to add the user profile to my user register system, I got the login system working just fine but when I try to run some of th query´s from the video user profile I get errors.

Error. Warning: mysql() expects at least 2 parameters, 1 given in /Applications/XAMPP/xamppfiles/htdocs/user_system/core/inc/user.inc.php on line 63

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, null given in /Applications/XAMPP/xamppfiles/htdocs/user_system/core/inc/user.inc.php on line 65
[syntax=php]
// to get the username.
$u_name = $_SESSION['username'];

// try to get user information from data table.
function fetch_user_info($u_name){

$sql = "SELECT
`user_name` AS `username`,
`user_firstname` AS `firstname`,
`user_lastname` AS `lastname`,
`user_weight` AS `weight`,
`user_hight` AS `hight`
FROM `users`
WHERE `user_name` ='{$u_name}'";
// result is line 63.
$result = mysql($sql);
// line 65 is return.
return mysql_fetch_assoc($result);
}
[/syntax]

I can add the user data just fine and review it all in the table but I can´t get it out on the website.

please let me know if you think you know what I´m missing here.

best regards
Wizzuriz

[jacek]

You should be using the mysql_query function. Or if mysql() is one that you defined then you should be passing the correct number of parameters to it.