Mysql Count 1 by 1

Question

$sql=sprintf("SELECT * FROM stitch);

This my array.

       [stitch] => Array
                    (
                        [0] => Array
                            (
                                [id] => 7, 
                                 [name] => Sew buttonhole to front fly
                            )
                        [1] => Array
                            (
                                [id] => 8,
                                [name] => Sleeve hem    
                            )
                     )                
                )

I need this result

               [stitch] => Array
                    (
                        [0] => Array
                            (
                                [id] => 7,
                                [name] => Sew buttonhole to front fly  
                                [number_stitch] => 1
                     )
                        [1] => Array
                            (
                                [id] => 8,
                                [name] => Sleeve hem 
                                [number_stitch] => 2                             
                            )
                     )                
                )

how i do these [number_stitch] ?

Apparently `number_stitch` is not part of the `stitch` table. — woz, Nov 08 '12 at 16:12
It does not, number_stitch is just a sequence of stitch count — Rogério Bispo Vila Nova, Nov 08 '12 at 16:13
Why would you `sprintf` on a string with nothing to interpolate? Cargo-cult programming? — tadman, Nov 08 '12 at 16:16
@RogérioBispoVilaNova If you're using PHP, you shouldn't need that. — woz, Nov 08 '12 at 16:17
So I put the select for you to see the issue, but what matters is the result of the option array below it worked thanks!! — Rogério Bispo Vila Nova, Nov 08 '12 at 16:25

score 1 · Accepted Answer · answered Nov 08 '12 at 16:15

1

Try

select s.*, @rowcount:=@rowcount+1 ‘number_stitch’ from stitch s, (SELECT @rowcount:=0) r order by id;

answered Nov 08 '12 at 16:15

Kami

19,134
4
51
63

FYI, this answer corresponds with the highest voted answer here: http://stackoverflow.com/questions/304461/generate-an-integer-sequence-in-mysql – woz Nov 08 '12 at 16:18
Oh sorry, did not know how to find this type of question – Rogério Bispo Vila Nova Nov 08 '12 at 16:20

Mysql Count 1 by 1

1 Answers1