Add custom field to Create Ticket page

mitz

Hi, I'm trying to add a bit of text next to the user information like the image below: blank I'm editing the file ticket-open.inc and I want to display the result of the following sql query: $query = 'select value from ost_form_entry_values where field_id=57 and entry_id=(select id from ost_form_entry where object_type=\'O\' and object_id = (select id from ost_organization where name like \'ADDE\'))'; $hash = md5($query); $_SESSION = $query; $resmanu = db_query($query);This query should return 1 or 0, then I have the following condition: if ($resmanu == 1){ $butyes="Yes"; } if ($resmanu == 0){ $butyes="No"; } if ($resmanu == " "){ $butyes="No Value"; }TLDR: If the query returns 1 I want to display Yes, if not display No. The result always go for Yes, no matter what <something> is, even if the query is empty.What does exactly db_query returns and how can I handle it? Since I don't have much experience in PHP I thought of asking you guys for help.Thanks

ntozier

db_query queries the database. it essentially works just like mysql_query().

mitz

So, in this case it will return me just the 0, as seen on a HeidiSQL query? blank Because my if conditions are not corresponding to this boolean.

ntozier

No. Select statements return the column name and the values associated with the query.It's up to you to programmatically select the part of the reply that you want to use. A very basic PHP > MySQL query could break down to:$query = "SELECT foo FROM table WHERE bar='1'"; // your query$result=mysql_query($query); // run the query $foo = mysql_result($result,0,"foo"); // set the variable to $foo so you can use itUsing the built in osTicket functions should be mostly the same. But I've just started playing with them.

mitz

The problem I had was how to isolate the result. Your answer did the trick. Thank you for your help :)

ntozier

Very welcome. :)