I'm a noob and need some help!

[ViperG]

[code]
$sqld = "SELECT listingsdbelements_field_value FROM default_en_listingsdbelements WHERE listingsdb_id = $current_ID  AND listingsdbelements_field_name LIKE  'price' ";

$recordsetdave= $conn->Execute($sqld);
[/code]

So now how do I get the value of price? I need to put it in a variable.
(BTW I only need this one variable, so if there is an easier way to do this plz tell me)

[ViperG]

looks like I figured it out.

[code]
$sqld = "SELECT listingsdbelements_field_value FROM default_en_listingsdbelements WHERE listingsdb_id = $current_ID  AND listingsdbelements_field_name LIKE  'price' ";

$recordsetdave= mysql_query($sqld) or die("Could not select items");
$davec=0;
while($davidvar=mysql_fetch_array($recordsetdave))
                {
      $davec=$davidvar[0];
  };

[/code]

I was trying to do it like this though

$davec=$davidvar[price];
$davec=$davidvar['price'];

but that wouldn't work and im not sure why.

[fenway]

Because you're using fetch_array, not fetch_assoc... so you're not getting back a hash.