2. PHPRunner General questions
  3. SHOW RECORD COMMING FROM A TABLE
This topic is locked

SHOW RECORD COMMING FROM A TABLE

 		11/3/2009 7:50:09 AM
PHPRunner General questions
B
 bsidy1 author

Hello

I would like to know how to display data from a table. Example

select * from table_name

In a way how to display the query result using the engine temple PHPRunner
please i need explain
Sergey Kornilov admin 11/3/2009

Simply add this table to your PHPRunner project and let PHPRunner generate all required code and pages. This is it.
B
 		bsidy1 author 11/4/2009



Simply add this table to your PHPRunner project and let PHPRunner generate all required code and pages. This is it.



I have all ready generate the code all i need is to modify the code so that i will make what i need with it
for exemple i will need to show the result of this query

select substr(TIMESTAMP,1,10), count(*) from roda.WEBTOSMS_CLIENT where SMS_ORIGINE='25425624145'

AND TO_DATE(substr(TIMESTAMP,1,10),'DD/MM/YYYY')>=TO_DATE('01-10-2009','DD/MM/YYYY')

AND TO_DATE(substr(TIMESTAMP,1,10),'DD/MM/YYYY')<=TO_DATE('10-11-2009','DD/MM/YYYY')

GROUP BY substr(TIMESTAMP,1,10) ORDER BY 1 DESC



i have made a simple table like this

<table width="484" border="1">

<tr>

<td width="233"><CENTER> <STRONG>DATE</STRONG> </CENTER></td>

<td width="235"><CENTER> <STRONG>TOTAL_SMS_ENVOYES</STRONG></CENTER></td>

</tr>

<tr>



<td> "here the date" </td>

<td> "here the total (count)</td>

</tr>

</table>


how can i do to show the result of that query. without generating the projet simply by modifing the generated code thank 's

NB : the result should be more thant four or five lines
please help
J
 		Jane 11/4/2009

Hi,
you can select values and show result in your table using custom script or application.

Unfortunately we don't have a ready to go solution for this.