[snip] 1. I'm trying not to display the fields that are empty with: if (!empty($row9->prijs4pk)){ But it's still display the line and there is no value in PRIJS4PK field. [/snip]
You are testing to see if $row9->prijs4pk is NOT empty. If it is not empty you print it. You have not specified an action for IS empty (else)...perhaps this would help. [snip] 2. How can i reduce the amount of Queries?? [/snip] It appears that you have multiple duplicate queries. It appears that you are using the $limit and $page to paginate the results, there is a good tutorial which shows you how to do this on DevShed. The last page (displaying all of the code) is http://www.devshed.com/Server_Side/PHP/Paginating/page6.html . I did not look over each line of your code, but this is the general impression I received. If I may be frank, Frank, you probably didn't receive responses as quickly as you had wished due to the enormous amount of code you included with your request. It is my suggestion that you read http://catb.org/~esr/faqs/smart-questions.html as it contains valuable information (such as only including the code blocks in question) that will help to get your questions answered quickly. HTH! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php