Solved

get the data all row not only one row php

Posted on 2016-10-26
4
51 Views
Last Modified: 2016-10-26
sc_lookup(Dataset, "SELECT  tablename FROM pg_catalog.pg_tables
where schemaname = 'public'and tablename not like 'pong8%'") ;

{customer_id} = {Dataset[0][0]};

echo "{customer_id} " ;

Open in new window


This code work but how can I change it to print all customer not only first customer
0
Comment
Question by:teera
  • 2
4 Comments
 
LVL 52

Accepted Solution

by:
Julian Hansen earned 500 total points
ID: 41859901
It appears you are using ScriptCase

To iterate over the Dataset I am assuming you would do something like this
foreach({Dataset} as $row) {
   echo "Customer: {$row[0]}<br/>";
}

Open in new window

1
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 41859930
Is this a PHP application?  PHP variable names start with a dollar sign.  Or is there something else in play here that I am missing?
0
 

Author Comment

by:teera
ID: 41859985
Hi  Ray Paseur

I use scriptcase  

thank you for help me many time
0
 
LVL 52

Expert Comment

by:Julian Hansen
ID: 41860047
You are welcome
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Creating and Managing Databases with phpMyAdmin in cPanel.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now