Re: MySQL to Excel ?

2002-05-01 Thread James Dellacova
Good morning Jay, Try adding below the header in a php file & output the query data in HTML table format. Best regards, James --- Jay Blanchard <[EMAIL PROTECTED]> wrote: > Howdy, > > I need to write some data out to Excel spreadsheets > for some of our managers > to muddle with for projec

RE: How do I find duplicate records?

2002-04-30 Thread James Dellacova
Thank you for the email. Following is the php code but it doesn't work. 1 "; $result1 = mysql_query($query); while ($row = mysql_fetch_array($result1)) { echo "$row[id]"; } } ?> Best regards, James --- Jay Blanchard <[EMAIL PROTECTED]> wrote: > [sn

How do I find duplicate records?

2002-04-30 Thread James Dellacova
Hi All, I have over 68,000 records in a table with unique ID field that has 10 chars. Need to create a query to find all matching or duplicate IDs up to 8 chars. (Eg. 12345678%%) Can anyone help me? Thanks in advance for any comments. James _

Need help to find duplicate records.

2002-04-29 Thread James Dellacova
Dear All, My record id is 10 char long, all records are unique. However, many of these ids consist of _. Trying to print all matching records with first eight characters of the id. For some weird reason, it's not working properly. Any comments or help will be greatly appreciated. Blow is m