[RESOLVED] How to bind variables using mysqli for unknown number of field

[goldd1gger]

My prepare statement: "select * from tblname";
How do I bind the number of unknown field being retrieved.
It should be 2 or 10.

Help!

I know how to bind if I know that it is going to return 2 fields (see code below).
How do I bind it if I don't know how many fields are being retrieved so that I can bind the result and then fetch all the values???

if ($sql = $mysqli->prepare("SELECT * FROM lindatest")) {
$sql->execute();

/* bind variables to prepared statement */
$sql->bind_result($col1, $col2);

/* fetch values */
while ($sql->fetch()) {
    printf($col1." and ".$col2."<br />");
}

/* close statement */
$sql->close();

}

[NogDog]

I'd probably execute() the prepared statement, then do a fetch_assoc() on the mysqli_result object returned by it.

if ($sql = $mysqli->prepare("SELECT * FROM lindatest")) {
   if(($result = $sql->execute()) != false) {
      while($row = $result->fetch_assoc()) {
         printf("%s<br />\n", implode(' and ', $row);
      }
   }
}

[goldd1gger]

NogDog - I tried your method and it didn't work. Get the following error:

PHP Fatal error: Call to a member function fetch_assoc() on a non-object

However, I did find another way to bind variables. See code below for those who want to do the same thing.

This work:

if ($sql = $mysqli->prepare("SELECT * FROM lindatest")) {
$sql->execute();

$sql->store_result();

$meta = $sql->result_metadata();

$bindVarsArray = array();

while ($column = $meta->fetch_field()) {
   $bindVarsArray[] = &$results[$column->name];
}       
call_user_func_array(array($sql, 'bind_result'), $bindVarsArray);

$sql->fetch();

while ($sql->fetch()) 
{		

	echo "here= ".$results['value']." <br>";

}

$sql->close();

}