[SOLVED] Counter

[SamW]

Hi,

I'm trying to get submit.php (after http://www.ballpointstudio.com/form2.php) to have a counter on each post, that increments each row. How can I do this within the code (or maybe in MySQL )?

 

Thanks =D

[SamW]

Oops, I forgot to add the actual code...silly me.

 

<?php

  mysql_connect("localhost", "Censored", "Censored") or die(mysql_error());

mysql_select_db("runetyco_cms") or die(mysql_error());

 

 

$content = $_POST['content'];

 

  mysql_query("INSERT INTO cms

(content) VALUES('$content' ) ")

or die(mysql_error());

 

$result = mysql_query("SELECT * FROM cms")

or die(mysql_error()); 

 

 

 

while ($row = mysql_fetch_array( $result ))

{

  echo "<br /><br />Post: ".$row['content'];

}

 

?>

[Adam]

You can do this very easily by just incrementing a variable on each loop:

 

$i = 1;
while ($row = mysql_fetch_array( $result ))
{
   echo "<br /><br />Post " . $i . ": " . $row['content'];
   $i++;
}

[SamW]

Thanks mate, you're a legend.