[Release-28th May 2009]Code Snippet Viewer v0.5.1 + Code Snippet Creator v0.5.0

Code Snippet Viewer v0.5.1
 ---
 1. Copy the "Release" dir on your Windows Mobile Device with .NETcf2
 2. Run "CodeSnippetViewer.exe" on Device


- Version 0.5.1
  .Fix

- Version 0.5.0
  .Release

Code Snippet Creator v0.5.0
 ---
 1. Run "csviewer.exe" on Desktop PC
 2. Press "Create Database" Button to create "CodeSnippets.txt"
 3. Copy "CodeSnippets.txt" to your Device, where "CodeSnippetViewer.exe" is located

 The Snippets are read out of the "CodeSnippets.mdb", feel free to add your Snippets there, and Post it on XDA-Developers

- Version 0.5.0
  .Release

        oRS.Open "SELECT * FROM CodeSnippets ORDER BY ProgrammingLanguage ASC, Category ASC, UnderCategory ASC", oConn, adOpenKeyset
        
        oRS.MoveFirst
        txtData = oRS.RecordCount & vbNewLine
        For I = 1 To oRS.RecordCount

            TempData = oRS.Fields("ID").Value & ">{.+.}<" & _
                        oRS.Fields("ProgrammingLanguage").Value & ">{.+.}<" & _
                        oRS.Fields("Category").Value & ">{.+.}<" & _
                        oRS.Fields("UnderCategory").Value & ">{.+.}<" & _
                        oRS.Fields("Snippet").Value
            txtData = txtData & Replace(TempData, vbNewLine, ".>-NewLine-<.") & vbNewLine
            'This Replaces all linebreaks in the Tempdata and attaches it to txtData and also adds a line break afterwards
            
        oRS.MoveNext
        DoEvents
        Next
    oRS.Close
oConn.Close
Call frmViewer.txt_WriteAll(PathTo & "CodeSnippets.txt", txtData)

'Connect to the DB first

$newLine = '
';
'Sry that is a new line I do know if "\n" works instead

$SQLString = "SELECT * FROM CodeSnippets ORDER BY ProgrammingLanguage ASC, Category ASC, UnderCategory ASC";
    if ($SQLAnswer = mysql_query($SQLString))
    {
    	$txtData = mysql_num_rows($SQLAnswer).$newLine;
    	
		while($row = mysql_fetch_object($SQLAnswer))
        {
        	$TempData = $row->ID.'>{.+.}<';
        	$TempData .=  $row->ProgrammingLanguage.'>{.+.}<';
        	$TempData .=  $row->Category.'>{.+.}<';
        	$TempData .=  $row->UnderCategory.'>{.+.}<';
        	$TempData .=  $row->Snippet;
        	
        	$txtData .= $newLine.str_replace('.>-NewLine-<.', $newLine, $TempData).$newLine;
            
        }
    }

'Write $txtData to a File!