This is my set up.
I am trying to fill an html table with data from an Oracle table.
I am using php
The table I am referencing is fairly basic.
The table has an auto id incremented on each insert (intviewpostidpk)
It has a date field for when the insert occurred (dtmviewpostdate)
it has a number field that is associated to a posting id (intviewpostpostidfk)
What i need is a way to call a stored procedure that will fill my html table.
I am new to oracle, html, and php. I have had no issues with insert, delete, update using stored procedures.
Expand|Select|Wrap|Line Numbers
- SELECT INTVIEWPOSTPOSTIDFK, COUNT(INTVIEWPOSTPOSTIDFK) as COUNTPOSTVIEW
- FROM VIEWPOSTLOG
- GROUP BY INTVIEWPOSTPOSTIDFK
- ORDER BY COUNTPOSTVIEW DESC;
There are lots of different ways that I have seen to do this, but I have not been successful as of yet.
Any help or pointers into the right directions would be greatly appreciated