Search options (Page 2 of 5)

Hi,

After using https://frontaccounting.com/punbb/viewtopic.php?pid=21291
Mysqli ...my table sorting by asc/desc  is not working

which is because of

function db_field_name($result, $n)
{
    //return mysql_field_name($result, $n);
       $fieldinfo = mysqli_fetch_field_direct($result, $n);
        return $fieldinfo->name;
    
    
}

and if i click on sorting asc or desc then

"//-----

DATABASE ERROR : Error browsing database: SELECT id,name,datetime FROM ".TB_PREF."test_table   ORDER BY ,  LIMIT 0, 10
error code : 1064
error message : 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 'LIMIT 0, 10' at line 1
sql that failed was : SELECT id,name,datetime FROM ".TB_PREF."test_table ORDER BY LIMIT 0, 10

---//"

see ORDER BY , 

i think field name is not coming here ...

and after long time i found the prb .. i dont know its in that function or not but when i replace all mysql to mysqli as per above code my asc desc stop working .. any idea ???

pls check u r PM... will love if u can share u r code with us

Hey,

I means to say ...  Button  action ... if i am using any  tool which as it own button action then it getting collide with FA ... as your button action is by default ... hence its getting collide.. for which i have to rewrite ... and struggle here there for solution ...mostly your button , submit , delete , add ..etc get collide ... and then i have to converting it with anchor tag with ajax call etc ... hence i think you should avoid such default action.

btw i have made own custom table view , will share soon and hope it will take FA to another level in view format and in many other way.

Hey can you brief me how i can use the same with FA ... as i need Single user with multiple Access level.

secondly .. i have one custom .php page  while opening this .. i also get 500 internal server error ..but same page works fine in my local-host ... let you know about my custom .php :- its has 1 select query follow by 2 insert query and then 2 update query and then again insert query ... in-short  while insert a new record above all query get fire ...

but i don't know why its to slow while open the page ... as all above query run only after new record get insert.. hence its should get slow while insertion ...

i contact my server person he told me : u need to optimism your query ..within disk .. but i didn't get what he me to say .. can any one help me.. how i can optimism such long query so that my all page get open fast ..

I was just going @ http://www.phreebooks.com/pb-demo/index.php?module=phreedom&page=users&list=1

i and saw here that they have given same features which i have asked above .. means Full/Edit/Add/ReadOnly/None

Which is i think we should also provide same in FA  .. they have many some great features .. i think which we can TAKE IN fA

Note : please dont think its COPY or anything just think for make FA more easy features

me to cant see upload browser

any masters here

Hmm that what I also taught first, but issues is that WHILE getting report  i should get entry of user as per department ..

means if he has done entry in stock then in report i should get his entry of department as stock .. not combination of stock-product .. else it would be difficult for us to identify entry properly as per access level or department wise

entry and its report system is my requirement in FA ..which is working fine ... only problem with multiple access level  ..

Thanks

Hey carmelr ,

Thanks for reply .. yes that is the page for details ...

but if insert 2 role in role_id type..

hence do i need to define 2 access level page_security : on the particular page ?

or via session it will work.

bit confusing

Admin ,

Please help me .. if you cant then mail me or pm me the step what i need to do ... or which file need to be taken care ...i know user.php .. but how its call in session etc ..can guide me pls

Joe bro,

I am also php prog. but newbie ... hence my company has hired me to do the changes ... hence can u guide me if i need to make multiple acess level for user then what and which file i need to change ..also session etc.. can u guide me this much?