• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

apro2000 on 03/14/09

Tagged

mysql php array into query values assign

Versions (?)

03/14/09 07:12pm

Who likes this?

1 person have marked this snippet as a favorite

lajevardi

 / Published in: PHP

 

function query_into_array($query){
settype($retval,"array");
$result= mysql_query($query);
$y=mysql_num_rows($result);
$k=mysql_num_fields($result);
  for($i=0;$i<$y;$i++){
    for($j=0;$j<$k;$j++){
    	$retval[$i][mysql_field_name($result,$j)] = mysql_result($result,$i, mysql_field_name($result,$j));
    }
  }
return $retval;
}

Report this snippet   Tweet

Comments

Subscribe to comments

Posted By: NeoBlack on March 14, 2009

function queryintoarray($query) { $res = mysqlquery($query); $return = array(); while ($row = mysqlfetch_assoc($res) { $return[] = $row; } return $return; }