PHP while loop?

Question

Im using a while loop to echo out the results from my query, BUT there will only ever be one result, what else can I use instead of WHILE?

$query = "SELECT * FROM dvd_library WHERE dvd_id = '$dvd'";
$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){

//DO STUFF

}

Answer 1

If there is only one result per sql query, then the while loop will only go through once. If there are more than one results, it will go through each result. I don't know of any other ways to perform this function, but the while loop should work in every situation for an sql query.

Answer 2

If there is only going to be one result, then you don't have to use a while loop. Just put something like this:



$query = "SELECT * FROM dvd_library WHERE dvd_id = '$dvd'";

$result = mysql_query($query) or die(mysql_error());



$row = mysql_fetch_array($result);



Then whenever you need to put out one of your results, use a line like this:

echo $row['columnname'];

Answer 3

Use an "if" statement. That way if an empty set is returned it can be easily dealt with:



$query = "SELECT * FROM dvd_library WHERE dvd_id = '$dvd'";

$result = mysql_query($query) or die(mysql_error());



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



//DO STUFF



} else {



// DO OTHER STUFF IF NO RECORDS WERE RETURNED



}

Answer 4

for



search it up on php