Need some help SQL/PHP newbie help

[ViperG]

// grab the rest of the listing's data
$sql2 = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank  FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((listingsdb_id = $current_ID) AND (listingsformelements_display_on_browse = 'Yes')  AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank";
$recordSet2 = $conn->Execute($sql2);

Basicly there are certain veriables I need out of the record set but I have no idea what they are called (It's not my database)

So I was wondering if there is a way I can write the entire thing to the screen so I know what everything is.

Or how can I display the first entry in the record set?

Unless just looking at the database is easier. But I haven't checked what tools or sql stuff is on the webhost.

[HuggieBear]

I think phpMyAdmin is probably the way to go here.

Install it your server and then connect to the database.  Assuming the user you're using has the correct privileges, you should be fine.

Regards
Huggie

[ViperG]

ok I think I got it to this:

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

$recordsetdave= $conn->Execute($sqld);

So now how do I get the value of price? I need to put it in a variable.

[ViperG]

bump