User Profile

Collapse

Profile Sidebar

Collapse
pakits1582
pakits1582
Last Activity: Feb 13 '12, 07:15 AM
Joined: Feb 8 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pakits1582
    replied to While row displaying repeated values
    in MySQL
    huh?? but the data i've posted is the same..??
    See more | Go to post

      Leave a comment:

    • pakits1582
      replied to While row displaying repeated values
      in MySQL
      i have 3 tables..GRADES, PROSPECTUS and SUBJECT..

      the grade tables looks like this..
      gid| idno |course|year|se m| syear |subid|grade|re marks|
      1 |20110002|BSIT |1 | 1|2011-2012| 41 | 90 | passed|
      2 |20110002|BSIT |1 | 1|2011-2012| 5 | 90 | passed|
      3 |20110002|BSIT |1 | 1|2011-2012| 10 | 90 | passed|
      4 |20110002|BSIT |1 | 1|2011-2012| 13 | 90 | passed|
      5 |20110002|BSIT...
      See more | Go to post

        Leave a comment:

      • pakits1582
        started a topic While row displaying repeated values
        in MySQL

        While row displaying repeated values

        I need help..i have a while loop inside a while loop..
        and it displays repeated values.can anyone help me..thanks in advance...
        Code:
        if ($_REQUEST['sem']==2){
			$result="select g.* from grades as g, prospectus as p where g.idno='".$_REQUEST['idno']."' and g.course='".$_REQUEST['course']."' and g.year='".$_REQUEST['year']."' and g.sem=1 and g.syear='".$_REQUEST['syear']."' and g.remarks='failed'
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...