Hi guys!
I’ve been looking for nearly 2 days to find an answer to this problem online and am stuck. Would greatly appreciate any assistance any one might provide :)))
ENV: Linux(ubuntu), MySQL, PHP
I have the attached script that queries the db ok ( please see attached results: example.html ). I’m trying to access the array that is created by “mysql_fetch_array($Result))” at line: 171 (please see attached: view.php).
The query returns all rows from the PRODUCT table in my mysql DB… all goood. The first field is called BC_ID. I want to access this array in LINE:261- 279 so that i can set the BC_ID as a VARIABLE and then pass it to the URL construct in LINE:268. This will then let me use another .php to SQL INSERT Query with this BC_ID instead of the “&row_id” which is based on a counter in a foreach LOOP.
I know its painful reading other people’s code, so have tried to give exact LINE number to narrow the read time.
Specifically, I want to have LINE: 268 (view.php) to look something like this:
PHP_files.zip (4.83 KB)