mysql_fetch_array only returns first column

Question

I really, really need help with the following code. I just can't figure out why it's not working.

There is a MySQL Table that I need to query and I simply need to return one row for a specific ID. However mysql_fetch_array only returns the first column from that table - and I'm dying from frustration...

$sqlCommand = "SELECT * FROM sqlInformationen WHERE ID = 2"; 

$sqlConn = mysql_connect($config['mysql_host'],$config['mysql_user'],$config['mysql_pass']);
mysql_select_db($config['db_name']) or die ("Fehler bei der Verbindungsaufnahme."); 

$result = mysql_query($sqlCommand); 
$row = mysql_fetch_array($result);  

echo $row['infTitel'];

The database contains fields "ID", "infTitel", "infZusammenfassung", etc. However only echo $row['ID'] returns a value.

Would greatly appreciate help.

Thanks.

Please, don't use mysql_* functions for new code. They are no longer maintained and the community has begun the deprecation process. See the red box? Instead you should learn about prepared statements and use either PDO or MySQLi. If you can't decide, try this article. If you care to learn, here is good PDO tutorial. — Mihai Iorga
– Mihai Iorga, Commented Aug 27, 2012 at 11:31
@raina77ow print_r($row) doesn't return anything, echo $row only returns "Array" — Matthias
– Matthias, Commented Aug 27, 2012 at 11:40
@Matthias Weird. Ok, let's use var_dump($row) instead (right before echo $row['infTitel'] line). — raina77ow
– raina77ow, Commented Aug 27, 2012 at 11:42
@raina77ow same as print_r - doesn't return anything. however when I query a different table I get a result of what's in the array. — Matthias
– Matthias, Commented Aug 27, 2012 at 11:52

DhruvPathak · Accepted Answer · 2012-08-27 11:37:56Z

3

You need to use :

$row = mysql_fetch_assoc($result);

to get associative array as result.

mysql_fetch_array($result) also returns both numeric indexes and associative indexes, but I am not sure since which version.

edited Aug 27, 2012 at 11:37

answered Aug 27, 2012 at 11:28

DhruvPathak

43.4k17 gold badges125 silver badges180 bronze badges

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

Comments

dpitkevics · Accepted Answer · 2012-08-27 11:29:12Z

2

After $result = mysql_query($sqlCommand);

$data = array();
while ($row = mysql_fetch_array($result)) {
    $data[] = $row;
}
print_r($data);

answered Aug 27, 2012 at 11:29

dpitkevics

1,2589 silver badges12 bronze badges

2 Comments

ATaylor Over a year ago

This code is a bit odd. You would only print the very last result of the query.

dpitkevics Over a year ago

Oh, sorry, forget to add [] to store $row in array. Thank You.

Fluffeh · Accepted Answer · 2012-08-27 11:58:42Z

2

Fetch Row gets one row at a time, you should pop it into a while loop like this:

while($row = mysql_fetch_array($result))
{
    echo $row['infTitel'];
    echo $row['col2'];
    echo $row['col3'];
}

If you are echoing the contents of the row that you selected with a select * and you are getting no value, it likely means that the column is empty for that row.

If you are using fetch_array it should return both column names and indexes. Try this to see if you get your data:

while($row = mysql_fetch_array($result))
{
    for($i=0; $i<count($row);, $i++)
    {
        echo $row[$i]."<br>";
    }
}

If this is showing you the data you expect (empty or null rows should return empty from memory) then it is possible a case sensitivity issue with your $row['Colname'] syntax?

edited Aug 27, 2012 at 11:58

answered Aug 27, 2012 at 11:28

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

7 Comments

Mihai Iorga Over a year ago

I simply need to return one row for a specific ID

user399666 Over a year ago

Using mysql_fetch_assoc() would be better, considering OP is looking to use an assoc array. mysql_fetch_array returns both rows and assoc.

Matthias Over a year ago

thank you very much for your quick response! this works fine for returning $row['ID'] - however I don't get any values for $row['infTitel']

Fluffeh Over a year ago

@Matthias Are you utterly certain you have the column names correct in the $row['columnName'] part of your code?

Matthias Over a year ago

@Fluffeh - yes, i've double checked using the terminal.

|

Collectives™ on Stack Overflow

mysql_fetch_array only returns first column

3 Answers 3

Comments

2 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related