> $sql = "SELECT * FROM $table_name
> WHERE member = \"$member\" AND pw = \"$pw\"
> ";
presumably you then have something like ...
$result = mysql_db_query($dbhandle, $sql);
if (mysql_num_rows > 0)
{ $authorised = true;
// ... now you can do
$sql_fields = mysql_fetch_array($result);
$userlevel = $sql_fields["userlevel"];
} else
{ $authorised = false;
$userlevel = 0;
}
Tim Ward
Senior Systems Engineer
Please refer to the following disclaimer in respect of this message:
http://www.stivesdirect.com/e-mail-disclaimer.html
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: 12 March 2001 11:04
> To: [EMAIL PROTECTED]
> Subject: Using selected fields
>
>
>
>
> Hi there,
> Firstly a big thanks to those who pointed me in the direction
> of 'PHP-fast and
> easy web development'. it was/is a great book, and I have
> learnt loads on the
> past week.
>
> Anyhoo...
>
> I have a php page and included the line:
>
> $sql = "SELECT * FROM $table_name
> WHERE member = \"$member\" AND pw = \"$pw\"
> ";
>
> Now I have a third column called 'userlevel'.
>
> I have a cookie that activates on successfully matching the
> member and pw fields
> from a form on the previous page. make sense?
>
> How can I tell the page to use the userlevel colunm too?
>
> Here is the relevent section to my code... can anyone point
> me in teh rigth
> direction please???
>
> ============================
>
> $sql = "SELECT * FROM $table_name
> WHERE member = \"$member\" AND pw = \"$pw\"
> ";
>
> $result = mysql_query($sql)
> or die ("Can't execute query.");
>
> $num = mysql_numrows($result);
>
> if (($num != 0) && ($userlevel == 1)) {
>
> $cookie_name = "auth";
> $cookie_value = "ok";
> $cookie_expire = "";
> $cookie_domain ="";
> setcookie($cookie_name, $cookie_value, $cookie_expire, "/",
> $cookie_domain, 0);
>
> $display_block ="
>
> <p><B>Secret area:</B>
> <UL>
> <LI><a href=\"secreta.php\">secret page a</A>
> <LI><a href=\"secretb.php\">secret page b</A>
> <LI><a href=\"secretc.php\">secret page c</A>
> <LI><a href=\"secretd.php\">secret page d</A>
> <LI><a href=\"secreteb.php\">secret page e</A>
> </UL>
> ";
>
> } else {
>
> header("Location: http://www.mypage.com");
> exit;
> }
>
>
>
> =================
>
> Thanks guys...
> Tris...
>
>
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
>
> **********************************************************************
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
