PHP - Array Glitch In Passing Variable?

This is driving me MAD!

The Variable gets passed through the URL but when I try and echo the result I gte NOTHING.

First Page.

Code: [Select]
<?php include'config.php';


$result = mysql_query("SELECT * FROM carbontrust");

while($entry = mysql_fetch_array($result))


Print "$entry[contact] - $entry[company] :: <a href='edit.php?id=$entry[id]'>Edit</a><br>";

exit;

?>


Second Page. (Where I want the Variable passed to)
Code: [Select]
<?php include'config.php';


$id = $_GET['id'];
echo "ID: $id";


}


?>

Its probably just a stupid error but iv looked through a load of tutorials and this should be correct. :/

Hi, can anybody please tell me how i can make "Arson" into a php variable

Code: [Select]

<script type="text/javascript" src="js/swfobject.js"></script>
<script type="text/javascript">

swfobject.embedSWF(
  "open-flash-chart.swf", "my_chart",
  "550", "400", "9.0.0", "expressInstall.swf",
  {"data-file":"ofc-chart.php?crime=Arson"} );
 
</script>
 

I'm an hour worth of searches into this. It's 2:30. I just want some nice person to give me the answer.

I'm trying to pass a variable using href to another page. It works great if the variable is only one word. But it only passes the first word. There are multiple posts on this topic, but I can't seem to get any of those fixes to work for me.

Here the code.
Code: [Select]
<?php
$query = "select DISTINCT city from daily where open_bid>0 order by city ASC";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$details='';
$details.='<li class="menu"><span class="name"><a href=list.php?city='.$row['city'].'>'.$row['city'].'</a>';
$details.='</li>';
echo($details);
}
?>

As you can imagine, some cities names are made up of two words. This is only passing the first word.

Thanks for your help.

The below script for some reason isn't passing along the product_id variable.
Code: [Select]
$product_id=$_GET['product'];
session_start();
$error=$_SESSION['error'];
$content.='<div class="product_information_text review_form">
<div class="review_header">Write a Review for '.$product_name.'</div>
<form action="./review_process.php?product='.$product_id.'">
<p class="form_item"><label>Name:</label> <input type="text" name="review_name" size="30" /></p>';
if(isset($error[0])){$content.='<p class="red">This field is required.</p>';}
$content.='
<p class="form_item"><label>E-Mail:</label> <input type="text" name="review_email" size="30" /></p>
<p class="form_item"><label>Location:</label> <input type="text" name="review_location" size="30" /></p>
<p class="form_item"><label>Describe Yourself:</label> <input type="text" name="review_describe" size="30" /></p>
<p class="form_item"><label>Review Title:</label> <input type="text" name="review_title" size="30" /></p>
<p class="form_item"><label>Best Use of Product:</label> <input type="text" name="review_best_use" size="30" /></p>
<p class="form_item"><label>Product Pros:</label> <input type="text" name="review_pros" size="30" /></p>
<p class="form_item"><label>Product Cons:</label> <input type="text" name="review_cons" size="30" /></p>
<p class="form_item"><label>Product Rating:</label><br />
<div class="rating_radio"><input type="radio" name="review_product_rating" value="1" /> <br />1</div>
<div class="rating_radio"><input type="radio" name="review_product_rating" value="2" /> <br />2</div>
<div class="rating_radio"><input type="radio" name="review_product_rating" value="3" checked /> <br />3</div>
<div class="rating_radio"><input type="radio" name="review_product_rating" value="4" /> <br />4</div>
<div class="rating_radio"><input type="radio" name="review_product_rating" value="5" /> <br />5</div>
<div class="worst">(Worst)</div><div class="best">(Best)</div>
</p>
<p>&nbsp;</p>
<p class="form_item"><label>Comments on Product:</label><br />
<textarea name="review_text" rows="10" cols="60"></textarea>
</p>
<p><input type="submit" value="Submit" name="Submit" /></p>
</form>
</div>
';
session_unset();
session_destroy();

That code shows the proper product=$product_id value in the form action tag.

Code: [Select]
$product_id=$_GET['product_id'];

$review_name=$_POST['review_name'];
$review_name = stripslashes($review_name);
$review_name = mysql_real_escape_string($review_name);
if($review_name==""){
$error0=1;
}
else{
$error0=0;
}

$review_title=$_POST['review_title'];
$review_title = stripslashes($review_title);
$review_title = mysql_real_escape_string($review_title);
if($review_title==""){
$error1=1;
}
else{
$error1=0;
}

$review_email=$_POST['review_email'];
$review_email = stripslashes($review_email);
$review_email = mysql_real_escape_string($review_email);
if($review_email==""){
$error2=1;
}
else{
$error2=0;
}

$review_location=$_POST['review_location'];
$review_location = stripslashes($review_location);
$review_location = mysql_real_escape_string($review_location);
if($review_location==""){
$error3=1;
}
else{
$error3=0;
}

$review_describe=$_POST['review_describe'];
$review_describe = stripslashes($review_describe);
$review_describe = mysql_real_escape_string($review_describe);
if($review_describe==""){
$error4=1;
}
else{
$error4=0;
}

$review_best_use=$_POST['review_best_use'];
$review_best_use = stripslashes($review_best_use);
$review_best_use = mysql_real_escape_string($review_best_use);
if($review_best_use==""){
$error5=1;
}
else{
$error5=0;
}

$review_pros=$_POST['review_pros'];
$review_pros = stripslashes($review_pros);
$review_pros = mysql_real_escape_string($review_pros);
if($review_pros==""){
$error6=1;
}
else{
$error6=0;
}

$review_cons=$_POST['review_cons'];
$review_cons = stripslashes($review_cons);
$review_cons = mysql_real_escape_string($review_cons);
if($review_cons==""){
$error7=1;
}
else{
$error7=0;
}

$review_product_rating=$_POST['review_product_rating'];
$review_product_rating = stripslashes($review_product_rating);
$review_product_rating = mysql_real_escape_string($review_product_rating);

$review_text=$_POST['review_text'];
$review_text = stripslashes($review_text);
$review_text = mysql_real_escape_string($review_text);
if($review_text==""){
$error8=1;
}
else{
$error8=0;
}

$review_show="n";

date_default_timezone_set('US/Eastern');
$review_date = date("F j, Y, g:i a T");

$error="".$error0."".$error1."".$error2."".$error3."".$error4."".$error5."".$error6."".$error7."".$error8."";

if($error!=="000000000"){
session_start();
$_SESSION['error']=$error;
header("Location: ./store.php?product=".$product_id."#review");
}
else{
$sql="INSERT INTO $tbl_name3 (product_id, review_show, review_title, review_email, review_name, review_location, review_date, review_describe, review_best_use, review_pros, review_cons, review_product_rating, review_text) VALUES ('$product_id', '$review_show', '$review_title', '$review_email', '$review_name', '$review_location', '$review_date', '$review_describe', '$review_best_use', '$review_pros', '$review_cons', '$review_product_rating', '$review_text')";
mysql_query($sql);
echo "Thank You for submitting your review. It should appear on the site
within 48 hours.";
}

The above redirects to store.php?product=#review with no product id. Ideas on why?