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
-
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
"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
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
Hello,
Using it myself to...
Maybe this will help you out:
!--BEGIN TABLE BORDER--
table width='90%' align='left' border='1'trtd
!--BEGIN TABLE DATA--
table width='90%' align='left'
trtd colspan='2'align='left'
font color='#FF' face='Verdana' size='2'bblabla a headline here
/b/font/td/tr
tr
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 |
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
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]
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,
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
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
14 matches
Mail list logo