[Resolved] $_get

[MMeffert]

This is what I have so far. It does not work.

<?
$name = $_GET['ID'];

?>

<?
mysql_connect('localhost', 'root', '4794m');
mysql_select_db('info');

$result = @('SELECT solution FROM computer WHERE ID = $name');
if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}

while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['solution'] . '</p>';
}

?>

The URL to get to this page is http://www.mitchellmeffert.com/Info/pages/Solution2.php?ID=2

I get an error when I go to that page. The error is Error performing query: Unknown column '$name' in 'where clause'

Does anyone know what is wrong in my code?

[leatherback]

try:

$result = mysql_query("SELECT solution FROM computer WHERE ID = $name") or die('<p>Error performing query: ' . mysql_error() . '</p>');


while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['solution'] . '</p>';
} 

[MMeffert]

It works. Thank you SOOOOOOOOOOOOOOOOOOO much. I have been trying to get that working for hours.

[leatherback]

Hi,

-- The trick is in the double quotes. --
If this solved your problem, please mark the thread resolved (see link below)

J.