mysqli retrieve unspecified amount of fields

[imin]

hi

i faced this problem since yesterday and I still haven't got the right solution yet

to cut it short, here's my preparedstatement query

$query = "select * from ingredients where id=? and language=?";
$stmt = $dbi->prepare($query);
$stmt->bind_param('ss', $ID,$language); 
$stmt->execute();

the table has the field name that starts with ingredients1, ingredients2,quantity1,quantity2 and so on until ingredients50 and quantity50.

my problem is how do I read all those returned fields? I need the returned fields to be set to its respective variable name, for example the field ingredients1 assigned to variable $ingredients1 and so on?

i tried the solution at http://forums.devshed.com/php-develo...ay-568982.html but still can't get it working as I want it

any help is greatly appreciated! thanks!

[imin]

no one understand my prob?

[PeejAvery]

Learn patience. It hasn't even been 12 hours. Not everyone who helps out here checks in every day.

Concerning your problem, if you convert your result to an array, you can use PHP's extract() function to convert them to respective variable names.

EDIT: Also, if you are using a SELECT command, you shouldn't be using a prepared statement, but instead perform a simple query.

[imin]

Learn patience. It hasn't even been 12 hours. Not everyone who helps out here checks in every day.

Concerning your problem, if you convert your result to an array, you can use PHP's extract() function to convert them to respective variable names.

EDIT: Also, if you are using a SELECT command, you shouldn't be using a prepared statement, but instead perform a simple query.

ouh..thanks... simple select should be OK it seems..