MySql页面即时

Question

Problem solved

The answer was

$query = "SELECT manager FROM tablename WHERE manager='$manager'";

Subtle difference, but removing the dots before and after $manager was the answer.

Credit to PHPFreaks.com

I had this;

<?php include 'dbdetails.php';  

$id = mysql_real_escape_string($_GET['id']);  

$query = 'SELECT `column` FROM `tablename` WHERE `id` = '.$id.' ';  

$result = mysql_query($query);  

$row = mysql_fetch_array($result);  

echo $row['column'];  

?>

(taken from here)

This works fine if I am solely working with an ID, however I have repeated values in the column I need to work with so ID will not work for what I am trying to achieve.

Essentially I am trying to create pages on the fly using the Manager column as the query as opposed to the ID.

What would be the correct way to achieve this? I presume DISTINCT comes into play?

I am aiming for;

<a href="sitename.com/?manager=Micky Adams">Micky Adams</a>

as my structure, where it fetches all instances of Micky Adams or whichever manager name is set up as the anchor.

Answer 1

If you changed it to:

$manager = $_GET['manager'];  
$query = 'SELECT `column` FROM `tablename` WHERE `manager` = '.$manager.' ';

Wouldn't that achieve what you want? If you had more than one instance of the manager DISTINCT only partly helps depending how your data is actually stored.