Re: [PHP-DB] *.xls
Inside the downloadable ZIP file there Excel Clas17881432001.zip http://www.planet-source-code.com/xq/ASP/txtCodeId.11898/lngWId.1/qx/vb/scripts/ShowCode.htm you find a file called excel.txt containing a description of the MS-Excel File format: the first few lines: MICROSOFT EXCEL BINARY FILE FORMAT -- Mark O'Brien Microsoft Corporation 18-Feb-1988 Table of Contents - Introduction General BIFF Record Format Rows and Columns Within BIFF Cell Table - Concepts Cell Records Record Types Cell Attributes Order of Records Finding Values From BIFF Files Excel Formulas Expression Evaluation Unary Operators Binary Operators Operand Tokens - Constant Operand Tokens - Classes Operand Tokens - Base Control Tokens Function Operators Reserved Ptg's Scanning a Parsed Expression Excel Function Table Command Equivalent Function Table List of Ptg's Steve Brett wrote: it's VB ? -Original Message- From: Hans-Werner Guth [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 14:32 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] *.xls Hi, ...write to an XLS file without DLL's or Excel automation... visit: http://www.planet-source-code.com/xq/ASP/txtCodeId.11898/lngWI d.1/qx/vb/scripts/ShowCode.htm ...snipp... -- Hans-Werner Guth S http://www.qits.de QITS GmbH T mailto:[EMAIL PROTECTED] Formerstr 53 I fon +49-2102-852-145 40878 Ratingen Q fax +49-2102-852-202 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: Odp: [PHP-DB] Best way to check if a query succeeded
We do it this way (code snippet)
...
$dbqueryline = mysql_db_query ($mredatabase,
"select vorgang, bezeichnung
from mrebewkennz
order by vorgang", $dbhandle);
if (mysql_errno() != 0)
{
echo mysql_error(); echo "\n";
}
else
{
$bewkenznzahl = mysql_num_rows($dbqueryline);
print "$bewkenznzahl Bewegungskennzeichen\n";
}
Bartek Pawlik wrote:
...snipp...
I normally do something like:
$sql = "SELECT something FROM table";
$result = mysql_query($sql);
if(@mysql_num_rows($result) 0) {
echo'Query Suceeded';
} else {
echo'Query failed';
}
...snipp...
--
Hans-Werner Guth S http://www.qits.de
QITS GmbH T mailto:[EMAIL PROTECTED]
Formerstr 53 I fon +49-2102-852-145
40878 Ratingen Q fax +49-2102-852-202
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
