mysql_fetch_array does not work [duplicate]

Question

I am trying to get some rows from a table that has columns row_ID,c_ID, e_ID, each e_ID can have different c_ID's. I use the mysql_fetch_array to get all c_ID's that are associated to a certain ID.

$result=mysql_query("SELECT c_ID from User_Competence WHERE e_ID=".$id);
            $test=mysql_fetch_array($result);
            print_r ($test['c_ID']);

But instead of getting several c_IDs for each e_ID, I get only one value in the array. Am I missing something in the query?

You need to call it in a loop. There is an example on the PHP tag wiki stackoverflow.com/tags/php/info — Michael Berkowski
– Michael Berkowski, Commented Mar 11, 2013 at 13:14
You are using an obsolete database API and should use a modern replacement. We can't see where $id comes from but you may also be vulnerable to SQL injection attacks that a modern API would make it easier to defend yourself from. — Quentin
– Quentin, Commented Mar 11, 2013 at 13:14
FYI, PHP functions that start with mysql_ have been deprecated as of PHP 5.5.0. If you are in a position to do so, please consider updating your code to use the MySQLi or PDO extensions instead. — dnagirl
– dnagirl, Commented Mar 11, 2013 at 13:15

Zim84 · Accepted Answer · 2013-03-11 13:15:34Z

3

No, you do not have any errors. if e_ID is unique you will only get one result. You may want to try this if e_ID is not unique:

$result=mysql_query("SELECT c_ID from User_Competence WHERE e_ID=".$id);
while($test=mysql_fetch_array($result))
{
    print_r ($test['c_ID']);
}

answered Mar 11, 2013 at 13:15

Zim84

3,5672 gold badges39 silver badges42 bronze badges

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

3 Comments

auicsc Over a year ago

Why would I need a while if I want to print the whole array at once?

SDC Over a year ago

@auicsc - because each record is loaded as a separate array. If you switch to using PDO as your DB layer instead of the obsolete mysql_xxx() functions, then that does have the ability to load all records into a big array, using PDO::fetchall(), but as things stand, you need to use a loop; that's just the way it works.

Boann Over a year ago

@auicsc mysql_fetch_array is an array of the column values for a single row. You still have to call it separately for each row.

echo_Me · Accepted Answer · 2013-03-11 13:21:51Z

1

try this to get all ids

   $id = mysql_real_escape_string($id); // escape your variable here before u use it in the query

   $result=mysql_query("SELECT c_ID from User_Competence WHERE e_ID='".$id."' ");
        while ($test=mysql_fetch_array($result) ){
        echo $test['c_ID'].'<br />';
            }

answered Mar 11, 2013 at 13:21

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Collectives™ on Stack Overflow

mysql_fetch_array does not work [duplicate]

2 Answers 2

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Linked

Related