Results 1 to 8 of 8

Thread: code to display users

  1. #1
    Member
    Join Date
    May 2005
    Location
    waraynon.com
    Posts
    93

    code to display users

    hi there...
    can anyone pls help me with my little query?
    am building up database and am having trouble how to display the registered users in a particular page..
    can anyone suggest a sample script?
    that would be fo great help...thanks a lot.
    .sig na ture.

  2. #2
    Shadow Programmer mmelby's Avatar
    Join Date
    Jul 2002
    Location
    Ft. Myers, FL
    Posts
    291
    I think we need a LOT more information...

    What is the backend (database(SQL, MySQL, Access, ...))?

    What lanquage (ASP, PHP, VB...)?

    What is the DB structure?

    There are more questions but this should be a good start.
    Work... Some days it's just not worth chewing through the restraints...

  3. #3
    Old-Fogey:Addicts founder Terr's Avatar
    Join Date
    Aug 2001
    Location
    Seattle, WA
    Posts
    2,007
    You need to explain in some detail how the database is structured before someone can help you with a query.
    [HvC]Terr: L33T Technical Proficiency

  4. #4
    Member
    Join Date
    May 2005
    Location
    waraynon.com
    Posts
    93
    oh yes...sorry bout that...
    i just need a sample script that works on php and mysql...
    there would be unlimited user registration and will display their info on a mainpage provided by their input information.
    am building a registry website wherein certified workers can register...
    i hope this not much of an info..lol
    .sig na ture.

  5. #5
    Senior Member
    Join Date
    Apr 2004
    Posts
    228
    The sample in PHP would be

    //Select user names from the table Users
    $users = mysql_query("SELECT User_Name from Users;");

    //while there are user name provided by the database
    while ($user_array = mysql_fetch_array($users)) {

    //assign each of them in turn to user_name variable
    $user_name = $user_aaray["User_Name"];

    //and print that variable on the page
    echo $user_name;


    If you still needed that sample
    Don\'t post if you\'ve got nothing constructive to say. Flooding is annoying

  6. #6
    Member
    Join Date
    May 2005
    Location
    waraynon.com
    Posts
    93
    a sample php/mysql script to search and display users in my database provided with their information.
    .sig na ture.

  7. #7
    Senior Member
    Join Date
    Apr 2004
    Posts
    228
    Quote Originally Posted by yatot
    a sample php/mysql script to search and display users in my database provided with their information.
    Look maty, do some learning then

    Nobody here is going to do your work for your around here

    The script I gave you does exactly that, only you need to expand it a bit to include all the data you need. If you just can't believe that this is that simple, well I guess it's just that simple
    Don\'t post if you\'ve got nothing constructive to say. Flooding is annoying

  8. #8
    Member
    Join Date
    May 2005
    Location
    waraynon.com
    Posts
    93

    Smile

    lol...yeah..i fully understand. thanks a lot dude. am working on it now.
    .sig na ture.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •