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

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!