PHP Passing Variable through URL Help

[FliKman]

I want to pass a variable through to another page which executes a sql query for the variable it recieves.

news.php


<?php

$query = 'SELECT product_id from product';

$result = mysql_query($query);

while($row = mysql_fetch_array($result))
{
$p_id = $row["product_id"];
$name_id = $row["product_name"];



echo "(<a href=""\"show_news.php?product_id=$p_id\">NEws..a>)</p>\n";
}


?>



Show_news.php


<?php

$name = $_GET['product_id'];
echo $name;

$query = 'SELECT product_name from product where product_id = $name';

$result = mysql_query($query);

while($row = mysql_fetch_array($result))
{
echo $row[product_name];
}


?>



I Keep gettin the same error. I know this refers to the $name I have used in the SQL query. But I am not sure how else to do it. It is echoing out the correct $name variable to.

Any suggestions?

[Dr Livingston]

What a difference it would make if only people would break out of PHP when they require a A HREF link passing some variables.

Point: With a decent editor that can highlight syntax; you don't see bugs when you ECHO a A HREF link.

Try (if this isn't chewed up again):

.
.
$name_id = $row["product_name"];
?>
<p>
<a href='show_news.php?product_id=<?php echo($p_id); ?>'>news</a>
</p>
<?php
.
.
.

Also there is a very apparent error within your A HREF link anyways... though for your future sanity you'll know better to break out of PHP for using HTML markup.

[FliKman]

What a difference it would make if only people would break out of PHP when they require a A HREF link passing some variables.

Point: With a decent editor that can highlight syntax; you don't see bugs when you ECHO a A HREF link.

Try (if this isn't chewed up again):

.
.
$name_id = $row["product_name"];
?>
<p>
<a href="show_news.php?product_id=<?php echo($p_id); ?>">news</a>
</p>
<?php
.
.
.

Also there is a very apparent error within your A HREF link anyways... though for your future sanity you'll know better to break out of PHP for using HTML markup.

Thanks for reply. Still stuck though!

news.php

<?php 

$query = 'SELECT product_id from product';

$result = mysql_query($query);

while($row = mysql_fetch_array($result))
{
$name_id = $row["product_id"];


?>
<a href="show_news.php?product_id=<?php echo($name_id); ?>">news</a>

<?php } ?>

show_news.php

<?php 

$name_id = $_GET['product_id']; 
echo $name_id;
$query = 'SELECT product_id, product_name from product where product_id = $name_id';
$result = mysql_query($query);

while($row = mysql_fetch_array($result))
{
echo $row[product_id];
echo $row[product_name];
}


?>

The problem seams to lie with the $name_id I have used in the query. If i set it to =1,2,3 etc then it works fine. Any suggestions?

[Dr Livingston]

Strange though not seeing the part of the script for the FORM. This is how I query the database based on variables - see how that works first:

$query = 'SELECT product_id, product_name from product where product_id = $name_id'; 

To:

$query = "SELECT product_id, product_name from product where product_id = '". $name_id ."'"; 

Hope that helps, if not then maybe you can post the script used for the FORM and it's logic ?