AbydosGater Posted September 15, 2006 Share Posted September 15, 2006 Hi, ok i need just a little bit of help with a script ive been working on, but i have to re-write it totally,I will be using this script for many things but the best example is in my database table i have two or more fields, like in my members table i have a number of fields of information for each member, but the main two would be 'id' and 'username', and i want to display my members list, But to the point how would i get my script to display each row from the table? say if i just wanted to display the usernames, how would i pull the username for each 'id'?Any help is greatly appriciated!ThanksAbydosgater Quote Link to comment Share on other sites More sharing options...
fenway Posted September 15, 2006 Share Posted September 15, 2006 SELECT username FROM yourTable?Maybe I've missed something. Quote Link to comment Share on other sites More sharing options...
AbydosGater Posted September 15, 2006 Author Share Posted September 15, 2006 No lol maybe this should be in PHP Help but i want to get the script to display all the usernames, would that do that? Quote Link to comment Share on other sites More sharing options...
fenway Posted September 16, 2006 Share Posted September 16, 2006 Once you're retrieved all the records, a simple iteration should be able to loop through all the results. If you need help with the PHP itself, then yes, I'll move this thread. Quote Link to comment Share on other sites More sharing options...
AbydosGater Posted September 17, 2006 Author Share Posted September 17, 2006 Yeah please if you would be able to move the topic, as i will be needing some help. Quote Link to comment 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.