"SELECT *" misses first record

[richard_PHP]

Using the bog standard 'SELECT * FROM table' but it isn't selecting the first record in the database. Could someone show me where I'm going wrong?

 

CODE:

$conn = mysql_pconnect("****", "****", "****");
mysql_select_db("****", $conn);
$sql = "SELECT * FROM testemonials";
$result = mysql_query($sql, $conn);
$array = mysql_fetch_array($result);
while ($array = mysql_fetch_array($result))
{
$id = $array[id];
$quote = $array[quote];
$person = $array[person];
echo "<p><input name=choice type=radio value=$id /><br />$quote - $person</p>";
}

 

Thanks all in advance!

[PFMaBiSmAd]

$array = mysql_fetch_array($result);

 

^^^ Why do you have that line of code in your program? It is fetching and discarding the first row from the result set.

[silkfire]

Indeed. That very line of code is the reason why the first record is skipped.

 

And

 

$id = $array[id];
$quote = $array[quote];
$person = $array[person];

 

Why are you renaming variables that you echo in the very following statement?

 

Plus those array keys ([id]] need quotes inside them, like this: ['id'].