|
Hah! I did it. Just one more thing. 11 Years, 10 Months ago
|
Karma: 0
|
|
Thanks to all the postings, I figured this out.
Now have another problem. I got the sql query to pick up exactly what I want except I need it to not show data that is not published. Is this possible? I sure hope so.
Here is my sql query and it works great (will definitely give a big thumbs up in the Joomla extension ratings.)
SELECT
id,
street_num,
street,
street2,
apt,
price,
beds,
baths,
sqft,
lot_acres,
garage_size
FROM jos_iproperty
thanks
|
|
|
|
|
|
|
Re:Hah! I did it. Just one more thing. 11 Years, 10 Months ago
|
Karma: 748
|
Hello,
Send SQL dump of iproperty tables by email so we can help.
Regards,
ARI Soft |
|
|
|
|
|
|
Re:Hah! I did it. Just one more thing. 11 Years, 10 Months ago
|
Karma: 0
|
|
Fell dumb, here. Do not know how to do a sql dump. I do know how to get into the database, though.
|
|
|
|
|
|
|
Re:Hah! I did it. Just one more thing. 11 Years, 10 Months ago
|
Karma: 2
|
|
mphillips wrote:
Fell dumb, here. Do not know how to do a sql dump. I do know how to get into the database, though.
There is usually an SQL export option when using phpMyAdmin.
|
|
|
|
|
|
|
Re:Hah! I did it. Just one more thing. 11 Years, 10 Months ago
|
Karma: 0
|
|
Lots of choices here - pdf, csv, csv for Excel, sql plus zipped or not and a bunch more??
|
|
|
|
|
|
|
Re:Hah! I did it. Just one more thing. 11 Years, 10 Months ago
|
Karma: 2
|
|
mphillips wrote:
Lots of choices here - pdf, csv, csv for Excel, sql plus zipped or not and a bunch more??
I'm not sure what exactly you're asking in this post.
|
|
|
|
|
|
|
