Problem correct output

vjg

I have a problem getting my PHP script to send the correct output. The script works, but always send the output "Didn't found anything", also when something is found.

I want to it only to send "Didn't found anything" when no results are found.
And when there are results it has to send: "Found $van to $naar with:" with the results.

Below is my script, I tried different things, but it keeps sending "Didn't found anything" with result below it.

Any idea?

$res=mysql_db_query("$db","SELECT Maatschappij, Prijs, Consumptie FROM Vluchten WHERE Vertrek='$van' AND Aankomst='$naar';",$dbh);
$aantal_lijnen=mysql_num_rows($res);

if ($row[1]=="")
{echo "Didn't found anything ";}

else

echo "Found $van to $naar with: ";

for($i=0;$i<$aantal_lijnen;$i++){
$aantal_lijnen=mysql_num_rows($res);
$row=mysql_fetch_row($res);

echo "Maatschappij: $row[0] Prijs: $row[1] Consumptie: $row[2] ";}
echo "<a href=\"$PHP_SELF\">Zoek opnieuw</a>";

LordShryku

You're doing this
if ($row[1]=="")
{echo "Didn't found anything ";}
before you even tell the script what $row is. So of course it's going to be empty. It doesn't exist yet.

vjg

Thank you. The reason I did that was because it helped to stop an other problem.

Now I made the script correct as you said, but if the script gets more then 2 outputs out the MySQL database it shows the number of results, but al with the same data. So, for example I have 3 outputs from the script which would look like:

Found BLA to BLE with:

A
A
A

instead of:

Found BLA to BLE with

A
B
C

So the number of results is correct, 3, but it contains al the same data as number 1...

Can someone confirm I have to look at:
for($i=0;$i<$aantal_lijnen;$i++)

Or did I made an mistake somewhere else?

$res=mysql_db_query("$db","SELECT Maatschappij, Prijs, Consumptie FROM Vluchten WHERE Vertrek='$van' AND Aankomst='$naar';",$dbh);
$row=mysql_fetch_row($res);
$aantal_lijnen=mysql_num_rows($res);

if ($row[0]=="")
{echo "Didn't found anything ";}

else

echo "Found $van to $naar with";

for($i=0;$i<$aantal_lijnen;$i++)

echo "Maatschappij: $row[0] Prijs: $row[1] Consumptie: $row[2] ";
echo "<a href=\"$PHP_SELF\">Zoek opnieuw</a>";

}

LordShryku

Try this instead. mysql_fetch_row should have been in your loop, but mysql_fetch_row is inferior to mysql_fetch_array IMHO.

// $res= your query
$aantal_lijnen=mysql_num_rows($res);
if($aantal_lijnen > 0) { // make sure there's rows
   while($row=mysql_fetch_array($res)) {
      echo "Maatschappij: <b>$row['Maatschappij']</b> 
            Prijs: <b>$row['Prijs']</b> 
            Consumptie: <b>$row['Consumptie']</b><br><br>";
   }
}
else {
   echo "<b>Didn't found anything</b><br><br>";
}

vjg

Thanks, did get some error but it works perfectly now...