i think im not passing the wildcards right...
this is my code thats supposed to pass variables to the code that spits stuff out...
<ahref="catagorypages/results.php?Pitemnum=%&Pdesc=%&PdimH=%&PdimL=%&PdimW=%&PdimD=%&Pprice=%&PdimH=%&Pcolor=%&Pmaterial=%&Pcategory=%&Pgenre=%&Pphotolabel=%&Pphotoloc=%&Proadcardnum=%">chairs</a></br>
this is my code thats supposed to spit stuff out....
<?
session_start();
header ("Cache control: private"); //IE fix
include ("secure/connection.php");
//These values come from conneciton.php
$connection = mysql_connect ($chost, $cusername, $cpassword)
or die ("Could not connect to server.");
$db = mysql_select_db('gvwebdb')
or die ("Could not connect to database.");
$query = "SELECT * FROM products WHERE Pitemnum = '$Pitemnum' AND Pdesc = '$Pdesc' AND PdimH = '$PdimH' AND PdimW = '$PdimW' AND PdimL = '$PdimL' AND PdimD = '$PdimD' AND Pprice = '$Pprice' AND Pcolor = '$Pcolor' AND Pmaterial = '$Pmaterial' AND Pcategory = '$Pcategory' AND Pgenre = '$Pgenre'";
$result = mysql_query($query)
or die ("Could not execute query");
While ($row = mysql_fetch_array($result))
{
extract ($row);
echo $Pitemnum.">>>".$Pdesc.">>>".$PdimH.">>>".$PdimW.">>>".$PdimL.">>>".$PdimD.">>>".$Pprice.">>>".$Pcolor.">>>".$Pmaterial.">>>".$Pcategory.">>>".$Pgenre;
echo "</br></br></br>";
}
?>
im just testing the thing to make sure that the wildcards are working... its supposed to spit out everything in my database... but its not...
can you tell me where my problem is?
thanks in advance.
ron
