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 to the CF scene
    Join Date
    Aug 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to display all the record that matches the condition instead of just 1?

    Hi ppl I need help with my php basically I manage to get my php to display the uname that matches the sql condition however it only return 1 record when there are 2 record that match the condition I understand that my code can only return the first row instead of the second or third row that matches the condition my question is how to modify my code to make it able to display not only the first but all of the row that fulfill the sql condition?

    PHP Code:
    $resultpostal=mysql_query("SELECT location.uname,location.uid FROM location,districts WHERE districts.districtno ='57' AND
    location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng"
    );

    $counterx=0;
    while(
    $row=mysql_fetch_array($resultpostal)){
    foreach(
    $row as $col_value){
    $temp[$counterx]=$col_value;
    $counterx++;
    }


      
    $report.="uid"."=".$temp[0]."&";
      
    $report.="uname"."=".$temp[1]."&"

  • #2
    New to the CF scene
    Join Date
    Aug 2007
    Location
    Kolkata,India
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Use LEFT JOIN instead of an INNER JOIN


  •  

    Posting Permissions

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