auto number column

[Feckie]

I am using the following to get details from my database,

Is it possible to add an auto number column at the beginning of each line

<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database name", $con);

$result = mysql_query("SELECT * FROM database name");

echo "<center>
<h1><b>Members</b></h1>
<table border='1'>
<tr>
<th>Created</th>
<th>Username</th>
<th>Name</th>
<th>Passphrase</th>
<th>Custom1</th>
</tr></center>" ;

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['Created'] . "</td>";
  echo "<td>" . $row['Username'] . "</td>";
  echo "<td>" . $row['Name'] . "</td>";
  echo "<td>" . $row['Passphrase'] . "</td>";
  echo "<td>" . $row['Custom1'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?>

[jackbenimble4]

I'm not sure what you mean. MySQL allows for auto-incrementing columns which are useful for referencing specific rows. Every single one of my MySQL tables have an auto-incrementing primary key, with my sessions table being the only exception.

If you just want to count off the results you get from the database, you could just do this:

$i = 0;
while($row = mysql_fetch_array($result))
  {
  $i++;
  echo "<tr>";
  echo "<td>". $i . "</td>";
  echo "<td>" . $row['Created'] . "</td>";
  echo "<td>" . $row['Username'] . "</td>";
  echo "<td>" . $row['Name'] . "</td>";
  echo "<td>" . $row['Passphrase'] . "</td>";
  echo "<td>" . $row['Custom1'] . "</td>";
  echo "</tr>";
  } 

[Feckie]

I'm not sure what you mean. MySQL allows for auto-incrementing columns which are useful for referencing specific rows. Every single one of my MySQL tables have an auto-incrementing primary key, with my sessions table being the only exception.

If you just want to count off the results you get from the database, you could just do this:

$i = 0;
while($row = mysql_fetch_array($result))
  {
  $i++;
  echo "<tr>";
  echo "<td>". $i . "</td>";
  echo "<td>" . $row['Created'] . "</td>";
  echo "<td>" . $row['Username'] . "</td>";
  echo "<td>" . $row['Name'] . "</td>";
  echo "<td>" . $row['Passphrase'] . "</td>";
  echo "<td>" . $row['Custom1'] . "</td>";
  echo "</tr>";
  } 

Thats exactly what I wanted, many thanks

[Nile]

Shorter solution:

$i = 0; 
while($row = mysql_fetch_array($result)) 
  { 
  echo "<tr>"; 
  echo "<td>". ++$i . "</td>"; 
  echo "<td>" . $row['Created'] . "</td>"; 
  echo "<td>" . $row['Username'] . "</td>"; 
  echo "<td>" . $row['Name'] . "</td>"; 
  echo "<td>" . $row['Passphrase'] . "</td>"; 
  echo "<td>" . $row['Custom1'] . "</td>"; 
  echo "</tr>"; 
  }