Fetch all rows based on the query into an array and return single value

Question

Query database for data

//----------------------------------------------------------------------
$result = mysql_query("SELECT * FROM $tableName");          query
$array = mysql_fetch_row($result);

fetch result In Array

$arr = array();
while ($row = mysql_fetch_assoc($result)) {
$arr2 = array();
foreach ($row as $val) $arr2[] = $val;
$arr[] = $arr2;
}

Result Will Be

Array
(
[0] => Array
    (
        [0] => status_site
        [1] => 0
    )

[1] => Array
    (
        [0] => title_site
        [1] =>  Script
    )

[2] => Array
    (
        [0] => keys_site
        [1] => 
    )

  )

I need to make function that return element 0 to 1

 ex: function getsetting (title_site){
 return value script}

Try to replace $arr[] = $arr2; with $arr[$arr2[0]] = $arr2[1];. Is this the result you're looking for? — Simon
– Simon, Commented Feb 20, 2015 at 7:51
Tanks Amazing yes solved & changed then i'm use extract($arr) and get variable with easy $title_site Thanks — Yasser Eldeghidy
– Yasser Eldeghidy, Commented Feb 20, 2015 at 7:59

Simon · Accepted Answer · 2015-02-20 08:02:01Z

1

Replace the $arr[] = $arr2; with $arr[$arr2[0]] = $arr2[1];. That might solve your problem.

answered Feb 20, 2015 at 8:02

Simon

2301 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fetch all rows based on the query into an array and return single value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related