Duplicating Records

artisticre

I have pasted my code below. Can someone please let me know why it is echoing the data twice?

<?php

$db = mysql_connect("xxx", "xxx", "xxx");

mysql_select_db("xxx",$db);

$result = mysql_query("SELECT * from coaching where title = '$TitleList'",$db);

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

do {

echo ("<table border=0 align=center width='90%'>

<td class=coachtitle>$myrow[1]</td>

</tr>
<tr>
<td class=coach>$myrow[2]</td>
</tr>

");

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

echo ("</table>\n");

} else {

echo "<br><br><p align=center>There Are No Coaching At This Time!</p>";	
    echo "<br><br><p align=center>Check Back Soon!</p>";

}

bradgrafelman

Your code structure is a bit superfluous (and is probably skipping over the first row returned since you call [man]mysql_fetch_array/man in the if() statement before the do/while loop processes)... the normal method (at least, what I think of as the normal method) of retrieving data from the MySQL result set is:

$query = 'blah blah..';
$exec = mysql_query($query);

while($result = mysql_fetch_array($exec)) {
    // do stuff here
}

If you're only wanting a single row to be returned and echo'ed, then you should add a "LIMIT 1" onto the end of your query.

Also, when posting PHP code, please use the board's [PHP][/PHP] bbcode tags as they make your code much easier to read and analyze.