Jump to content

Archived

This topic is now archived and is closed to further replies.

visuelz

incrementation help

Recommended Posts

my auto_increment keeps increasing from my old entry after i deleted it. It\'s like 1 then 2 then 3. Then i decide i want to delete 3. After i delete it and i remake it i get it as 4. I read somewhere that you can make it something like hit=hit+1 but im not sure how to do it on my table or page. can someone help me?

Share this post


Link to post
Share on other sites

Humm! thats the problme with auto increment

 

Now the best way would be to do a numb_row_count and get the total rows and just add a + 1 to that.

 

$numrows = mysql_num_rows($result);

Share this post


Link to post
Share on other sites

thanks a lot for the advice. hmmm say i want to display. this is match number 1 and the next data i enter i want to say this is match number 2 without affecting the number for match number 1. what can i do? i know what you just gave me could affect all the numbers.

Share this post


Link to post
Share on other sites

Chance are your going thru a loop, just create your own variable. Start the variable a 1.

$matches = 1;

Substitute the following in your loop:

echo \'This is matche Number \' . $matches;

Then add inside your loop.

$matches++;

Share this post


Link to post
Share on other sites

so would it be like

for($matches=0;$matches<=score.length();$matches++)

echo \'Match Number\' $matches;

sorry if it\'s wrong. I\'m using c++ method of doing this. heh

Share this post


Link to post
Share on other sites

pretty much only I would start matches at 1 instead of 0, makes more sense to the non-programmers who will view the output.

 

I\'m not sure what score.length is but you would want the loop to repeat as many times as you had matches, your going through a loop anyway to echo out your DB results.

 

$matchnum = 1;

while ($myRow = mysql_fetch_array)) {

echo \"Match $matchnum -- $myRow[opponent] $myRow[ourscore] $myRow[thierscore]<BR>\";

$matchnum++;

}

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.