Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 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.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Getting data from Joomla database - basics
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Getting data from Joomla database - basics
#54195
Getting data from Joomla database - basics 9 Years ago Karma: 0
Hi
I haven't got data for Ari Tables from MySql tables previously and just tried the example on the demo video
Using Joomla

The SQL Query entered
SELECT
id,
title
FROM
#_content

obviously the statement is incorrect
is it the last #_content?

How can I know the correct references?

Thanks
The administrator has disabled public write access.
 
#54196
Re:Getting data from Joomla database - basics 9 Years ago Karma: 748
Hello,

Use the following query:

SELECT
id,
title
FROM
#__content

Regards,
ARI Soft
The administrator has disabled public write access.
 
#54197
Re:Getting data from Joomla database - basics 9 Years ago Karma: 0
Thanks It works
What did I do wrong?

Was it ...
#__content
How do you get the __

One more question
Have Ari soft designed a software where we can type in the data into tables and then connect those tables to Ari Tables?
Does it has to be a CSV file or MySQL tables?

Kumara
The administrator has disabled public write access.
 
#54198
Re:Getting data from Joomla database - basics 9 Years ago Karma: 748
#__ is replaced with Joomla! database table prefix.

Sorry, but we don't have an extension which provides ability to add, edit and delete data.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#54199
Re:Getting data from Joomla database - basics 9 Years ago Karma: 0
Very Clear.
However you have a excellent extension in Ari Tables. I think you should also provide data entry and editing which makes life easy for non-experts like me
Thanks
The administrator has disabled public write access.
 
Go to topPage: 1