So, your jQuer@本文来源gaodaimacom搞#代%码@网-搞代gaodaima码y might be something like…..
<BR>$.ajax({ <BR>url: 'query.php', <BR>data: {id:10}, <BR>datatype: json <BR>success: function(results) { <BR>if (results.msg == 'success') { <BR>for (var i in data) { <BR>$('#content').append( <BR>'id = ' + results.data[i].id + ', description = ' + results.data[i].description + ', msrp = ' + results.data[i].msrp <BR>); <BR>} <BR>} else { <BR>$('#content').append(results.msg); <BR>} <BR>} <BR>}); <BR>
And your php….
<BR>if (isset($_GET['id'])) { <BR>$sql = "SELECT id, description, msrp FROM tbl WHERE id = '{$_GET['id']}'"; <BR>$return = array(); <BR>if ($result = mysql_query($sql)) { <BR>if (mysql_num_rows($result)) { <BR>$return['msg'] = 'success'; <BR>while ($row = mysql_fetch_assoc($result)) { <BR>$return['data'][] = $row; <BR>} <BR>} else { <BR>$return['msg'] = 'No results found'; <BR>} else { <BR>$return['msg'] = 'Query failed'; <BR>} <BR>header("Content-type: application/json"); <BR>echo json_encode($result); <BR>} <BR>