Hi All,
I’ve created a login script that pulls the following info from the users table;-
Username, client_id
It sucessfully works and I can echo the client_id with no issues. My problem is when I try to use this echo function elsewhere, I’ve tried several options but the only one that works is if I enter the client id as a number i.e “1” rather than echo client_id.
Heres part of my code;-
[php]include ‘…/include/database-connect.php’;
$pdo = Database::connect();
$sql = ‘SELECT * FROM fms_tbl_suppliers
WHERE client_id
= 1 ORDER BY name
ASC’;
foreach ($pdo->query($sql) as $row) {[/php]
Again any help is very appreciated… it will let me sleep at night!!!