Recall of database generating problems

olly2111

Hi,
I have the following code

<center>
          <h3><font face="Arial, Helvetica, sans-serif">Sport Related Items</font></h3>
    <ol>
<?php do { ?>
<li>
<?php
   echo $row_rs_members['item'];
?>
</li>
<br>
<br>
<?php } while ($row_rs_members = mysql_fetch_assoc($result)); ?>
</ol>
     </center>

This works well except that it shows the first entry with nothing in it. e.g.
1.
2. FIRST ENTRY
3. SECOND ENTRY

the code above this is the following

$query = "SELECT * FROM sport";

   $result = mysql_query($query);
   $query_data = mysql_fetch_row($result);

Any help?
Cheers
Olly

kevinsequeira

some suggestions though - use a while-loop instead of a do-while loop and u have used $query_data = mysql_fetch_row($result); before the do statement so u have already acalled the first record and ure do-loop is starting from the next - which is the second
solution : remove $query_data = mysql_fetch_row($result);
reg
kevin

reg
kevin

olly2111

hmm even when i remove that line it still comes up with the same 🙁

kevinsequeira

post the code for the page ..

reg
kevin

olly2111

<?php
mysql_connect("HOST", "USER", "PASSWORD");
mysql_select_db("DB") or die("Failed to select Database");
$query = "SELECT * FROM sport";

   $result = mysql_query($query);
   $row_rs_members = mysql_fetch_row($result);
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
	<title>Do It 4 Eddie Charity Auction 2003</title>
	<link rel=stylesheet type="text/css" href="style.css">
</head>

<body bottommargin="0" leftmargin="0" marginheiht="0" marginwidth="0" rightmargin="0" topmargin="0" background="background.jpg" text="#FFFFFF">

<table width="100%" cellpadding="0" cellspacing="0" border="0" height="22">
	<tr valign="top">
		<td width="100%" background="top_bg1.jpg"><img src="top_bg1.jpg" width="21" height="22" border="0" alt=""></td>
		<td width="319"><img src="top_right1.jpg" width="319" height="22" border="0" alt=""></td>
	</tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0" height="184">
	<tr valign="top">
		<td width="100%" background="top_bg2.jpg"><img src="logo.jpg" width="277" height="117" border="0" alt=""></td>
		<td width="184"><img src="top_right2.jpg" width="184" height="184" border="0" alt=""></td>
	</tr>
</table>

<table width="100%" cellpadding="0" cellspacing="0" border="0" height="100%">
	<tr valign="top">
		<Td width="5">&nbsp;</td>


<td width="160"> 

<?php
include("menu.html");
?>

<BR>

	</td>


	<Td width="10">&nbsp;&nbsp;&nbsp;&nbsp;</td>


	<td width="100%">
		<table width="100%" cellpadding="0" cellspacing="0" border="0">
			<tr valign="top">
				<td width="100%">
<!-----------page content goes below-------------------------------------------------->
<center>
          <h3><font face="Arial, Helvetica, sans-serif">Sport Related Items</font></h3>
    <ol>
<?php do { ?>
<li>
<?php
   echo $row_rs_members['item'];
?>
</li>
<br>
<br>
<?php } while ($row_rs_members = mysql_fetch_assoc($result)); ?>
</ol>
     </center> 

<BR><BR>
<center>
          <font face="Arial, Helvetica, sans-serif">Site Designed By <a href="mailto:olly@ollyculverhouse.co.uk">Olly 
          Culverhouse</a> </font> 
        </center>
<!--------------------------------------------------------------------->

				</td>
			</tr>
		</table>
	</td>

	<Td width="5">&nbsp;</td>

	<td width="77" background="rightbg.jpg" height="100%"><img src="rightbg.jpg" width="77" height="22" border="0" alt=""></td>
</tr>
</table>


</body>
</html>

kevinsequeira

<?php
mysql_connect("HOST", "USER", "PASSWORD");
mysql_select_db("DB") or die("Failed to select Database");
$query = "SELECT * FROM sport";
$result = mysql_query($query);
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
    <title>Do It 4 Eddie Charity Auction 2003</title>
    <link rel=stylesheet type="text/css" href="style.css">
</head>

<body bottommargin="0" leftmargin="0" marginheiht="0" marginwidth="0" rightmargin="0" topmargin="0" background="background.jpg" text="#FFFFFF">

<table width="100%" cellpadding="0" cellspacing="0" border="0" height="22">
    <tr valign="top">
        <td width="100%" background="top_bg1.jpg"><img src="top_bg1.jpg" width="21" height="22" border="0" alt=""></td>
        <td width="319"><img src="top_right1.jpg" width="319" height="22" border="0" alt=""></td>
    </tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0" height="184">
    <tr valign="top">
        <td width="100%" background="top_bg2.jpg"><img src="logo.jpg" width="277" height="117" border="0" alt=""></td>
        <td width="184"><img src="top_right2.jpg" width="184" height="184" border="0" alt=""></td>
    </tr>
</table>

<table width="100%" cellpadding="0" cellspacing="0" border="0" height="100%">
    <tr valign="top">
        <Td width="5">&nbsp;</td>


<td width="160">

<?php
include("menu.html");
?>

<BR>

    </td>


    <Td width="10">&nbsp;&nbsp;&nbsp;&nbsp;</td>


    <td width="100%">
        <table width="100%" cellpadding="0" cellspacing="0" border="0">
            <tr valign="top">
                <td width="100%">
<!-----------page content goes below-------------------------------------------------->
<center>
          <h3><font face="Arial, Helvetica, sans-serif">Sport Related Items</font></h3>
    <ol>
<?php while ($row_rs_members = mysql_fetch_row($result)) { ?>
<li>
<?php
   echo $row_rs_members['item'];
?>
</li>
<br>
<br>
<?php }?>
</ol>
     </center>

<BR><BR>
<center>
          <font face="Arial, Helvetica, sans-serif">Site Designed By <a href="mailto<img src="images/smilies/redface.gif" border="0" alt="">lly@ollyculverhouse.co.uk">Olly
          Culverhouse</a> </font>
        </center>
<!--------------------------------------------------------------------->

                </td>
            </tr>
        </table>
    </td>

    <Td width="5">&nbsp;</td>

    <td width="77" background="rightbg.jpg" height="100%"><img src="rightbg.jpg" width="77" height="22" border="0" alt=""></td>
</tr>
</table>


</body>
</html>

reg
kevin