Getting my development hat back on, and im a bit rusty on the SQL functions for osticket - i am only getting one row returned when i use the db_query function and was hoping someone could give me a pointer.  For example, if i have the following code on one of my pages:<?php $sql='SELECT * FROM o_ticket_status';$res=db_fetch_array(db_query($sql));print_r($res); ?>it only returns the first row of an array. The status table has many rows, so how do i use the functions to spit the database results into a singular array?

This might help.https://github.com/osTicket/osTicket-1.8/blob/b1c845bf0591b1f5da593a55e462b07e5a4ee5de/setup/test/tests/mockdb.php

Write a Reply...