# \[PHP\] Membership system **URL:** \ **Category:** programming\ **Created:** [April 15, 2006, 6:04pm UTC](https://forum.kirupa.com/t/php-membership-system/185705 "2006-04-15T18:04:11Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Zaxza](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/zaxza/32/2227_2.png) [@Zaxza](https://forum.kirupa.com/u/Zaxza)\ **Post date:** [April 15, 2006, 6:04pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/1 "2006-04-15T18:04:11Z")
I’m working on a membership system. My only problem is i need it so you can only view the pages if your registered and logged in. Also i accidently deleted a section of my code and cant remember how to fix it. It collects all the data from the MySQL database. I know this probably seems really stupid, but my knowledge of PHP is poor. Thanks for the help… ---
**Author:** ![bwh2](https://avatars.discourse-cdn.com/v4/letter/b/8c91f0/32.png) [@bwh2](https://forum.kirupa.com/u/bwh2)\ **Post date:** [April 15, 2006, 7:45pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/2 "2006-04-15T19:45:13Z")
the code your’e missing sounds like a mysql SELECT statement. as far as setting a login, you basically need to use either php sessions or cookies. then you’ll basically have an if statement in your php to test whether the person is logged in based on the session or cookie. ---
**Author:** ![Zaxza](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/zaxza/32/2227_2.png) [@Zaxza](https://forum.kirupa.com/u/Zaxza)\ **Post date:** [April 15, 2006, 9:27pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/3 "2006-04-15T21:27:00Z")
I’ve done that but still nothing comes up, to link to data from the database i should be using \ right? ---
**Author:** ![JoshuaJonah](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/joshuajonah/32/1775_2.png) [@JoshuaJonah](https://forum.kirupa.com/u/JoshuaJonah)\ **Post date:** [April 15, 2006, 9:29pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/4 "2006-04-15T21:29:34Z")
ummm…no ---
**Author:** ![Zaxza](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/zaxza/32/2227_2.png) [@Zaxza](https://forum.kirupa.com/u/Zaxza)\ **Post date:** [April 15, 2006, 9:32pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/5 "2006-04-15T21:32:08Z")
then what do i use? ---
**Author:** ![JoshuaJonah](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/joshuajonah/32/1775_2.png) [@JoshuaJonah](https://forum.kirupa.com/u/JoshuaJonah)\ **Post date:** [April 15, 2006, 9:32pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/6 "2006-04-15T21:32:34Z")
select ---
**Author:** ![JoshuaJonah](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/joshuajonah/32/1775_2.png) [@JoshuaJonah](https://forum.kirupa.com/u/JoshuaJonah)\ **Post date:** [April 15, 2006, 9:36pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/7 "2006-04-15T21:36:33Z")
Your gonna want a book for this one. ---
**Author:** ![Zaxza](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/zaxza/32/2227_2.png) [@Zaxza](https://forum.kirupa.com/u/Zaxza)\ **Post date:** [April 15, 2006, 9:39pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/8 "2006-04-15T21:39:57Z")
ive done the select bit, i mean if i wanna display the username which i have selected from the database, i use \…? ---
**Author:** ![hl1](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/hl1/32/849_2.png) [@hl1](https://forum.kirupa.com/u/hl1)\ **Post date:** [April 15, 2006, 9:41pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/9 "2006-04-15T21:41:11Z")
$row = mysql\_fetch\_assoc($query); $username = $row[‘username’]; echo $username; ---
**Author:** ![FreakSheep](https://avatars.discourse-cdn.com/v4/letter/f/d9b06d/32.png) [@FreakSheep](https://forum.kirupa.com/u/FreakSheep)\ **Post date:** [April 16, 2006, 4:35am UTC](https://forum.kirupa.com/t/php-membership-system/185705/10 "2006-04-16T04:35:05Z")
[www.phpfreaks.com/tutorials/40/0.php](http://www.phpfreaks.com/tutorials/40/0.php) ---
**Author:** ![Zaxza](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/zaxza/32/2227_2.png) [@Zaxza](https://forum.kirupa.com/u/Zaxza)\ **Post date:** [April 16, 2006, 8:33pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/11 "2006-04-16T20:33:20Z")
[SIZE=1][U] **I’m having this problem:** [/U][/SIZE] **Warning** : mysql\_fetch\_array(): supplied argument is not a valid MySQL result resource in **C:\AppServ\www\sites\New Folder\includes\select.php** on line \*\*4 [SIZE=1][U]this is my code: [/U][/SIZE]\*\*[SIZE=1][SIZE=2] ```php // Get users information $result = mysql_query("SELECT * FROM `test` WHERE `userid` = '".$u."' LIMIT 1"); while($r=mysql_fetch_array($result)) ``` [/SIZE] Can anyone help? [/SIZE] ---
**Author:** ![Zaxza](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/zaxza/32/2227_2.png) [@Zaxza](https://forum.kirupa.com/u/Zaxza)\ **Post date:** [April 16, 2006, 8:46pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/12 "2006-04-16T20:46:27Z")
ok i sorted that problem out, but still it doesnt display my users info… any ideas?? i’m using this to display my username for “userid 1”… ```php ``` it isnt working, any help? ---
**Author:** ![Zaxza](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/zaxza/32/2227_2.png) [@Zaxza](https://forum.kirupa.com/u/Zaxza)\ **Post date:** [April 16, 2006, 9:14pm UTC](https://forum.kirupa.com/t/php-membership-system/185705/13 "2006-04-16T21:14:27Z")
Ah its alright, i sorted it. no doubt i’ll be back with more questions. Thanks for the help…