- Edited
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?