Skip to main content

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - giulio

1
General Discussion / Query page_id
Good morning,
I'm inserting a custom sql query to create a drop-down menu in the form of an add page, but even though the query is correct, when I start the page it doesn't work, it seems like it doesn't recognize the $page_id variable.

The query without $page_id filter (works correctly and returns me all records):

"SELECT DISTINCT dr.id_distinta, dr.id_fase AS value, caf.codice AS label FROM line_list dr JOIN cfg_anagrafica_fasi caf ON dr.id_fase = caf.id"

The query with $page_id filter doesn't work:

"SELECT DISTINCT dr.id_distinta, dr.id_fase AS value, caf.codice AS label FROM line_list dr JOIN cfg_anagrafica_fasi caf ON dr.id_fase = caf.id WHERE dr.id_distinta = $page_id"

I can't understand the error

Thanks for the help
2
Bugs / pagination system
I have a problem with the results pagination system not updating after I perform a search
3
Questions / progress field
I'm a new user of phprad and I've only been using it for a short time, sorry for my Google English. I have a table with the quantities ordered and the quantities made, on the list page I would like to insert a progress where for the quantities made field where the MAX value is the value I take from the quantities ordered field. I can't find any automatic mechanisms for my needs and I tried with MAX <?php echo intval($data['quantity_ordered']); ?> but it gives me an error.
Thank you