CiviCRM Community Forums (archive)

Joomla 1.7 - Civicrm 4.0

All I'm trying to do is provide a custom search that requires no input from the user, but just displays the result of the SQL query.

The SQL works exactly the way I want it to.  Tested this in phpMyAdmin without a hitch.  What I'd like is for the user to just select the menu item, and the system just displays the results.

However, using the procedures in the Documentation for custom searches, would result in a blank screen.    So, I tried again, this time step by step to see if I can get a search form displaying.  Works fine.   Add the SQL code, blank screen.

I add the troubleshooting code as advised in the documentation, blank screen.   Tried adding some echo statements to see where I was getting to in the search, blank screen, and nothing in any logs.

I admit my PHP skills are rudimentary at best, but I've been programming for about 20 years, starting with Fortran, and moving up to C++, and am getting very frustrated.  I don't like admitting defeat, but this has fought me to a standstill, and doing all nighters trying to get this working has cost me sleep, which at my age (60ish) is not a good thing

Any pointers, suggestions, skeleton code would be appreciated.