MYSQL Select code.

[Foser]

Im trying to make this somewhat statement which says through mysql_query(); somthing like:

 

("SELECT username = $user FROM user_info WHERE rights = $rights");
// then put $rights which has been never been valued before
$_SESSION['RIGHTS'] = $rights; 

 

So correct me if im wrong i want to do something like this.

if anyone could help me form this up in a formal mysql_query manner, since ive done a lil search but didnt find much about it.

[JasonLewis]

not sure i understood you correctly but here is what i came up with:

 

$rights = mysql_result(mysql_query("SELECT `rights` FROM `user_info` WHERE `username`='{$user}'"),0);
$_SESSION['RIGHTS'] = $rights;

 

hope i understood you correctly.

[redarrow]

<?php

$query="SELECT * FROM 'user_info' WHERE `username` = '$user' AND `rights` = '$rights' ";

$result=mysql_query($query)or die("mysql_error");

if(mysql_num_rows($result)>0){

$_SESSION['RIGHTS'] = $rights;

}

?>