Hi Denis,
try this one:
$r=odbc_exec($x,"select 'a' as a_leter from some_table");
or
$r=odbc_exec($x,"select \"a\" as a_leter from some_table");
which you prefer, but you have to escape the "" within a ""-String !!
Hope this solves your problem.
Greetinx,
Mike
Michael Rudel
- Web-Develop
BDY.RTF
--
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]
___Morris___
The database has a table of equipments with date fields for
date_online and date_offline.
The requirement is to find which equipments were available on a date
specified by the user, this being a variable created by the user.
My attempts at scripting for the condition where the dat
how are the times stored in the db ?
if they are dates or timestamps the comparison will need to be single quoted
instead of:
>My attempt, one of many,
>$result = mysql_query("select * from plant.eqpt where date_online <=
>$checkdate AND where date_offline => $checkdate order by type,
>size");
i think i also used >= to indicate 'equal or greater to than' instead of =>
like you have ...
Steve Brett
Internal Development
EMIS Ltd.
"Privileged and /or Confidential information may be contained in this
message. If you are not the original addressee indicated in this message (or
responsib
- Original Message -
From: boclair <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 10:45 PM
Subject: Re: [PHP-DB] Select where date is in period
>
> ___Morris___
>
> The database has a table of equipments with date fields for
> date_online and date_offline.
>
- Original Message -
From: Steve Brett <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 11:04 PM
Subject: RE: [PHP-DB] Select where date is in period
> i think i also used >= to indicate 'equal or greater to than'
instead of =>
> li
"boclair" <[EMAIL PROTECTED]> wrote in message
005101c0b2d2$4e6b3920$[EMAIL PROTECTED]">news:005101c0b2d2$4e6b3920$[EMAIL PROTECTED]...
|
| - Original Message -
| From: boclair <[EMAIL PROTECTED]>
| To: <[EMAIL PROTECTED]>
| Sent: Thursday, March 22, 2001 10:45 PM
| Subject: Re: [PHP-DB]
In article <011201c0b29b$7b6d9cb0$0101a8c0@server>,
[EMAIL PROTECTED] ("Pankaj Ahuja") wrote:
> Can anybody tell me the procedure and/or code necessary to include another
> document into a .php document
http://www.php.net/include
http://www.php.net/manual
--
CC
--
PHP Database Mailing List
No this not solves the problem
Unfortunatly it's not the sintax problem.
because Everything was fine until I setup
SQL Server 2000
Best Regards Denis Eltsov
""Michael Rudel"" <[EMAIL PROTECTED]> wrote in message
000301c0b2b0$08ae9020$[EMAIL PROTECTED]">news:000301c0b2b0$08ae9020$[EMAIL PROTECTE
Hello All!
Since I upgraded to PHP4, file upload into MySQL tables seems not to work
anymore. I am using PHPMyAdmin to access the database. When I try to upload
a file there, I get the Error "The file '[tmpdir]/php129947' must be in the
database directory or be readable by all" where [tmpdir] is
BDY.RTF
--
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]
So my problem is:
$r=odbc_exec($x,"select 'a' as a_leter from some_table");
generate FATAL: emalloc(): Unable to allocate 2147483599 bytes
'a' - is string leteral some_table is any table in my access db.
I use MS win2000 sp1,MS SQL Server2000, php 4.0.1-php4.0.4
(the problem is not depend on PHP
Hi.
Oracle 8/7 and PHP are supported!
Only we have to use the OCI8 to make one conection
to the Database.
It´s possible connect PHP+APACHE
and Oracle 8i or Oracle 9i, using Oracle Call Interface
on this two versions
Any Idea???
--
PHP Database Mailing List (http://www.php.net/)
To u
Hello,
Using it myself to...
Maybe this will help you out:
blabla a headline here
" . $row["1"] . "";
$i++; //the counter loops trough the do()while() and prints records
if ($i==3)
{
echo ""; //when the counter reaches 3 it prints the row-end and
new beginning.
I would like to make a comparison script that will compare two items. Here is an
example and my "halfway" there solution. [at least i think so
Here is my table [for the sake of this example]
+-+
| car_ID |make | model | colo
Please help me !!!
Description :-
Server 1 is installed MySQL which located in US.
Server 2 is located in Singapore, and doesn't install Mysql.
Both of them are installed PHP and Acaphe.
Case:-
I would like to set the server 2 connect to Server 1's MySQL database. What
should I do?
Thank you in
As you can only navigate record by record through the database table I think
the only way, as far as I know, is to store the record values into array
variables and print it to the page after you'd reached the last record.
HTH
Jayme.
-Mensagem Original-
De: olinux <[EMAIL PROTECTED]>
Par
In the 'user' table in the 'mysql' database on server1, you need to insert
the username you'll be using to connect (and the encrypted password), and in
the Host field you have to specify the hostname of server2, as well as what
privileges you want that user to have (I recommend nn, the
Greetings and Salutations Ian,
Somewhere in your code you are going to have a line similar to this:
$currentConnection = mysql_connect ($server, $userName,$password)
$server is going to be either the name or the IP address of your server
$userName is going to be the MySQL user name you use to co
Thanks, Thor and Cal ; )
"Ian" <[EMAIL PROTECTED]> wrote in message
99eaaj$njn$[EMAIL PROTECTED]">news:99eaaj$njn$[EMAIL PROTECTED]...
> Please help me !!!
>
> Description :-
> Server 1 is installed MySQL which located in US.
> Server 2 is
21 matches
Mail list logo
