Not All records show

Martin,
we don't have to an option to show 1687 records only. What SQL query do you use?

Hi,
thanks for the quick reply. My sql query is below:
[codebox]SELECT `timestamp`.`urn`,

`timestamp`.`location`,

`timestamp`.`timestamp`,

`timestamp`.`timestamp1`,

`timestamp`.`userId`,

`timestamp`.`time_number`,

`timestamp`.`email_prev_u`,

`timestamp`.`email_prev_p`,

`timestamp`.`phone1`,

`timestamp`.`phone2`,

`driver`.`fName`,

`driver`.`sName`

FROM `timestamp`

INNER JOIN `driver`

ON `timestamp`.`urn`=`driver`.`urn`

[/codebox]
Thanks in advance
Martin

Martin,
change INNER JOIN to LEFT JOIN in your SQL.
You can find more info on using Joins here:

http://www.webcheatsheet.com/sql/interacti...al/sql_join.php

Martin,

Hi,
tried the above and still the same issue. Any other ideas?
Thanks, Martin

Martin,
I recommend you to do the following:

• turn on debug mode in the include/dbcommon.php file:
  

  $dDebug=true;
  

• open your application in browser
  
• and compare resulting SQL query with query on the Edit SQL query tab.
  If it doesn't help publish project on the Demo Acount and send a URL to your pages to [email=support@xlinesoft.com]support@xlinesoft.com[/email].

Hi,
thanks for your help. It now seems to be working. I think there was a server cache issue which caused the delay in the update showing.
Thanks again
Martin