re-indexing?

[blckspder]

Hello,
I have a table in MySQL with a column called record_num that is an auto-increment for every submission.. the problem is when I delete a row by form the numbers are out of sequence for EX. Ill have 1,3,5,9 and so on, is there a way to reset that auto-increment so that all the numbers are in sequence?

[frost110]

Deleting the table and re-creating it.

Other than that why is it important as long as you can retreive the data. If it is important get rid of the auto_increment value and increment it yourself.

--FrosT

[blckspder]

ok, well Im trying to increment it myself by pulling the highest record number using the MAX() but it displaying a value of resource id #4

here is my code

$query = "SELECT MAX(record_num) FROM tradeshow_table";
$result = mysql_query($query);
echo "$result";

Let me know
Thanks

[devinemke]

you should read this

[Wynder]

You're trying to echo a result set. Do:

$row = mysql_fetch_array($result);
echo $row[0];

Instead of echo "$result";

blckspder wrote:

ok, well Im trying to increment it myself by pulling the highest record number using the MAX() but it displaying a value of resource id #4

here is my code

$query = "SELECT MAX(record_num) FROM tradeshow_table";
$result = mysql_query($query);
echo "$result";

Let me know
Thanks

[laserlight]

devinemke is right. In this case, your primary key exists so that each row in the table has a unique identifier. There is no need for you to worry about keeping the keys in running order.