ARI Soft - Pre-Sales ARI SQL TABLE

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

more...
31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

Pre-Sales ARI SQL TABLE

(1 viewing) (1) Guest

Page: 12

TOPIC: Pre-Sales ARI SQL TABLE

Forum Tools

#11681

Pre-Sales ARI SQL TABLE 13 Years, 9 Months ago Karma: 0

Supports SQL queries of any complexity

These means query like the example above :

Code:

$result = mysql_query("SELECT * FROM jos_users ORDER BY dr_disp DESC LIMIT 0,30");

while($row = mysql_fetch_array($result))

{

$id_user = $row["id"];

if($id_user == 63 || $id_user == 62 || $id_user == 64 || $id_user == 76){}

else{

$equipe = $row["username"];

$administrador = $row["name"];

$dr = $row["dr_disp"];

$dr = number_format($dr,2,',','.');

totallnet

Last Edit: 2013/01/04 13:25 By admin.

The administrator has disabled public write access.

#11683

Re:Pre-Sales ARI SQL TABLE 13 Years, 9 Months ago	Karma: 760
Hello, Do you want to show specific number of records (in your case 30) and format replace "," with "." in "dr_disp" column or you need something another? Regards, ARI Soft

admin

Last Edit: 2013/01/04 13:25 By admin.

The administrator has disabled public write access.

#11685

Re:Pre-Sales ARI SQL TABLE 13 Years, 9 Months ago	Karma: 0
its not only limits because i saw its possible with pagination... But the real interesting is bribg some data from my DB with while , where and others MySQL format options...

totallnet

Last Edit: 2013/01/04 13:26 By admin.

The administrator has disabled public write access.

#11686

Re:Pre-Sales ARI SQL TABLE 13 Years, 9 Months ago	Karma: 760
The module works in the following way: 1. User specify "SELECT" SQL query (WHERE, ORDER BY and other clauses can be used). 2. The module gets data by specified query and shows it in selected table or chart widget view. The module can format columns, for example use values from different columns in one record that create new value. Regards, ARI Soft

admin

Last Edit: 2013/01/04 13:27 By admin.

The administrator has disabled public write access.

#11688

Re:Pre-Sales ARI SQL TABLE 13 Years, 9 Months ago Karma: 0

And specific WHILE (PHP/MySQL codes)

like :

Code:



SELECT * FROM Persons

while($row = mysql_fetch_array($result))

  {

  echo $row['FirstName'] . " " . $row['LastName'];

  echo "<br />";

  }

totallnet

Last Edit: 2013/01/04 13:28 By admin.

The administrator has disabled public write access.

#11689

Re:Pre-Sales ARI SQL TABLE 13 Years, 9 Months ago	Karma: 760
No, it doesn't provide "while" construction. Formatting from your post can be done with formatting functionality of the module or with help standard MySQL CONCAT function. Regards, ARI Soft

admin

Last Edit: 2013/01/04 13:30 By admin.

The administrator has disabled public write access.

Page: 12

Useful Links