Hi All, this is my first post on here so please go easy!
I am creating a portal type application,
I have a page that has a table on with a list of customers in, but I want to link the customer name to a new page that gives me a list of that customers products, I have it working where I am setting the customer ID in the SQL WHERE clause but I want to do this dynamically so when a user clicks on customer 1 its customer 1's products that are loaded etc.
Here is the first table:
SQL:
$customerList = "SELECT T0.CardCode, T0.CardName FROM OCRD T0 WHERE T0.SlpCode = 947";
$myCustomers = sqlsrv_query( $sapconn, $customerList);
HTML/PHP:
<table>
<thead>
<tr>
<th>SLP Code</th>
<th>SLP Name</th>
</tr>
</thead>
<tbody>
<?php while($customer = sqlsrv_fetch_array($myCustomers, SQLSRV_FETCH_ASSOC)) : ?>
<tr>
<td>
<a href="specialprice.php">
<?php echo $customer['CardName'];?>
</a>
</td>
<td><?php echo $customer['CardCode'];?></td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
Then it Links to this page (specialprice.php) to show the relevant products:
SQL:
$specialPricing = "SELECT T0.ItemCode, T0.ItemName, CAST(T1.Price AS DECIMAL(9,2)) AS Price FROM oitm T0 JOIN ospp T1 ON T0.ItemCode = T1.ItemCode WHERE T1.CardCode = 'CM000001-M'";
$oitmTable = sqlsrv_query( $sapconn, $specialPricing);
PHP:
<table>
<thead>
<tr>
<th>SLP Code</th>
<th>SLP Name</th>
<th>Price</th>
</tr>
</thead>
<tbody>
<?php while($users1 = sqlsrv_fetch_array($oitmTable, SQLSRV_FETCH_ASSOC)) : ?>
<tr>
<td><?php echo $users1['ItemCode'];?></td>
<td><?php echo $users1['ItemName'];?></td>
<td>£<?php echo $users1['Price'];?></td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
But i want it where the id of "CM000001-M" is dynamic to which customer has been clicked.
Any advice on how to achieve this?
Thanks in advance.
