Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Display data from the table

Hello, please help.
How to file dashboard.php view the result of the query:
SELECT * FROM bis_ticket
I tried this:

$ Query = "SELECT * FROM bis_ticket";
$ Result = mysql_query ($ query);

while ($ row = mysql_fetch_row ($ result))
 {
echo $ row [0];
echo $ row [1];
echo $ row [2];
echo $ row [3];
echo $ row [4];
 }

Unfortunately, there is no dispay

moderator note: I have removed the html formatting from your post (ntozier)

Comments

  • I have no idea what it is that you are trying to ask.
  • edited January 3
    Hey, maybe a little explain.

    I would like to create a new table in the database osTicket, then display data from the table on page visitor statistics.

    /scp/dashboard.php

    How in osTicket display data from the newly created table?
  • There is no way to do that in the osticket UI.  You would add the table.  Add your data to the table. create a query, and then edit the file you specified to display it.
  • I know that, i can't do it with UI.

    I will explain once again.

    I added a new table which called : test.
    It includes some columns : name, colour, size, shape.
    I put there some data.

    I would like to view this data in UI, on the site /scp/dashboard.php

    I tried in this way:

    $ Query = "SELECT * FROM test";
    $ Result = mysql_query ($ query);

    while ($ row = mysql_fetch_row ($ result))
     {
    echo $ row [0];
    echo $ row [1];
    echo $ row [2];
    echo $ row [3];
     }


    but it doesnt work.

    Which code php i have to use, to view data from this table (test).


    Thanks for help...
Sign In or Register to comment.