Removing Duplicates after Search/Advance Search but Before Export

Is it possible to avoid putting duplicates in the table in the first place using unique index?

Is it possible to avoid putting duplicates in the table in the first place using unique index?

Unfortunately not in this instance. I'm really needing a way to remove duplicates from the List page results as the customer begins to Export the results (minus duplicates) if they so choose which is most of the time but unfotunately not all of the time.

I think it's a matter of adding DISTINCT to SQL query on the export page.
Here is the sample code that you can place to 'After table initialized' event:

if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1)=="Cars_export.php")

I think it's a matter of adding DISTINCT to SQL query on the export page.

I am just a little lost on the above coding but I can see that it is just an example but not an exact use for my situation. I am assuming that what you are saying is that I could make some simple statement that says "IF search_engine_export.php is being requested THEN gsqlHead="SELECT DISTINCT hash_value"; (FYI... hash_value is the MD5 field which I am wanting to make DISTINCT and subsequently have exported by the customer)
Is this correct? If so, what is a simple IF statement that I could use and place within the 'After Table Initialized' event that says IF search_engine_export.php THEN gsqlHead="SELECT DISTINCT hash_value";
Many Thanks in advance!

When you open 'After table initialized' event in event editor you can see a hint area with variables like $gsqlHead.
Paste my code there, use correct name of export page, paste line with $gsqlHead from the hint area and insert DISTINCT after SELECT.
This is it.

Unfortunately DISTINCT is not working as I have far more than 20 fields and I am only wanting DISTINCT on the MD5 field which I have named in my database table as "Hash_Value". To use DISTINCT I would have to create a more cpu intensive, lengthy and complicated command such as using SELECT MAX (Name), MAX (File_Size), Hash_Value, MAX (Created_Date), MAX (Written_Date) etc. etc and then GROUP BY at the tail end.
Could I use something more like...
if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1)=="search_engine_export.php")

$gsqlHead="SELECT * FROM search_engine WHERE 1 GROUP BY Hash_Value";
I tried this initially but when I tried to export the results of my advance search query it threw up an error. I suspect I have to break down the last line as I have it all starting after "$gsqlHead=" which may be wrong.

If you think GROUP BY gives you better results than DISTINCT you should definitely proceed that way.
Check that event hint area for other variables you may want to override like $gsqlFrom;

I've spent last night and this morning looking at the event hints but I cannot find the exact title lines that I need for each sql statement. I mean I have the following that I listed above:
$gsqlHead="SELECT FROM search_engine WHERE 1 GROUP BY Hash_Value";
but obviously this does not work. Do I need to change it to something more in line with:
if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1)=="search_engine_export.php")

$gsqlHead="SELECT ";

$gsqlFrom="FROM search_engine ";

$gsqlWhereExpr="WHERE 1 GROUP BY hash_Value";
I tried this also using the Event hints provided in the product Help Manual but something is still not right as I get a SQL syntax error on the screen when I try to Export the records from the "search_engine_export.php" process. Can you tell what looks incorrect that I am putting into the Event?

dblack6047,
your code doesn't look good as GROUP BY cannot be added to WHERE clause.
I recommend to post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL for investigation. We also need to see SQL query that you expect to be executed on the export page.

Sergey,
After nearly two months I finally figured out the exact code. The exact code needed under "Table Events" and then within "After Table Initialized" which allowed me to remove duplicates (based on MD5 hash column of values) once the customer selected from the List Page the option to Export the data shown on the List Page was:
/ here goes EVENT_INIT_TABLE event

if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1)=="search_engine_export.php")

{

$gsqlHead="SELECT Name, MD5, SHA_1, SHA_256";

$gsqlFrom="FROM search_engine ";

$gsqlWhereExpr="1 ";

$gsqlTail="GROUP BY MD5 ";

}
I thought this would be best to provide the above to others in the Forum in case they could pull information from above code. Good Luck!