You can use something like:
SELECT MyFunction();
Thinks works on mySQL, i'm not sure if it works on mssql but you can give it
a try.
Tanks to Alban Médici (NetCentrex) who told me this a month ago on this list
:)
- Original Message -
From: indra Siregar [EMAIL PROTECTED]
To: [EMAIL
you forget the last ' on your include string:
?
include('global.inc.php');
echo $myVariable;
?
didnt you see the error message of php ? if dont change you error reporting
for development, this an error easy to find out if you have your error
reporting set to E_ALL.
- Original
Hi,
I've upgrade the PHP 4.06 to PHP4 .2.2 in Redhat 9.0. after that, it
was found the following script can't work well. the empty seems not
function. Any one can help!
...
If (empty ($A)
.
else
...
Best regards,
Raymond
--
PHP Database Mailing List (http://www.php.net/)
To
Hi everyone
trying to do an e-booking service for BBs.
In mysql db I've got a booking table with an arrivalDate and a departureDate field for
each Unit booked. My Units are the Rooms and in the Unit table.
I want to check availability for every single unit.
$result_dates=mysql_query(SELECT
Try putting a separate network connection between your webserver box and your db, specifically for data between PHP and your DB.
Don't route that traffic through the same network as you are using to retrieve the webpage, as the DB connection will eat up all of your bandwidth, leaving none
How do I compile PHP on Unix to have oracle 9 support. Looking at
./configure --help and PHP's website, I see no option for oracle 9
support. I see --with-oci8 but that appears to only work for Oracle 8.
Any help? Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
I am using OCI-8 with Oracle 9i just fine.
- Paul
-Original Message-
From: Adam Williams [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 9:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] compiling oracle support
How do I compile PHP on Unix to have oracle 9 support. Looking
For MSSQL databases use the following syntax for executing a stored
procedure:
mssql_query( EXEC sp_name param1, param2, param3, ... );
Another alternative is to use the mssql_init(), mssql_bind()
mssql_execute() functions.
Also, better support for executing MS-SQL stored procedures is
From: J. Kevin C. Burton [EMAIL PROTECTED]
I have a SQL statement that looks like this:
SELECT EMPLOYEENAME,SUPERVISORID WHERE EMPLOYEEID='$employeeid'
what I want to do is lookup the supervisor's name in the same SQL
statement. If not, I would have to use an function, and if I have a 100
Subscribe digest
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Hi,
I've upgrade the PHP 4.06 to PHP4 .2.2 in Redhat 9.0. after that, it
was found the following script can't work well. the empty seems not
function. Any one can help!
...
If (empty ($A)
.
else
...
Best
Hi all
I read that it is neccessary and good to optimize my DB tables frequently.. I am using
phpMyAdmin-2.5.4 to maintain my database and the program showed me that my overhead
for some tables is over 5000. Can i know when would be good for me to optimise my
tables? For example, once I have
Right idea but I think this will be more efficient (who knows try both
- you have a lot of ORs which can force another query to run):
I'm assuming your Unit table is called unit and the primary key is
id and this joins to bookings.unit_id
SELECT id
FROM bookings left join unit
ON id =
13 matches
Mail list logo
