result only returns 1st table row?

Anon

Hi there...

bloody beginner here, humor me....I managed to connect to mysql and whatnot...wrote my first little test...it works...BUT it returns only the first row of mysql table..
help please? this is the code I am using:

$result = mysql_query("SELECT * FROM cruise");

printf("Ship Name: %s \n", mysql_result($result,0,"ship"));

printf("Cruise Line: %s \n", mysql_result($result,0,"line"));

printf("Itinerary: %s \n", mysql_result($result,0,"destination"));

printf("Advantage Rate: %s \n", mysql_result($result,0,"adv"));
?>

kailien

while ($result = mysql_query("SELECT * FROM cruise"))

{
do something like printf;
}

[deleted]

$result = mysql_query("SELECT * FROM cruise");

// loop through db until myrow returns no relults

if ($myrow = mysql_fetch_array($result)) {

do {

printf("Ship Name: %s \n", $myrow["ship"]);

} while ($myrow = mysql_fetch_array($result));

} else {

    echo "Sorry, no records found!";

}

Anon

HI!

you 'll want to do a couple things as well to make this easier. First you want to give things a chance to fail or not using if statements:

$sql="SELECT * FROM cruise";
if ($result=mysql_query($sql)) { // if the query is successful - go on
if (mysql_num_rows($result) >0) { // if there are more than zero results go on
while($myrow=mysql_fetch_array($result)) { // loop through all the rows returned
printf("Ship Name: %s \n", $myrow["ship"]);

printf("Cruise Line: %s \n", $myrow["line"]);

printf("Itinerary: %s \n", $myrow["destination"]);

printf("Advantage Rate: %s \n", $myrow["adv"]);
}
}
}

I hope that is clear to you and it helps!