Page 2 - Variables giving me trouble!

Is this right?

<?php
// Keep in mind you aleady know what the variable names are.
if(isset($HTTP_POST_VARS['$id'])){
$id = $HTTP_POST_VARS['$id'];
}

$db = mysql_connect("localhost", "username", "password");
mysql_select_db("maraquita",$db);

$sql="SELECT * FROM variables";
$result=mysql_query($sql,$db);

$num = mysql_num_rows($result);
$cur = 1;


echo "<ol>";

while ($num >= $cur) {

$row = mysql_fetch_array($result);

$id = $row["id"];
$title = $row["title"];
$content = $row["content"];

echo "<li>Id = $id<br>";
echo "Title of page = $title<br>";
echo "Content = $content</li>";

$cur++;
}

echo "</ol>";

?>

I type in the URL variables.php?id=1 and it comes up with nothing, but if I add 'WHERE id='$id'" to the SELECT line ... it doesn't work .. but it shows all the rows if i remove it. Why? Any ideas?

You _CANNOT_ type that URL into the browser, as you pointed out it will _NOT_ work that way. You have to access that from a form that is using the "POST" method.

If you want to be able to access that script by typing it into the location bar of you browser, then you need to change $HTTP_POST_VARS to $HTTP_GET_VARS.

If you put the "WHERE" back into your query string and access the script via a form with method set to POST it will work as you had intended it to.

The reason why it shows the whole table is because $id never gets set since it is not a POST_VAR.

I hope that makes sense.

Matt,

What's your code for your database driven site?

EvilvE, any ideas, mine just don't seem to work. Is this as you said?

<?php
// Keep in mind you aleady know what the variable names are.
if(isset($HTTP_GET_VARS['$id'])){
$id = $HTTP_GET_VARS['$id'];
}

$db = mysql_connect("localhost", "username", "password");
mysql_select_db("maraquita",$db);

$sql="SELECT * FROM variables WHERE id='$id'";
$result=mysql_query($sql,$db);

$num = mysql_num_rows($result);
$cur = 1;


echo "<ol>";

while ($num >= $cur) {

$row = mysql_fetch_array($result);

$id = $row["id"];
$title = $row["title"];
$content = $row["content"];

echo "<li>Id = $id<br>";
echo "Title of page = $title<br>";
echo "Content = $content</li>";

$cur++;
}

echo "</ol>";

?>

Matt,

What's your code for your database driven site?

EvilvE, any ideas, mine just don't seem to work. Is this as you said?

<?php
// Keep in mind you aleady know what the variable names are.
if(isset($HTTP_GET_VARS['$id'])){
$id = $HTTP_GET_VARS['$id'];
}

$db = mysql_connect("localhost", "username", "password");
mysql_select_db("maraquita",$db);

$sql="SELECT * FROM variables WHERE id='$id'";
$result=mysql_query($sql,$db);

$num = mysql_num_rows($result);
$cur = 1;


echo "<ol>";

while ($num >= $cur) {

$row = mysql_fetch_array($result);

$id = $row["id"];
$title = $row["title"];
$content = $row["content"];

echo "<li>Id = $id<br>";
echo "Title of page = $title<br>";
echo "Content = $content</li>";

$cur++;
}

echo "</ol>";

?>

Replace:
$sql="SELECT * FROM variables WHERE id='$id'";

with:
$sql="SELECT * FROM variables WHERE id='".$id."'";

THANKS SO MUCH Mr. EvilvE!!!!

I have been trying to do that for the last god knows how many weeks!

Thanks again.