Another Simple Question.

fuzz01

Guys,

I am using the mysql_fetch_array($result) statement to get the results from the SQL statement and put the details into a array.

$query = "select name, day, month, year, sex from personal where username='$username';";

$result = mysql_query($query);
$rows = mysql_num_rows (mysql_query($query));
while ($record = mysql_fetch_array($result))
{
$row_number = $row_number + 1;
printf("<tr><td width=100></td>

<td width= 200 align=center>%s</td>
<td width= 200 align=center>%s</td>
<td width= 50 />
<td width= 200 align=left>%s %s %s</td>
<td width= 100 align=center>%s</td></tr>\n",
$row_number, $record[name], $record[day], $record[month], $record[year], $record[sex]);
}
echo "</table>\n";

The problem I am having is that the SQL statment returns for example 5 rows but when I use the mysq1_fetch_array, it only outputs the last 4 details, obviously missing the first row from the sql query.

Can someone tell me where I am going wrong.

Many Thanks

Fuzz

Anon

This doesn't really have much to do with your problem but you assing $rows to the mysql_num_rows but never use it. Instead you create the variable $row_number and start by making it 1. Is that intentional? You also shouldn't rely on php initializing variables to 0. It may be the case that php will always behave this way but it'll bite you if you try it in other languages.

Also, it looks like your fourth TD is malformed.

Anon

Ken,

With regards to the mysql_num_row, I use this further on in the program to show the number of rows returned from the SQL statement.

The variable $row_number is there for cosmetics showing the user a record number for that record, this is not used elsewhere in program.

With regards to the initialise variables to zero, I have initialized the majority of the variables to zero further up in program where I have a variable declaration section (sorry, bad habits from languages such as ada, pascal, cobal) do you have any variables in mind with regards to question ??

With regards to the table details they work fine in the browser so I cannot see any problems there.

Many Thanks

Fuzz

Anon

Strange ...
really I can't find anything wrong with your code, I use a similar construct and it works perfectly well ... Are you sure that there ist a record missing ?
Anyway what Ken ment was the line
<td width= 50 /> ... it should be:
<td width= 50 </td>
cya Rob

tomgone

Agree with the others, doesnt seem to be anything wrong with the code. If the $rows and the $row_number variables do not agree, then there might be a NULL record in your database, making the assumption that $row_number is actually 0 before the while loop (try printing it before entering the loop if you are unsure).

Regs
Tom

fuzz01

Thanks guys. It still does not work.

Fuzz

Anon

Thanks Guys for your help, But I have sorted it out after smacking my head against the monitor for a minutes before passing out.

If you recall, the problem I had based on the fact that the mysql_fetch_array seemed to have missed the first row in my sql statement.

Basically, I cheated a bit by running the mysql_fetch_array before the loop and outputing the first line, then in a while re-running the mysql_fetch_array which outputted the data from the second row onwards in the SQL statement.

$result = mysql_query($query);

$rows = mysql_num_rows (mysql_query($query));
if (!$record_test = mysql_fetch_array($result)) {

echo ("<table> <tr> <td width=100 /> <td><font color=red size=5> No Records
Present</font></td></tr></table>");
echo ("<BR>Record = $record_test");

}else {

echo "<table>\n";
$row_number = 1;

printf("<tr><td width=100></td>
<td width= 200 align=center>%s</td>
<td width= 200 align=center>%s</td>
<td width= 50></td>
<td width= 200 align=left>%s %s %s</td>
<td width= 100 align=center>s</td></tr>\n",
$row_number, $record_test[name], $record_test[day], $record_test[month],
$record_test[year], $record_test[sex]);

while ($record = mysql_fetch_array($result))
{
$row_number = $row_number + 1;
printf("<tr><td width=100></td>

If anyone has any better thought/ideas about doing this, please let me know.

Many Thanks For Your Help.

Fuzz

tomgone

Fuzz,

Problem lies in the if statement as it does retrieve the first record, and then when you get to the while loop you retrieve record number 2.

$result = mysql_query($query);
$rows = mysql_num_rows (mysql_query($query));
if (!$record_test = mysql_fetch_array($result)) {

I would consider re-writing the $rows statement first of all to

$rows = mysql_num_rows($result)

and then use the $rows variable in your if statement, then you avoid retrieving the first row. Check if $rows=0 for example.

Tom