mysql_fetch_row(3)

✨ mysql_fetch_row ✨

okay bestie, so we're in the MariaDB Connector/C section of the manual — this is mysql_fetch_row(3), and she's literally the girl who hands you your data one row at a time 💅

🌸 NAME 🌸

mysql_fetch_row — fetches row of data from result set 🫶

🎀 SYNOPSIS 🎀

#include <mysql.h>

MYSQL_ROW mysql_fetch_row(MYSQL_RES * result);

💖 DESCRIPTION 💖

So basically: this function fetches one row of data from the result set and returns it as an array of char pointers (MYSQL_ROW), where each column is stored in an offset starting from 0 (zero). no cap, zero-indexed, that's just the vibe 🌈

And the way that every subsequent call to this function will return the next row within the result set? iconic. and when there are no more rows left to give you, she returns NULL. periodt 💀

🦋 PARAMETER 🦋

• result — a result set identifier returned by mysql_store_result(3) or mysql_use_result(3). that's it, that's the whole parameter, she's lowkey simple 🎀

👑 NOTES 👑

• If a column contains a NULL value, the corresponding char pointer will be set to NULL. so like, don't be shocked when you see it, it's giving intentional 🌸
• Memory associated to MYSQL_ROW will be freed when calling mysql_free_result(3). so do NOT go freeing it yourself bestie, let the function do her thing 🙈

⭐ RETURN VALUE ⭐

A MYSQL_ROW structure (array of character pointers) representing the data of the current row. and if there are no more rows available, NULL will be returned. that's the whole deal, main character energy fr fr 💜

🌈 SEE ALSO 🌈

• mysql_use_result(3)
• mysql_store_result(3)

ok so quick recap bestie: call her in a loop, she gives you rows, she says NULL when she's done, and mysql_free_result(3) handles the cleanup. obsessed 🫶✨

Version 3.4 — that's the tea, mwah 💋 go read some rows, you ate 💅🎀🦋