I need some advice

[baris22]

hello,

I need some advice. This will be my mysql table

order
#order_id
#order_reference_number
#customer_id
...
....


order reference number is the number i need to give to customer. it needs to be a number. when it comes to 9999 it needs to start from 1 again.

how can i do this? what is the easiest way?

Thanks

 

[Eric]

order reference number is the number i need to give to customer. it needs to be a number. when it comes to 9999 it needs to start from 1 again.

Why does it need to start over at 1 once it reaches 9999?

 

[djdeth]

You could do a SQL check when you are insertting and see what the reference number is order by order_id DESC. If it is 9999, then you insert it as one, otherwise you +1 whatever the number is.

I wouldn't name your table order. That is a mysql function to sort.

 

[baris22]

Why does it need to start over at 1 once it reaches 9999?

I do not know why. It is the way they want.

You could do a SQL check when you are insertting and see what the reference number is order by order_id DESC. If it is 9999, then you insert it as one, otherwise you +1 whatever the number is.

I wouldn't name your table order. That is a mysql function to sort.

thanks for suggestion. i will try and see if i can manage to do.

 

[qbert220]

Could order_reference_number be

($row->order_id % 10000)

 

[baris22]

Could order_reference_number be

($row->order_id % 10000)

sorry.. my php knowledge is not very good. what does this mean? as output..

($row->order_id % 10000)

 

[djdeth]

The % sign is the modulus function.
PHP: Arithmetic Operators - Manual

 

[baris22]

numbers

hello,

I need some help on numbers. I need to get the number for next

<?=$row['id'];?>

and insert into

<?=$row['reference'];?>

this is not a problem. i can do this

but

<?=$row['reference'];?>

number can not be higher than 999. so when

<?=$row['id'];?>

reaches 1000

<?=$row['reference'];?>

should go back to 1.

When

<?=$row['id'];?>

reaches 2000

<?=$row['reference'];?>

should go back to 1. and so on....


Can anybody help me please.

Thanks

 

[eagle12]

The answer was given above: you need to use % (modulus)

The problem is, that this is not good for reference# as you will eventually get duplicates. How do you know which one to look up? You should just be using the order_id, and explaining to your clients as to why it is a bad idea to do what they are asking.