I was wondering if someone could explain to me or show me why this does not work for me…I’m trying to link ‘custid’ with $_GET…I can see the ‘prodID’ but, not the ‘custid’…please assist
[php]<?php
$custid = $_GET[‘custid’];
include("…/cgi/rit_cxn.php");
$cxn = mysqli_connect($hostname,$username,$password,$dbname) OR DIE ('Unable to connect to database! Please try again later.');
$pcat = $_GET['cat'];
$query = “SELECT * FROM $usertable WHERE category = ‘$pcat’”;
$result = mysqli_query($cxn,$query);
$num_rows = mysqli_num_rows($result);
echo "<tr>\n";
while($row = mysqli_fetch_assoc($result))
{
$ptble = 'product' . $row['prodID'];
$ptrows = mysqli_query($cxn,"SELECT * FROM $ptble WHERE pbal='1'");
if (mysqli_num_rows($ptrows)==0){
$blnce = 0;
}
else {
$blnce = mysqli_num_rows($ptrows) * .01;
}
$bidlink = 'prodbid.php?pid=' . $row['prodID'] . '&custid=' . $custid;[/php]