# mysqli\_stmt\_bind\_result

**URL:** <https://forum.kirupa.com/t/mysqli-stmt-bind-result/271549>\
**Category:** programming\
**Created:** [September 24, 2008, 3:44pm UTC](https://forum.kirupa.com/t/mysqli-stmt-bind-result/271549 "2008-09-24T15:44:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikeDS](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@MikeDS](https://forum.kirupa.com/u/MikeDS)\
**Post date:** [September 24, 2008, 3:44pm UTC](https://forum.kirupa.com/t/mysqli-stmt-bind-result/271549/1 "2008-09-24T15:44:26Z")

</div>

Hi guys

I am currently introducing myself to the wonderful world of prepared statements within mysqli, and seem to be getting the hang of it pretty well.

One thing I just have a question about is the bind\_result method. I understand that you have to assign a variable for each field returned by your query, which makes sense, but say you did a select \* on a table with 30 fields, would you have to manually create 30 variables, or is there someway of automating this process?

I am currently in the midst of trying to write a function for this, but as you can probably guess I’m not getting very far!

Thanks guys and girls!