Problem

[Irlan agous]

Hello all,

I have a script,m but it has 3 records in the database, but it only shows me
one record, Why? Its counts 2 but doiesnt show 3. whats wrong here?


$query = "Select count(*) from ervaring" ;
$result = mysql_query($qu ery);
$query_data = mysql_fetch_row ($result);// Haal de gegevens uit de
tabel
$total_num_user = $query_data[0];

if(!$total_num_ user){
?>
<p>
<?
echo "geen ervaringen!";
exit;
} $page_num = $cur_page + 1;// Paginanummer teller
$total_num_page = $last_page_num
= ceil($total_num _user/$records_per_pa ge);


echo "$total_num_use r ervaringen gevonden.
Page $page_num van $last_page_num. \n";

if(empty($cur_p age)){
$cur_page = 0;//
}
$limit_str = "order by datum desc LIMIT ". $cur_page * $records_per_pa ge
.. ",
$records_per_pa ge";// Limiteer de hoeveelheid gegevens per pagina


$query = "Select * from ervaring $limit_str" ;
$result = mysql_query($qu ery);

while($query_da ta = mysql_fetch_arr ay($result)){

$naam = $query_data["naam"];
$leeftijd = $query_data["leeftijd"];
$ervaring = $query_data["ervaring"];
$datum = $query_data["datum"];
}

?> <table border=0 cellpadding=2 cellspacing=1 bordercolor=#2B 5728>
<?
echo " <tr>\n";

echo "<tr> <td bgcolor=FFECC4> <p>Naam:</td><td bgcolor=FFECC4> <p> $naam
</td></tr>";
echo " <tr><td bgcolor=FFECC4> <p> Leeftijd:</td><td bgcolor=FFECC4> <p>
$leeftijd </td></tr>";
echo " <tr> <td bgcolor=FFECC4> <p>Datum:</td><td bgcolor=FFECC4> <p>
$datum</td></tr>";
echo " <tr> <td bgcolor=FFECC4> <p>Ervaringen :</td><td bgcolor=FFECC4> <p>
$ervaring </td></tr> <p>";

echo " </tr>";
}
?>
</table>

[Jan Pieter Kunst]

Re: Problem

Irlan agous wrote:[color=blue]
> Hello all,
>
> I have a script,m but it has 3 records in the database, but it only shows me
> one record, Why? Its counts 2 but doiesnt show 3. whats wrong here?[/color]

Because you loop through the resultset without showing anything:

[color=blue]
> $query = "Select * from ervaring $limit_str" ;
> $result = mysql_query($qu ery);
>
> while($query_da ta = mysql_fetch_arr ay($result)){
>
> $naam = $query_data["naam"];
> $leeftijd = $query_data["leeftijd"];
> $ervaring = $query_data["ervaring"];
> $datum = $query_data["datum"];
> }[/color]


And then, when the loop is finished, you echo just the last row:
[color=blue]
> ?> <table border=0 cellpadding=2 cellspacing=1 bordercolor=#2B 5728>
> <?
> echo " <tr>\n";
>
> echo "<tr> <td bgcolor=FFECC4> <p>Naam:</td><td bgcolor=FFECC4> <p> $naam
> </td></tr>";
> echo " <tr><td bgcolor=FFECC4> <p> Leeftijd:</td><td bgcolor=FFECC4> <p>
> $leeftijd </td></tr>";
> echo " <tr> <td bgcolor=FFECC4> <p>Datum:</td><td bgcolor=FFECC4> <p>
> $datum</td></tr>";
> echo " <tr> <td bgcolor=FFECC4> <p>Ervaringen :</td><td bgcolor=FFECC4> <p>
> $ervaring </td></tr> <p>";
>
> echo " </tr>";
> }
> ?>
> </table>[/color]

Solution: put the "echo"s inside the "while"-loop.

JP

--
Sorry, <devnull@cauce. org> is a spam trap.
Real e-mail address unavailable. 5000+ spams per month.