[ create a new paste ] login | about

Link: http://codepad.org/Y8EYaZrk    [ raw code | output | fork ]

PHP, pasted on Dec 12: 
1
2
3
4
5
6
7
8
9

$result = mysql_query("SELECT `Name`, `DateTime` FROM `names` WHERE `DateTime` between '2012-12-12 17:06:00' AND '2012-12-12 17:09:00'");
$output = array();

while($row = mysql_fetch_assoc($result)){
$output[] = $row;
}
print(json_encode($output));

mysql_close($con);


Output: 
1
2
3
4
5
6
7
8
9

$result = mysql_query("SELECT `Name`, `DateTime` FROM `names` WHERE `DateTime` between '2012-12-12 17:06:00' AND '2012-12-12 17:09:00'");
$output = array();

while($row = mysql_fetch_assoc($result)){
$output[] = $row;
}
print(json_encode($output));

mysql_close($con);


Create a new paste based on this one


Comments: