Hi dansgalaxy, thanks for the info, but just to clarify I am using $_GET['custid'] within my scripts, maybe you could take a look at the site so you can see the problem and what I am going on about if you would not mind terribly the address is
http://www.higuide.co.za/
Use the dropdowns to select a location then the next to select a Category, now submit that to the next page, thats fine cause it uses $_POST['loc'id] and $_POST['cat_id'] to take the variables to the results page.
The results page uses a select statement to say
Code:
SELECT DISTINCT tci.custid, tci.custname, tci.locid, tci.catid
FROM tblcustomerinformation tci, tbllocations loc, tblcategory cat
WHERE (tci.locid = loc.locid AND
tci.locid = $_POST['loc_id']) AND
(tci.catid = cat.catid AND
tci.catid = $_POST['cat_id'])
ORDER BY tci.custname ASC
Now this gives me a list of all the customers that match that criteria so i have made a loop to get through all the results, the next problem I have is that each one of the customer names in the loop needs to be an ahref link to that customers custid, this is where it went so badly cause I was forced to use $_GET instead of what I prefer $_POST and this is why. My link code looks something like this.
PHP Code:
<?php do { ?>
<p>
<a href="/higuide_adverts.php?CustID=<?php echo $row_rs_loc_id_cat_id['CustID']; ?>&alnk=zero&loc=<?php echo $_POST['loc_id']; ?>">
<strong><?php echo $row_rs_loc_id_cat_id['CompanyName']; ?></strong></a></p>
<?php } while ($row_rs_loc_id_cat_id = mysql_fetch_assoc($rs_loc_id_cat_id)); ?>
When this link is clicked on it goes to the /higuide_adverts.php page and this page uses $_GET['CustID'] and $_GET['alnk'] and $_GET[loc'] to get the correct data from the mysql database, something like this.
Code:
SELECT tal.CustID, tal.CompanyName, tal.Email
FROM tbladvertiserlocation tal
WHERE tal.CustID = $_GET['CustID'] AND tal.loc = $_GET['loc']
So tell me if im right in saying that if there is a way that I could make the links use $_POST instead of $_GET most of this problem should be fixed I hope, could you tell me a way to do that.
and should I deinstall xampp and install apache and php and mysql on their own, and then configure them all. cause in the xampp docs I read that it was not made for a production environment but I thought that was only if you did not perform their initial security fixes, but that must have been a misunderstanding.
Thanks for all the help m8
