Strange Things Going On......

jjjamie

I've wrote some code to pull some info from an Access database and put it on the screen but for some reason the page keeps refreshing itself! Has anyone else had this problem happen them them? You can see the data for a brief second but then the page refreshes and it's gone!

bastien

jjjamie


<HTML>
  <HEAD>
  </HEAD>

  <BODY>

<?php

  // Program to test connecting to a Microsoft Access ODBC Data Source
  $connection = odbc_connect("pattest", "", "");
  print "Connected to datasource<BR><BR>";

  if ($result = odbc_exec($connection, "SELECT AssetNum, CliNum, ApplianceID, TestDate, AllPFS FROM results"))
    print "Command executed successfully<BR><BR>";
  else
    print "Error while executing command<BR><BR>";

  // Print results
  while(odbc_fetch_row($result))
    print odbc_result($result, 1) . "   " . odbc_result($result, 2) . "   " . odbc_result($result, 3) . "   " . odbc_result($result, 4) . "   " . odbc_result($result, 5) . "<BR>";

  odbc_close($connection);
  print "<BR>Connection closed.";

?>

  </BODY>
</HTML>

If the output is small, the rapid refresh doesn't happen.

I grately apprieciate any assistance you can provide.

Jamie

bastien

the braces are missing from the loops....test worked fine

//used your code for a test

if ($result = odbc_exec($connection, "SELECT * FROM postcard")){
print "Command executed successfully ";
}else{
print "Error while executing command ";
}
// Print results
while(odbc_fetch_row($result)){
print odbc_result($result, 1) . " " . odbc_result($result, 2) . " " . odbc_result($result, 3) . " " . odbc_result($result, 4) . " " . odbc_result($result, 5) . " ";
}