How to query a single item

[russmc]

Please help!! I am very new to this! The value stored in products_lister_url is a hyperlink and I want it to show on the page. I am dealing with two tables and use the order_id to get the correct products_id and then need the products_id to give me the correct products_lister_url and print it to the page.

This is not workin

$sql = mysql_query("select products_id From orders_products WHERE orders_id = '$order_id'");
$result = mysql_num_rows($sql);

$sql2 = mysql_query("select products_lister_url FROM products_description WHERE products_id = '$result'");
$result2 = mysql_num_rows($sql2);

<?php echo

$result2;

?>

Thanks in advance

[dnszero]

Try something more along the lines of:

<?php
$sql = "select products_description.products_lister_url AS url
 FROM orders_products, products_description
 WHERE orders_products.orders_id = '$order_id'
 AND orders_products.orders_id = roducts_description.orders_id";
$result = mysql_query($sql);


while ($row = mysql_fetch_array($result)) {
   print $row["url"];
}

?>

---YMMV