How to write a query for PHP and MySQL?

How to read a mySQL query (through PHP) into JavaScript variables using AJAX?

• Hi, I have written an AJAX program that interfaces with a mySQL database through PHP pages. Inserting records is no problem at all but I have not figured out how to read a query into individual JavaScript variables yet. I'd like the query results to be in an object or array. Is my best bet to have the PHP page format the query results as an XML document? If so, where do you suggest that I get started here, as I've never created an XML document before? Thanks.

• Answer:

  You have the PHP page return text that creates a JavaScript array, e.g.: <?php echo "var myArray = new Array('apple', 'banana', 'pear');"; ?> Then you call eval() on that response text in JavaScript: eval(responseText);