Query plus Rename

[David_P]

I need to perform a select query for an edit link. But I need to change some of the names in the table to something else. But I don't know how to construct it. The query below returns nothing.

<?php
include('dbconnect'); // contains connect code

$query="SELECT page FROM $pages ORDER BY page";
$result=mysql_query($query) or die('Error, query failed');

while($row = mysql_fetch_assoc($result)){

$id = $row['id'];
$About = $row['About'];
$company_name = $row['company_name'];
$cart = $row['cart'];
$Contact = $row['Contact'];
$Home = $row['Home'];
$intro = $row['intro'];

// need  to change how some names above will display

$company_name = 'Company Name';
$cart = 'View Shopping Cart Code';
$intro = 'Slogan';

echo "<a href='edit_pages.php?file=$id')"><!--$id-->$page</A><br><br>";
} 
?>

[pete_bisby]

You can use a switch statement if you want to test a specific field, for example a specific company name:

switch ($company_name) {
  case "My Company Name" :
    $company_name = "Company Name";
    $cart = "View Shopping Cart Code";
    $intro = "Slogan";
    break;
  case "Someone else" :
    $company_name = "Something";
    $cart = "View Something";
    $intro = "Something";
    break;
  default :
    break;
}