Retrieve multiple row for database (Ajax, Javascript, PHP)

See more:

Javascript

PHP

Ajax

I want to retrieve multiple rows from my mysql database with Ajax, Javascipt, PHP but I seem to be running into problem. My codes are below:

<?php

include"connect.php";

$user_id=$_POST['user'];

$query = "SELECT fname,sname FROM info WHERE userid = '$user_id' ";
  $result = mysql_query($query);
   
  while ($row = mysql_fetch_array($result)){
   
  

    $fname= $row['fname'];
	
    $sname= $row['sname'];
 
   

    $results[] = array("sname" => $fname, "fname" => $sname);

  }
  header('Content-type:application/json');
  exit(json_encode($results)); 
  
  ?>

<script>


$(function(){
    // Don't worry about this

    $.ajax({
		
                                      
      url: 'list.php',                  //the script to call to get data          
      data: "?user=5778", //5778 is a sample data to pass to list.php
                                       
      dataType: 'json',                //data format      
      success: function(data)          //on recieve of reply
      {

		
		
		 var html, comment;
            for(var i = 0; i < data.length; i++) {
                comment = data[i];
                html += '<td>'+ comment.id + '</td><td>' + comment.vname + '</td><td> details</td>'
            }
            $('#output1').html(html);
		
		
	  }
});
});

</script>

Please I need help. I want it to automatically generate a table on the page that is, each result on a new row. thanks