BrianDickson
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by BrianDickson
-
-
I have a form on a page (the main customers page) that displays customer details. The form asks for:
\"Customer name\" and Which page to goto selected from a <select> list.
The first time the user goes to this page they enter a search for a company name, this takes then to a search results page with the results display as hyperliknks. when the user click on this link it takes them back to the main \"customer details\" page appending on the URL the \"CustomerID\" from the results page. The problem is that I want the user to use the drop down list to navigate to a page if the \"CustomerName\" field in the form is left blank, appending the \"customerID\" on the URL, so the page the user is being directed to can call up the relevant record. I have built an intermediate page that makes the decision on what to do next called \"wheretonext.php\" but I can only get this to work with a fixed dummy \"CustomerID\", and cant figure out how to grab or \"$_Get\" the \"CustomerID\". The re-direction code is given below:
<?php
$customer = $_GET[\'Customer\'];
$selform = $_GET[\'selform\'];
if ($customer && $selform) {
header(\"location:searchresults.php?Customer=$customer\");
}
else {
if ($selform)
header(\"location: $selform?CustomerID=4173\");
else header(\"location: originalform.php\");
}
?>
Thanks in advance :?:
How do I display child tables similar to Table view in Acces
in Editor Help (PhpStorm, VS Code, etc)
Posted
In Dreamweaver MX, I am building an app which originally was made up of 2 MS Access databases. In Access a child or sub form is displayed which is linked to the parents tables \"customer ID\", and this sub form is display in table view which is editable. Is there a way for the same displa and functionality to be achieved using PHP / MySQL / Web technologies?
Thanks in advance
Brian