Cannot output json from MySQL - getting null value

Posted by sky on Stack Overflow See other posts from Stack Overflow or by sky
Published on 2010-04-19T16:34:59Z Indexed on 2010/04/19 16:43 UTC
Read the original article Hit count: 208

Filed under:
|
|
|

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> 

© Stack Overflow or respective owner

Related posts about JSON

Related posts about JavaScript