MySQL and num rows.

[ShaDoOoW]

Hey, I need to know how many rows I selected from last SELECT statement. Atm I added new function into ODBC dll which calls mysql_num_rows, but if there is any method to do it via MySQL command like SELECT, I would prefer it... Does anyone know?
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect

[ShaDoOoW]

got it,

[Baaleos]

U sure??
I thought that query just returns the amount of how many different valued rows there are for that specific column.

Eg if you had two rows with same value in baseitem 'in' each it would only count it once, because it only exists distinctly once.

I've used the distinct method b4 when I made a web interface allowing me to create items via choosing the item properties. I used select distinct item properties, to get them to appear once per unique value.

[ShaDoOoW]

Yes I am sure. The distinc value will filter the same values for baseitem, I mean I have there 151 values, but baseitem is mostly the same, thats why I used distict. With that it returns 21 rows aka "how many different baseitems are there". The COUNT(DISTINCT baseitem) returns 21 and thats exactly what I need.

btw for random one I used this statement

[axs]

For random selection you can try to use:

[Zebranky]

ShaDoOoW's approach might be better, especially on larger sets, since RAND() will run once for every row in the table.
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?

[ShaDoOoW]

[axs]

[ShaDoOoW]

Guess I will stick in the count + limit then, but still very usefull info. Thanks.
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect