Is this right?

[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.

[drifter]

well for one you need a % when you use like and list search are usually slow

also depending on what you are doing, you can visit pear.php.net and get a DB class - that will help you a lot