I'm toying with this script I found for doing DB queries.. Up until I added 
the print ("<TABLE...") and print ("</TABLE>"); code, it worked.. can 
anyone help me find out what I'm doing wrong? (quoting the bit of the 
script, so as not to do the TMI bit :)

What this does now is give me "560k read" and a frozen browser :(

Thanks!
Glenn


<snippage>...
         $db = mssql_connect(DB_HOST, DB_USER, DB_PASS) or DIE("DATABASE 
FAILED TO RESPOND.");
         $values = array();

                 if (!empty($where)){
                 if (!strstr(strtolower($where),"where ")) $where = "where 
$where";
         }
         $query = "select $fields from $tables $where $groupBy $orderBy";
         echo "query=$query<br><br>\n\n";
         if ($show_debug == true) echo "query=$query<br>\n";
         $stmt = mssql_query ($query, $db) or DIE("Table unavailable");
         print ("<TABLE BORDER=1><TR><TH ALIGN=LEFT>COMPANY</TH><TH 
ALIGN=LEFT>Contact Name</TH><TH ALIGN=LEFT>Email Address</TH></TR>");

         for ($i = 0; $i < mssql_num_rows( $stmt ); ++$i)
                              {
                                      $line = mssql_fetch_row($stmt);
                                      
print("<TR><TD>$line[0]</TD><TD>$line[1]</TD><TD>$line[2]</TD></TR>");
                              }
         print ("</TABLE>");

         @mssql_free_result ($stmt);
         @mssql_close($db);

         return $values;

}





>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php

---
Glenn E. Sieb, System Administrator
Lumeta Corp. mailto:[EMAIL PROTECTED]
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to