EZ Results

I wanted to be able to use the standard MySQL query syntax like
"select fname as 'First Name', lname as 'Last Name',..."
so that the COL headings could be labeled "pretty"

I hacked JV's great ez_results tool as well as I am able -- if you try it maybe you can help by suggesting improvements

An example is HERE (at the bott of page)
(( the source code is avail there as well))

Cheers,

I have been hacking around with this for hours.

I have setup a viewResults script with a query that looks like this

$ezr->query_mysql('SELECT * from PATCH_REQUESTS');

Then I just simply display it.

When I run I get 2 errors:
Notice: Undefined variable: db in C:\cgi-bin\EVT_MANAGEMENT\includes\ez_results.php on line 614

Fatal error: Call to a member function get_var() on a non-object in C:\cgi-bin\EVT_MANAGEMENT\includes\ez_results.php on line 614

FYI....Line 614 refers to the function get_num_results()

By commenting out line 185 of the ez_results script....
// get total number of results

Inspired by the new release of ez_sql I also tried ez_results and the Quick Example:
include_once “ez_sql.php”;
include_once “ez_results.php”;
$ezr->query_mysql(“SELECT email, login FROM users”);
$ezr->display();
with a fatal error (blank screen) as result

Mocking around I found that when changing the qoutes to single in:
$ezr->query_mysql('SELECT email, login FROM users');
it worked out fine.

I'm no real programer so I have to ask why?
(and maybe suggest an update in manual for cheaters like me)

/Björn M

been playing with ez_results.Looks good, pretty easy. Question - how do I add a column to the end of the table with a link that references a unique ID?

I want to put a link to an edit page so someone can click it and edit the details of a row.

I've got the header of the column coming up by adding a column to the end of results_heading. But when I add a column to the end of results_row
like edit it comes up with edit)'>edit with the source saying edit)'>edit which seems to repeat itself.