Retrieve data from database in an array

Question

Is there any php function that will let me retrieve data from mysql in numeric array. If there's no function for that, how can I do it?

I am trying to retrieve a list of email from a database, but I need to retrieve those emails in a numeric array. I tried this but it's not working.

    $a=mysql_connect("X","X","X");
    mysql_select_db("X",$a);
    function num(){
     $email=mysql_query("select email from X");
     while($re=mysql_fetch_array($email)){
      print $re[0];
      print "<br>";
     }
    }
    num();

I tried this to put these emails in a numeric array but it won't work $fr=explode("<br>",num()); — user181275
– user181275, Commented May 12, 2012 at 15:58

Jeroen · Accepted Answer · 2012-05-12 15:57:36Z

2

Replace this line:

while($re=mysql_fetch_array($email)){

With this one:

while($re=mysql_fetch_array($email, MYSQL_NUM)){

answered May 12, 2012 at 15:57

Jeroen

13.3k4 gold badges45 silver badges63 bronze badges

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

2 Comments

user181275 Over a year ago

When I try to print a specific email I get this error: undefined offset: 8 (If I try "print $re[8]";)

Jeroen Over a year ago

Of course, that's because $re is one row, so you are printing the 8th column of that row

maiorano84 · Accepted Answer · 2012-05-13 02:35:44Z

1

mysql_fetch_array returns both numerical and associative indexes. Jeroen is correct, in that you can set a second parameter to define what kind of indexing you would like, but consider using this for numerical indexing:

while($re=mysql_fetch_row($email)){

And this for associative indexing:

while($re=mysql_fetch_assoc($email)){

As for your function, you can do something like this:

$a=mysql_connect("X","X","X");
mysql_select_db("X",$a);
$emails = num("select email from X");
function num($query){
    $email=mysql_query($query);
    $results = array();
    while($re=mysql_fetch_assoc($email)){
        $results[] = $re;
    }
    return $results;
}
print $emails[8]['email'];

You should also stop using the mysql_* functions, and consider switching to something like PDO.

edited May 13, 2012 at 2:35

answered May 12, 2012 at 16:01

maiorano84

12.1k3 gold badges38 silver badges52 bronze badges

Comments

Emil Vikström · Accepted Answer · 2012-05-12 16:00:06Z

0

function num(){
 $email=mysql_query("select email from X");
 $result = array();
 while($re=mysql_fetch_array($email)){
  $result[] = $re[0];
 }
 return $result;
}

answered May 12, 2012 at 16:00

Emil Vikström

92.3k17 gold badges144 silver badges178 bronze badges

Comments

Roman · Accepted Answer · 2012-05-12 16:32:37Z

0

For an array with numerical keys:

mysql_fetch_row()

answered May 12, 2012 at 16:32

Roman

3,8734 gold badges32 silver badges43 bronze badges

Collectives™ on Stack Overflow

Retrieve data from database in an array

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related