Using selected fields

From: Date: Mon, 12 Mar 2001 10:50:23 +0000
Subject: Using selected fields
Groups: php.db 
Request: Send a blank email to php-db+get-7308@lists.php.net to get a copy of this message
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. **********************************************************************

« previous php.db (#7308) next »