mysql_fetch_field

[GreenFanta]

$var = mysql_query('SELECT id_image FROM ps_image WHERE id_product = 12');
$var2 = mysql_fetch_field($var);

 

I am trying to send in a query that brings out a row where the id_product is equal to 12 and from there I want to retreive the value of id_image in that specific row, which I have done on the mysql_query, but I have no idea how to set the value to a variable, I was told I could use mysql_fetch_field for it, but it doesn't seem to be working as I keep getting the error:

Catchable fatal error: Object of class stdClass could not be converted to string ...

which I assume means it is not set to an integer as it should be, so I must be doing something wrong, can anybody help?

 

Regards

Matthew

[trq]

if ($result = mysql_query('SELECT id_image FROM ps_image WHERE id_product = 12')) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_assoc($result);
    echo $row['id_image'];
  }
}

[GreenFanta]

Thank you kindly Thorpe