Limit or distinct in query

This topic is locked

Limit or distinct in query	5/27/2010 3:47:04 PM
PHPRunner General questions
C cis2131 author I have a table with alot of url's, and alot of them are the same, but i would like to show just one of them. I can do that with Distinct or LIMIT, I know that Distinct is not supportet in the query editor, and i cant get LIMIT to work either. How can i do that in an other way?.. Claus


A	ann 5/28/2010
	Claus, unfortunately, PHPRunner supports only limited functionality of LIMIT, DISTINCT operators. I recommend you to create a view of the table in the database. Here is a sample: `CREATE VIEW ViewName AS SELECT DISTINCT FieldName FROM TableName` Then use this view in PHPRunner.