User Profile

Collapse

Profile Sidebar

Collapse
haot2307
haot2307
Last Activity: Apr 28 '12, 11:10 AM
Joined: Apr 13 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • haot2307
    replied to Count the data
    in PHP
    I want to get the most id_student create programs
    See more | Go to post

      Leave a comment:

    • haot2307
      started a topic Count the data
      in PHP

      Count the data

      I have a table called program within it are several fields including:

      id_program
      id_student

      how I want to get id_student based on highest id_program volumes of data

      let say row in table:-

      row 1 : id_program : 1, id_student :001,
      row 2 : id_program : 2, id_student :001,
      row 3 : id_program : 3, id_student :002,
      row 4 : id_program : 4, id_student :001,
      row...
      See more | Go to post
      • haot2307
        started a topic How to SELECT data using 2 tables and show data only from table 1
        in PHP

        How to SELECT data using 2 tables and show data only from table 1

        I have a table called student
        within it are several fields including:

        student_matric

        I have another table called participation
        within it are several fields including:

        program_id

        student_matric

        status

        query that i need is, it will show all data from the student table. it will check the students who participated in a program can no longer participate...
        See more | Go to post
        No activity results to display
        Show More
        Working...