storing values from mysql table into an array in php

Question

I googled around and found no valid solutions. Hope someone here will help. This is my code:

            <?php 
        include "../includes/connection.php";
        $sql_select="SELECT title FROM questions";

        if (!$result=mysql_query($sql_select))
        {
        echo "Error<br>" . mysql_error($sql_select);
        die();
        }
        if (mysql_num_rows($result)==0) {
            echo "No questions!";
        } 
        else {

            $titles = mysql_fetch_array($result);
            print_r($titles);
        }
        ?>

For the purpose of my web application I need to put question titles into a new array. I thought mysql_fetch_array() function creates an array by itself, but I guess I was wrong. Any help? Thanks

FYI don't pass the $sql_select string to mysql_error. Check the docs. — webbiedave
– webbiedave, Commented Dec 15, 2010 at 22:26

Jonah · Accepted Answer · 2010-12-16 00:01:49Z

5

You need to move $titles = mysql_fetch_array($result); into a loop like this:

$titles = array();
while ($title = mysql_fetch_array($result)) {
    $titles[] = $title;
}

Another note, remove the argument you've placed in mysql_error().

edited Dec 16, 2010 at 0:01

answered Dec 15, 2010 at 22:23

Jonah

10.1k5 gold badges49 silver badges80 bronze badges

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

3 Comments

Slavisa Perisic Over a year ago

I can't accept it sooner than I'm allowed to. I will, don't worry :)

Felix Kling Over a year ago

I would still declare $titles as $titles = array(). Makes the code easier to understand.

Jonah Over a year ago

@Felix: Good point, it also makes sure there aren't any problems with other variables of that name defined previously.

benastan · Accepted Answer · 2010-12-15 22:44:23Z

2

$result = mysql_query('select * from table');

$table = array();
while($r = mysql_fetch_array($result) {
    $row = array();
    foreach($r as $k=>$v) {
         $row[$k] = $v;
    }
    array_push($table,$row);
    unset($row);
}

$table will be a 3d array representation of your table. $table[0]['title'] will be the title of it's first row.

answered Dec 15, 2010 at 22:44

benastan

2,27815 silver badges14 bronze badges

Collectives™ on Stack Overflow

storing values from mysql table into an array in php

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related