[PHP] Red Hat 7.0
I am trying to start the server and it returns the following in the interbase.log. ns1.mautec.com (Client) Sat Apr 14 22:06:05 2001 INET/inet_error: connect errno = 111 ns1.mautec.com (Client) Sat Apr 14 22:06:05 2001 /opt/interbase/bin/ibguard: guardian starting bin/ibserver ns1.mautec.com (Client) Sat Apr 14 22:06:20 2001 INET/inet_error: read errno = 104 ns1.mautec.com (Client) Sat Apr 14 22:06:20 2001 INET/inet_error: receive in try_connect errno = 104 ns1.mautec.com (Client) Sat Apr 14 22:06:20 2001 /opt/interbase/bin/ibguard: bin/ibserver normal shutdown. I have been using interbase super server before but in the SuSe 7.1 with 2.2.18 without any problems. I have tried the rpm and the tar installation with the same results... Can anyone help me out? -- PHP General 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]
[PHP] escape sequences not recognized inside an .html
Hi, I believe I am missing some configuration regarding my apache becouse I can only get php to work inside a file .php. If my page extension is .html, nothing happend with the php script; but just changing from .html to .php everthing works fine. Anyone? Anyhelp? I'm new over php. I usually do stuff with Delphi/Builder and now I'm moving to web oriented programs. Thanks for looking! Mauricio Junqueira Mautec Corp. -- PHP General 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: [PHP] escape sequences not recognized inside an .html
I've check the other articles and came up with the following: 1- take out the extension, html or php, inside the links in way that I can change from .html to .php and vice-versa without worrie to change all links. 2- and to add the .html to httpd.conf in order to all files to be parsed. Not too beatifull but so far, I'm a litte too short in html/php and this is going to help me to finish the job. At first, I though that the apache it itself called php and it finds the escape sequence, not that the entirely file has to be parsed by php. Thanks for your replays Mauricio Junqueira wrote: > Hi, > I believe I am missing some configuration regarding my apache becouse > I can only get php to work inside a file .php. > If my page extension is .html, nothing happend with the php script; but > just changing from .html to .php everthing works fine. > Anyone? Anyhelp? > > I'm new over php. I usually do stuff with Delphi/Builder and now I'm > moving to web oriented programs. > > Thanks for looking! > > Mauricio Junqueira > Mautec Corp. > -- PHP General 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]
[PHP] Interbase error code = -504 Cursor unknow
Hello, this is my first attempt to query and print a result coming from a
database, in this case interbase6.
I got the following error: InterBase: Dynamic SQL Error SQL error code =
-504 Cursor unknown in maingeral.htm on line 8
Here's the code:
alert('" . ibase_errmsg() .
"'); ");
$stmt = "select count(*) from soldcars";
$query= ibase_query($stmt) or die ("alert('" . ibase_errmsg() . "'); ");
$result = ibase_fetch_row($query);// THIS IS LINE 8
$TOTSOLD = $result;
ibase_free_result($query);
$stmt="select Total from monthsold";
$query = ibase_query($stmt) or die ("alert('" . ibase_errmsg() . "'); ");
$result = ibase_fetch_row($query);
$TOTMONTH = $result[0];
ibase_free_result($query);
$stmt= "select count(*) from deal where available = 1";
$query = ibase_query($stmt) or die ("alert('" . ibase_errmsg() . "'); ");
$result = ibase_fetch_row($query);
$TOTAVAIL= $result[0];
ibase_free_result($query);
ibase_commit();
ibase_close();
?>
I have 3 query blocks. the result shows the contents of 2nd and 3rd block
variable:TOTMONH and TOTAVAIL but nothing from the first block, TOTSOLD.
If I comment the first block entirely, I got the same error
(ibase_fetch_row line) on the 2nd block and the only result that appear is
from the 3rd block.
What I am doing wrong?
I've put this statement before the first block to see if $query was empty
but the statement return true and the same error occured in the
ibase_fetch_row line and the echo $query shows everytime Resource id#4
if (isset($query)) {
echo($query);
$result = ibase_fetch_row($query);
$TOTSOLD = $result;
ibase_free_result($query);
} else echo "query not set";
If just comment the following lines, everything works Please help...
I'm getting nut !!
alert('" . ibase_errmsg() .
"'); ");
$stmt = "select count(*) from soldcars";
$query= ibase_query($stmt) or die ("alert('" . ibase_errmsg() . "'); ");
// $result = ibase_fetch_row($query);
// $TOTSOLD = $result[0];
// ibase_free_result($query);
$TOTSOLD ="COMMENTED";
$stmt="select Total from monthsold";
$query = ibase_query($stmt) or die ("alert('" . ibase_errmsg() . "'); ");
$TOTMONTH = $result[0];
ibase_free_result($query);
$stmt= "select count(*) from deal where available = 1";
$query = ibase_query($stmt) or die ("alert('" . ibase_errmsg() . "'); ");
$result = ibase_fetch_row($query);
$TOTAVAIL= $result[0];
ibase_free_result($query);
ibase_close();
?>
--
PHP General 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: [PHP] Interbase error code = -504 Cursor unknow
Since ibase_query returns true if the query succeeds I've tried this, but
with the same problem with ibase_fetch_row:
$stmt = "select count(*) from soldcars";
if ($query= ibase_query($stmt) or die ("alert('" . ibase_errmsg() . "'); ")){
$result = ibase_fetch_row($query);
$TOTSOLD = $result[0];
ibase_free_result($query);}
--
PHP General 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]
[PHP] column names
HI, does anyone knows how to retrive information about the columns names of a table? I know that is possible to use show table mytable using isql but I need to get information about the columns using sql. that information is to be accessed with a php script. so, I'm looking for something resembling "select info from table" How may I supposed to do that? -- PHP General 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: [PHP] column names
Steve Werby wrote: > "Tim Ward" <[EMAIL PROTECTED]> wrote: >> SHOW COLUMNS FROM tablename >> is the MySQL query > > That works well from the MySQL commandline, but isn't as useful from > within a PHP script if Mauricio wants to control the formatting of it, > limit the > fields displayed and use it within the logic of the PHP script. Depends > what he needs to do. I still think mysql_field_name() / pg_fieldname() > are the way to go, though Mauricio never mentioned which DBMS he's using. > > -- > Steve Werby > President, Befriend Internet Services LLC > http://www.befriend.com/ > > > I am using interbase6 By now , using this query over the system tables solved my problem: SELECT RDB$FIELD_NAME FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME = 'mytable' I need to do this way because the table might be empty and I'll not be able to use ibase_field_info on each column returned by one query like select * from mytable. -- PHP General 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]
