I have the following bit of code:
$query = "SELECT * FROM jos_vm_product_details WHERE global_variant_id = '$global_variant_id'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
$row['name'];
}
Is it possible to select the $row['name'] only where something is matched:
Select $row['name'] WHERE id = $id
Any help would be appreciated