Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Apr 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    display the database

    can anybody help me am new to php/mysql

    i have two tables in my database(name knownerror)

    table1
    username userid
    php 1
    c 2
    c++ 3

    table2
    userid problemid error solution
    1 1 no clear
    2 2 yes notclear
    3 1 yes notclear

    like this.my problem in that was i have webpage displays like this
    php
    c
    c++

    if i click php, the database display in the (next) result page is


    problemid error solution
    1 no clear
    1 yes notclear


    can anybody understand this pleasegive the coding how to do.

  • #2
    Senior Coder
    Join Date
    Jul 2005
    Location
    UK
    Posts
    1,051
    Thanks
    6
    Thanked 13 Times in 13 Posts
    You're going to need to show us some code if you want a fix - but if I had to guess I'd say your second query is matching userid to problemid, instead of userid to userid.


  •  

    Posting Permissions

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