August 15th, 2005, 02:50 AM
|
|
Registered User
|
|
Join Date: Aug 2005
Posts: 1
Time spent in forums: 10 m 34 sec
Reputation Power: 0
|
|
|
problem with while, fetch, array, result or me
Hi Gurus!
Because im a begginer, I would loke to ask you for help.
So... my application (flash) is connecting to PHP file, which should generate XML with query results. And its not, what makes me desperate.
Anyway the PHP file which is not working like it should looks like:
PHP Code:
<?php
include_once("config.php");
$key = $HTTP_GET_VARS[employeeid];
$result = @mysql_query("SELECT Employee.EmployeeID AS EmployeeID0, Transaction.TransactionAmount AS TransactionAmount0, Employee_1.EmployeeID AS EmployeeID1, Transaction_1.TransactionAmount AS TransactionAmount1, Employee_2.EmployeeID AS EmployeeID2, Transaction_2.TransactionAmount AS TransactionAmount2, Employee_3.EmployeeID AS EmployeeID3, Transaction_3.TransactionAmount AS TransactionAmount3, Employee_4.EmployeeID AS EmployeeID4, Transaction_4.TransactionAmount AS TransactionAmount4, Employee_5.EmployeeID AS EmployeeID, Transaction_5.TransactionAmount AS TransactionAmount5 FROM ((((((((((Employee LEFT JOIN Transaction ON Employee.EmployeeID = Transaction.EmployeeID) LEFT JOIN Employee AS Employee_1 ON Employee.EmployeeID = Employee_1.SupervisorID) LEFT JOIN Transaction AS Transaction_1 ON Employee_1.EmployeeID = Transaction_1.EmployeeID) LEFT JOIN Employee AS Employee_2 ON Employee_1.EmployeeID = Employee_2.SupervisorID) LEFT JOIN Transaction AS Transaction_2 ON Employee_2.EmployeeID = Transaction_2.EmployeeID) LEFT JOIN Employee AS Employee_3 ON Employee_2.EmployeeID = Employee_3.SupervisorID) LEFT JOIN Transaction AS Transaction_3 ON Employee_3.EmployeeID = Transaction_3.EmployeeID) LEFT JOIN Employee AS Employee_4 ON Employee_3.EmployeeID = Employee_4.SupervisorID) LEFT JOIN Transaction AS Transaction_4 ON Employee_4.EmployeeID = Transaction_4.EmployeeID) LEFT JOIN Employee AS Employee_5 ON Employee_4.EmployeeID = Employee_5.SupervisorID) LEFT JOIN Transaction AS Transaction_5 ON Employee_5.EmployeeID = Transaction_5.EmployeeID GROUP BY Employee.EmployeeID, Transaction.TransactionAmount, Employee_1.EmployeeID, Employee.EmployeeID, Employee_1.EmployeeID, Transaction_1.TransactionAmount, Employee_2.EmployeeID, Transaction_2.TransactionAmount, Employee_3.EmployeeID, Transaction_3.TransactionAmount, Employee_4.EmployeeID, Transaction_4.TransactionAmount, Employee_5.EmployeeID, Transaction_5.TransactionAmount HAVING EmployeeID0 LIKE '%".$key."%'") or die("Error ".mysql_errno().": ".mysql_error());
echo '<?xml version="1.0" encoding="UTF-8"?>';
echo '<datapacket>';
while($row=mysql_fetch_array($result)){
$line = '<row EmployeeID0="'.$row[EmployeeID0].'" Amount0="'.$row[TransactionAmount0].'" EmployeeID1="'.$row[EmployeeID1].'" Amount1="'.$row[TransactionAmount1].'" EmployeeID2="'.$row[EmployeeID2].'" Amount2="'.$row[TransactionAmount2].'" EmployeeID3="'.$row[EmployeeID3].'" Amount3="'.$row[TransactionAmount3].'" EmployeeID4="'.$row[EmployeeID4].'" Amount4="'.$row[TransactionAmount4].'" EmployeeID5="'.$row[EmployeeID5].'" Amount5="'.$row[TransactionAmount5].'"/>';
echo $line;
}
echo '</datapacket>';
?>
The result of this file is like:
Code:
<?xml version="1.0" encoding="UTF-8" ?>
<datapacket />
So it stops at line:
while($row=mysql_fetch_array($result)){
Is it possible there is a bug??
Please help.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
