Retrieval issue

Hi,

I would try going through the checkout process again. There are no syntax errors in the code we're currently using. The script also isn't outputting anything, so a blank page would be normal.

The error your seeing is because the $_POST['Products'] variable wasn't being set. If you just went directly to success.php without going through the checkout process, then there is no variable, so we get an error. I just went through the checkout process again and didn't get an error, so I think that's our problem.

The good news is that the script should be working.

Give it a try and let me know. :)

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!