Retrieval issue

Ok, I'm really confused. I made the changes you suggested and get a blank page, however, when I do a "view source", I get the following:

Notice: Undefined index: Products in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 10

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))
ORDER BY dragSortOrder DESC' at line 3

Jason: Ok, so I went through the complete checkout, and get the blank page.

Now, now how do I compare the title and extract the correct filename from the db?

I basically want to provide the client a link that he can click to download the file.

Hi,

In the script so far, we've made a list of all of the titles returned from the checkout script and have retrieved all of the records from the table "ipac_articles" that has a title in that list. So all of the matching has been done.

What fields are stored in "ipac_articles"? If you store the filename or filepath there, you will have access to it with the $ipac_articlesRecords variable.

if you use this code:
<?php showme($ipac_articlesRecords); ?>

It will display everything stored in that variable.

You should be able to use a foreach loop to go through each record and create your link.

Let me know.

Jason: Thank you very much for the assistance!

I used the following foreach to provide the links:

<?php foreach ($ipac_articlesRecords as $record): ?>
<?php foreach ($record['file_attachments'] as $upload): ?>
Download<a href="<?php echo $upload['urlPath'] ?>"> <?php echo $record['title'] ?></a><br/>
<?php endforeach ?>
<?php endforeach ?>

Thanks again for the great help!