IN the phpmyadmin, Export tab, there are quite a few choices. Do I export as sql,csv...? There seems to be a default, but as I have never done this before I am really unsure of what I am doing.
The original request was a way to get the html view in data tables to just show only published records.
Thanks for hanging in there with this database newbie. I do appreciate it.

mphillips wrote:
IN the phpmyadmin, Export tab, there are quite a few choices. Do I export as sql,csv...? There seems to be a default, but as I have never done this before I am really unsure of what I am doing.

I would export in more than 1 format, perhaps SQL and CSV for Excel.

Then take a look at the SQL code and see how it compares to CSV for Excel.

You can learn a lot about SQL just by looking at the commands.


The original request was a way to get the html view in data tables to just show only published records.
Thanks for hanging in there with this database newbie. I do appreciate it.

I'm new to ARI Data Tables too, except that I wrote SQL code years ago. So I'll have to go acquaint myself with "html view in data tables".

Send dump in SQL format. You can read how to create it here (see "Backup of Mysql database" section).

Regards,
ARI Soft

Learning lots of new things here, Thnaks for all the help.
I have the database dump for iproperties and I know what needs to be done, just do not know the correct format.
It would be "state=1"
But not sure how to put it in the query...this is what I have and it works well,
SELECT
id,
street_num,
street,
street2,
apt,
price,
beds,
baths,
sqft,
lot_acres,
garage_size
FROM jos_iproperty

Now how does the "state=1" go in??

What is the purpose of state=1? Are you asking to restrict the rows to those rows which have the column of "state" having a value of 1?

If so, append WHERE state=1 to the end of your SQL query.

Yes!! We are in business.
Thank You
Your children will be blessed.