Right idea but I think this will be more efficient (who knows try both
- you have a lot of "OR"s 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
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 an
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
> ..
Subscribe digest
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 hav
Hello Guys/Gals. I've been looking around forever for some help, never
thought about asking the ListServ.
Here it goes:
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
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 a
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
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, v
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 avail
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 u
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 unsub
you forget the last ' on your include string:
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 Message -
From: "J. Kevin C. Burton" <[EMAIL PROTECTED]>
To
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
14 matches
Mail list logo
