hey gang-
(more php problems apparently...LOL)
I am trying to do a simple query to the DB.. using a specific userID.. as well as return rows between a date range...
I tested the queries in phpMyAdmin.. and they worked fine.. when I threw them into a PHP script, to try and out put the data as XML using a while() loop..
I got 'nothing'...
I dont get any errors when I try to access the script directly through the browser (using WAMP Server to server it up)..
but I 'also' dont get any rows spit out (echo'd) to the screen either?
it would be a bit easier if I got an error to help guide me in my mistake...but I got nothing?
Looking at the source code of the page.. it seems the XML is 'there', structured correctly?
php code:
PHP Code:
<?php
$myDB = mysql_connect('localhost', 'root', '') or die('Connection failed!');
mysql_select_db('fac_paymentdb', $myDB);
$query = "SELECT * FROM payments WHERE collectorID = 'DMD' AND date(subDate) >='2012-01-01' AND date(subDate) <=
'2012-10-17'";
$result = mysql_query($query, $myDB);
$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output .= "<payments>\n";
while($row = mysql_fetch_assoc($result)){
$xml_output .= "\t<payment transID='" . $row['transID'] . "' subDate='" . $row['subDate'] . "' collectorID='" .
$row['collectorID'] . "' pFirst='" . $row['pFirst'] . "' pMiddle='" . $row['pMiddle'] . "' pLast='" . $row['pLast'] . "' pAddress='" . "' />\n";
}
$xml_output .= "</payments>";
echo ($xml_output);
?>
1.) Is this even WRONG?
2.) I seem to recall in the past seeing the XML data structure in the browser if I targeted the script directly?
(is this a situation of using echo() vs print() perhaps?)
thanks