User Profile

Collapse

Profile Sidebar

Collapse
cjacks
cjacks
Last Activity: Jan 22 '08, 02:58 AM
Joined: Jan 19 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cjacks
    replied to MySQL Query on multiple tables
    in PHP
    I figured it out. Had to place all the fields I wanted to view in the query statement. Thanks for the help!!!...
    See more | Go to post

      Leave a comment:

    • cjacks
      replied to MySQL Query on multiple tables
      in PHP
      Here is the result of your code. Getting closer.
      2 - 2 -
      20 - 20 -
      37 - 37 -
      41 - 41 -
      53 - 53 -
      56 - 56 -
      57 - 57 -
      60 - 60 -
      69 - 69 -
      71 - 71 -
      73 - 73 -


      Something wrong in my results statement:

      [PHP] $result = mysql_query($qu ery) or die(mysql_error ());
      // Print out the contents of each row into a table
      ...
      See more | Go to post

        Leave a comment:

      • cjacks
        started a topic MySQL Query on multiple tables
        in PHP

        MySQL Query on multiple tables

        I have 2 tables linked by a common field.
        Code:
        users
------
id
....more columns

users_profiles
--------------
users_id
...more columns
        The user id in table users matches the users_id in table users_profile.

        I need to querry from users, get it's match in users_profile and display the reults in php page.


        This is what I got so...
        See more | Go to post
        Last edited by Atli; Jan 19 '08, 10:17 PM. Reason: Added [code] tags.
        No activity results to display
        Show More
        Working...