Getting Null value with JSON from MySQL, how to retrive data from MySQL to JSON correctly?
- by sky
I'm using following code but cannot return data from MySQL.
This is the output:
<script type="text/javascript">
var somethings= [null,null,null];
</script>
It does have three post, but I couldn't get the title(message) output.
EDIT: this is the code I'm using:
<?php
$session = mysql_connect('localhost','name','pass');
mysql_select_db('dbname', $session);
$result= mysql_query('SELECT * FROM posts', $session);
$somethings= array();
while ($row= mysql_fetch_assoc($result)) {
$somethings[]= $row['something'];
}
?>
<script type="text/javascript">
var somethings= <?php echo json_encode($somethings); ?>;
</script>
This is the table:
message
Try iPhone post!
Welcome to Yo~ :)
??!
