mysql_num_rows(3)

✨ NAME ✨

mysql_num_rows — bestie, this is the one that tells you how many rows are chilling in your result set 💅

So like, real talk, this page lives in the MariaDB Connector/C manual (section 3, the library calls girlies 🎀).

🌸 SYNOPSIS 🌸

#include <mysql.h>

my_ulonglong mysql_num_rows(MYSQL_RES * );

💖 DESCRIPTION 💖

Okay so, literally what it says on the tin: it returns the number of rows in a result set. That's the whole vibe. Periodt. ✨

🦋 PARAMETERS 🦋

• MYSQL_RES — a result set identifier, and it has to come from mysql_store_result(3) or mysql_use_result(3). No random pointers, bestie, we get it from those two only 🫶

👑 NOTES 👑

The way that mysql_num_rows() behaves lowkey depends on whether you're working with buffered or unbuffered result sets, and this is the part you actually need to remember 🙈

For unbuffered result sets, mysql_num_rows() will not return the correct number of rows until all the rows in the result have been retrieved. Like, it genuinely cannot know yet, bestie — the rows haven't shown up. Don't trust the number early, that's the trap 💀

⭐ SEE ALSO ⭐

• mysql_affected_rows(3)
• mysql_use_result(3)
• mysql_store_result(3)

And that's the whole page, angel 🧚 — this was Version 3.4 of the MariaDB Connector/C manual, mwah, go count your rows responsibly 💜