Advanced Search

Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Problem with getting data from mysql

  1. #11
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,156
    Thanks
    262
    Thanked 690 Times in 678 Posts

    Default

    I'm guessing you then do another query for that ID in the users table. That's how many forum databases work, anyway.

    Using the ID allows for a generic representation (ie, ?user=48), and changing usernames. A user can update their name, or an administrator can, and all instances will be updated, as the ID is just a link to the name field in the users table for that individual user (specified by the ID).
    Daniel - Freelance Web Design | <?php?> | <html>| espa˝ol | Deutsch | italiano | portuguŕs | catalÓ | un peu de franšais | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

  2. #12
    Join Date
    Aug 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    How should this query look like?

    SELECT username FROM phpbb_users .... and then???

  3. #13
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,156
    Thanks
    262
    Thanked 690 Times in 678 Posts

    Default

    Where ID = ...
    Daniel - Freelance Web Design | <?php?> | <html>| espa˝ol | Deutsch | italiano | portuguŕs | catalÓ | un peu de franšais | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

Bookmarks

Posting Permissions

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