1 column that repets and one that doesnot

symoore22

could somebody tell me how you stop a specific table from repeating. I have a table thats showing my database info but there are cells on the right which i dont want to repat but are.

Im sure its quite simple but im not sure ow to do it

thanks

simon
http://www.bestblanks.co.uk

robert_w_ark

Can you show us the part of the script where it is repeating? It tends to help when you do 🙂

symoore22

hi Sorry - ive only been learning all this for about 2 days so this is what i have done so far.

YOu can this this at this address...
http://www.bluetipdvd.co.uk/index.php

The cell that holds 'google links go here' should not be repeating.

thanks

simon
http://www.bestblanks.co.uk

<?
$i=0;
while ($i < $num) {

$ID=mysql_result($result,$i,"ID");
$name=mysql_result($result,$i,"name");
$price=mysql_result($result,$i,"price");
$photo=mysql_result($result,$i,"photo");
$addtocart=mysql_result($result,$i,"addtocart");
?>
<tr>
<td colspan="2"><font color="#333333" size="2">PROD CODE</font> <? echo "$ID" ?></td>
<td width="10%" rowspan="6"><div align="center">GOOGLE LINKS GO HERE</div></td>
</tr>
<tr>
<td colspan="2"><font color="#000000" size="2"><strong>DVD TITLE</strong></font><br>
<? echo "$name" ?> </td>
</tr>
<tr>
<td colspan="2">£<? echo "$price" ?> </td>
</tr>
<tr>
<td> <? echo "$photo" ?> </td>
<td><? echo "$addtocart" ?></td>
</tr>
<tr>
<td colspan="2">  </td>
</tr>
<tr>
<td height="25" colspan="2"><hr width="80%"></td>
</tr>
<?
$i++;
}
?>
</table>

leatherback

Something like:

$i=0;
while ($i < $num) {

$ID=mysql_result($result,$i,"ID");
$name=mysql_result($result,$i,"name");
$price=mysql_result($result,$i,"price");
$photo=mysql_result($result,$i,"photo");
$addtocart=mysql_result($result,$i,"addtocart");

?>
  <tr> 

<? 
if($i == 0)
  {
?>

<td><font color="#333333" size="2">PROD CODE</font> <? echo "$ID" ?></td>
<td width="10%" rowspan="<?echo $i;?>"><div align="center">GOOGLE LINKS GO HERE</div></td>

<? 
}
else
  {
?>

<td colspan="2"><font color="#333333" size="2">PROD CODE</font> <? echo "$ID" ?></td>
<?

  }

?>

  </tr>
  <tr> 
    <td colspan="2"><font color="#000000" size="2"><strong>DVD TITLE</strong></font><br> 
      <? echo "$name" ?> </td>
  </tr>
  <tr> 
    <td colspan="2">£<? echo "$price" ?> </td>
  </tr>
  <tr> 
    <td> <? echo "$photo" ?> </td>
    <td><? echo "$addtocart" ?></td>
  </tr>
  <tr> 
    <td colspan="2">&nbsp; </td>
  </tr>
  <tr> 
    <td height="25" colspan="2"><hr width="80%"></td>
  </tr>
  <?
$i++;
}
?>
</table>

leatherback

Hi,

You have just started PhP, I noticed just now.

What you might want to structure output like this:

you have your query (Not posted in your post:

$query = "your query";

$result = mysql_query($query) or die('Could not run the query:'. Mysql_errror());

$numrows = mysql_num_rows($result);

while($rows = mysql_fetch_array($result))
  {
  // produce your output here:
  echo $row[price];
  echo $row[photo];
  }