Unable to pass queries in address bar ;(

zander213

I am working with the below script, and I am trying to get different items to come up (by sku) when I pass variables through the address bar like this:

domain.com/page.php?sku=12345

but I have been unable to get this to work. Can you see anything here that I am doing wrong, or need to do differently?

Here is the script:

<?php require_once('Connections/shoes_connection.php'); ?>
<?php
mysql_select_db($database_shoes_connection, $shoes_connection);
$query_recordset = "SELECT * FROM shoes ORDER BY sku ASC";
$recordset = mysql_query($query_recordset, $shoes_connection) or die(mysql_error());
$row_recordset = mysql_fetch_assoc($recordset);
$totalRows_recordset = mysql_num_rows($recordset);
$sku = $_GET['sku'];
?>
<html>
<head>
<title><?php echo $row_recordset['sku']; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

planetsim

try this maybe

<?php require_once('Connections/shoes_connection.php'); ?>
<?php
mysql_select_db($database_shoes_connection, $shoes_connection);
$query_recordset = "SELECT * FROM shoes WHERE sku = '".(int)$_GET['sku']."'";
$recordset = mysql_query($query_recordset, $shoes_connection) or die(mysql_error());
$row_recordset = mysql_fetch_assoc($recordset);
$totalRows_recordset = mysql_num_rows($recordset); //is this being used at all?
?>
<html>
<head>
<title><?php echo $row_recordset['sku']; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<p><?php echo $row_recordset['name']; ?> <br>
<?php echo $row_recordset['sku']; ?></p>
</body>
</html>
<?php
mysql_free_result($recordset);
?>

zander213

Thanks! That's exactly what I have been trying to do! I really appreciate your help!