help!!! only returns one result

[morrisoner]

hey, i am just starting out on PHP and i am starting my HSC project. I do a query for MySQL and it returns multiple results (I checked using phpMyAdmin). But I don't know why the code only returns one result. Below is the bit that doesn't work. Can someone please help me out????

<?php

					$db = mysql_connect("localhost");
					mysql_select_db("video", $db);

					each($HTTP_POST_VARS);

					if ($submit)
					{
						$second = false;


						if ($vidName)
						{
							$result = mysql_query("SELECT * FROM movies WHERE name LIKE '%$vidName%'");
							while ($video = mysql_fetch_array($result))
							{
				?>
                <tr> <font color="<?php if ($second) { echo "#CCCCCC"; $second = false;} else { echo "#FFFFFF"; $second = true; }?>"> 
                  <td height="25" valign="top"><?php echo $video["name"] ?></td>
                  <td valign="top"><?php echo $video["release"] ?></td>
                  <td valign="top"><?php echo $video["genre"] ?></td>
                  <td valign="top"><?php echo $video["rating"] ?></td>
                  <td valign="top"><?php echo $video["type"] ?></td>
                  <td valign="top"><?php echo $video["class"] ?></td>
                  <td valign="top"><?php echo $video["available"] ?></td>
                  <td valign="top"> 
                    <?php
					$actorID = $video["actor1"];
					$result = mysql_query("SELECT actorID, name FROM actors WHERE actorID = $actorID");
					$actor = mysql_fetch_array($result);
					echo $actor["name"];
					?>
                  </td>
                  </font> </tr>
				  <?php
				  			}
						}
					}
				  ?>

[[deleted]]

In your second query you are overwriting the first's results.

Change:

$result = mysql_query("SELECT actorID, name FROM actors WHERE actorID = $actorID");
$actor = mysql_fetch_array($result);

to:

$result2 = mysql_query("SELECT actorID, name FROM actors WHERE actorID = $actorID");
$actor = mysql_fetch_array($result2);

[morrisoner]

thanx champ!!!!!!!!!!!!!!!

[markdark]

What do ya think of your coding style? It's easier to find errors when you use a good coding style!!! 😉