db veribles

[Smifffy]

how can i get this code to put any veribles into the standerd $##### format

// generate and execute query
$query = "SELECT level, name, password, email FROM login WHERE name = '$UserName' AND password='$Password'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
if(mysql_num_rows($result) > 0) {
    // then I guess the username and password was correct, eh?
    // Now get the 'level':
    $row = mysql_fetch_row($result);
	echo $level = $row[0];

[RayCuz]

Smiffy,

You could do something like so after you run your query:

$normal_vars = mysql_fetch_array($result);

// Now you have them all in $normal_vars
// Then asign them to variables if needed like so
$level = $normal_vars['level'];
$name = $normal_vars['name'];

// and so on and so on
// or you could just use them like $normal_vars['level']

Hope this helps

Regards,
Ray

[the_Igel]

have a glance:

http://www.php.net/manual/en/function.extract.php