query doesn't return all the data from table

sakisg

I'm using this code to connect to a mysql db but i get only the first
row from the query.I don't know where's the mistake.Can someone help me with this?

The code:

if(!($result = mysql_query("select distinct emp_name FROM overtime_hours order by emp_name", $dbi))){
print("MySQL reports: " . mysql_error() . "\n");
exit();
}

	$qx = "SELECT ovtime_date";

while($rowx = mysql_fetch_object($result)) {
$qx .= ", IF(emp_name = '$rowx->emp_name', ovtime_hours, 0) AS 'Date'";
}
//$qx .= ", SUM(ovtime_hours) AS \"Total Hours\" ";
$qx .= "FROM overtime_hours ";
$qx .= "GROUP BY ovtime_date";

if(!($dbx = mysql_query($qx, $dbi))){
print("MySQL reports: " . mysql_error() . "\n");
exit();
}
?>
<table border="1">
<tr>
<td bgcolor="#FFFFCC"></td>
<?php
mysql_data_seek($result, 0);
while($rowx = mysql_fetch_object($result)){

	print("<td bgcolor=\"#FFFFCC\">");
	print("$rowx->emp_name");
	print("</td>");
	}

</tr>
<?php
while($dbrow = mysql_fetch_row($dbx)) {
print("<tr>");
$col_num = 0;
foreach($dbrow as $key=>$value){
if($dbrow[$col_num] > 0){
print("<td>$dbrow[$col_num]</td>");
}
else {
print("<td> </td>");
}
$col_num++;
}
print("</tr>\n");
}
?>
</table>

stolzyboy

try using mysql_fetch_array instead

sakisg

I've try it but there is no change.
Can you be more specific please?

stolzyboy

which table do you want to select everything from? relative to your code

sakisg

I'm using one table named overtime_hours and i want to view
the results in a table like an excel sheet.

phpMyAdmin MySQL-Dump

CREATE TABLE nuke_overtime_hours (
oh_id int(11) NOT NULL auto_increment,
emp_name varchar(255) NOT NULL default '',
ovtime_date date NOT NULL default '0000-00-00',
ovtime_hours decimal(10,2) NOT NULL default '0.00',
PRIMARY KEY (oh_id)
) TYPE=MyISAM;

|                 |George | Mary | Jack | Robert | Stefany |

|2002-03-01 |72        |        |       | 159      | 231      |
|2002-03-02 |           |14     |14    | 28        |          |