Artmark Posted April 27, 2011 Share Posted April 27, 2011 Hi I have a members login form of registration with First name ,last name, login name, Password ,confirm password. its now telling me I have no tables for this. I dont know what values to put in tables. I have all most 200 members. so do i put in 200 in the fields. Dont know what to do. Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/ Share on other sites More sharing options...
PFMaBiSmAd Posted April 27, 2011 Share Posted April 27, 2011 The script you are using probably came with either an installation script that would create the necessary tables or a .sql database script file that you need to run in your database manager. What do the installation instructions that came with your script say to do? Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/#findComment-1206713 Share on other sites More sharing options...
Artmark Posted April 27, 2011 Author Share Posted April 27, 2011 They dont say they do it for you its only the registration and login form. you'll find it here http://www.cpassoc.com.au/PHP-Login.zip Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/#findComment-1206721 Share on other sites More sharing options...
Muddy_Funster Posted April 27, 2011 Share Posted April 27, 2011 How did you get the 200 members without a working login script? Do you have a database backend that you are using with this script? Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/#findComment-1206787 Share on other sites More sharing options...
PFMaBiSmAd Posted April 27, 2011 Share Posted April 27, 2011 The tutorial where you found this script states that the download contains - "a SQL file to create and populate the required tables." Someone in this thread also stated there was likely a .sql script file to do this. Did you look at the files that you were using? Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/#findComment-1206852 Share on other sites More sharing options...
Artmark Posted April 27, 2011 Author Share Posted April 27, 2011 No There are around 200 members in the association belonging to the website, so that how many that need to login. Now I get this message. Query: INSERT INTO members(firstname, lastname, login, passwd) VALUES('mark','wherritt','Artmark','89121d1473e99fb1c6d662bc92a22768') Failed with error: Unknown column 'firstname' in 'field list' Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/#findComment-1207195 Share on other sites More sharing options...
Artmark Posted April 27, 2011 Author Share Posted April 27, 2011 I got it, I added that file and it works , now I need to add those codes to my html pages, , Question do I save them as a PHP page yes. Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/#findComment-1207210 Share on other sites More sharing options...
Artmark Posted April 28, 2011 Author Share Posted April 28, 2011 How Do I set up table for Profile page now. All the pages open and work but are still in original php page at the moment until i transfer them. Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/#findComment-1207326 Share on other sites More sharing options...
Artmark Posted April 30, 2011 Author Share Posted April 30, 2011 Thanks guys Working great, customer is happy. Mark..... Quote Link to comment https://forums.phpfreaks.com/topic/234812-not-know-how-to-set-up-table/#findComment-1208493 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.