Hello,
I have been use PHP connect to mssql 6.5 with FreeTDS. I'd like to select
data from 2 table with separate in 2 database name. How could I do this?
here is some example.
DB#1 DB#2
|--> Table#1-in-DB#1 |--
Yeah I also fail to see the php-db on-topic-ness of the original post,
but nevertheless, it's early in the morning, here's my tuppence worth...
All you need to do is configure Apache to make PHP process all .wml
files, and then change the header at the top of all your WML files to
header("Conten
php4 suport Priner() in windows.How do I use it ?thanks very much.
--
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]
And you can also use http://xml.apache.org/cocoon2/index.html which you can
program to transcode anything to anything you want or you can just get
yourself a transcoder from www.aethersystems.com which uses Scout Web or
Clearigo www.clearigo.com and then you have www.wap-shareware.com and use
th
At 20.09.2001 04:26, Andrius Jakutis wrote:
>Hello again,
>
>the problem Is that I found out, that my company doesn't support wml files
>at all.
>
>What Do I have solution? USe some gateway, translator what ever else?
>
>What I need is : person takes mobile, enter's some URL, and my web site is
>c
I need to set up PHP to work on a Windows 2000 machine with IIS 5, PHP 4.05
and Oracle 8.0.5 installed. I was having problems with the connection and
kept getting all kinds of errors about the TNSNAMES file, but now I'm
getting this error.
Warning: _oci_open_server: ORA-12699: Native service in
Try this
eval("\$sql=\"select * from vehicle where company=$company_code\";");
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "Mark Newnham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 4:34
I've now progressed to the point where I'm not getting eval errors. The next
problem is that is doesn't substitute the variable names: so the code
$company_code=1;
eval($sql='select * from vehicle where company=$company_code';");
ends up $sql equal to 'select * from vehicle where company=$comp
I'm trying to store SQL code in a blob field in a mysql database, but i'm
having a problem.
The code looks like this "$sql='select * from vehicle where
company=$company_code';";
After I retrieve it from the db i eval() it to get the result.
I can make this work if i store the code in a variable
Sure, just use ODBC - it'll insulate you from issues like changing database
versions and platforms.
You can use native drivers or download ones from our site.
Let me know if I can help.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Univ
is it possible to establish a connaction with php 4.0.4 to mssql server vers
8 ???
i've tried it serveral times but php alway crashes with the php_mssql70.dll
extension - and the modul php_mssql from the 4.0.6 release doesn't work with
php 4.04
is it there an other extension out there
thanx
cu
You need to setup the MIME type, look below:
Configuring MIME types
Table 1. MIME Types for WAP
Extension MIME Type Description
.wml text/vnd.wap.wml WML source
.wmls text/vnd.wap.wmlscript WMLScript source
.wbmp image/vnd.wap.wbmp Wireless Bitmap
In table 1, the mime types for serving WML
Where in the manual can I read about output buffering? I need to email the
phpinfo stuff to myself
Thanks
Randy
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001
--
PHP Dat
http://www.phpbuilder.com/columns/mike20010118.php3
Check this out!
-Original Message-
From: Andrius Jakutis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 7:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php and WAP?
Hello,
I have web site, based on PHP+MYSQL. What
Maybe I need on-line gateway service that converts WML written pages for
delivery to wireless devices???
Where could I get it for free?
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To co
There's also PhpAdsNew, which picks up where PhpAds left off at its last
release in May of 2000:
http://sourceforge.net/projects/phpadsnew/
-Andy
> -Original Message-
> From: Boaz Yahav [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 18, 2001 1:42 PM
> To: Andrius Jakutis; [EMAI
Is it possible to sort LDAP entries retrieved by an attribute (for
example, on sn )? I don't see anything like this in the PHP docs.
Hugh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact
Hello,
I have web site, based on PHP+MYSQL. What is the best (ofcouse and
profesional) way to have the same site on WAP also?
1. Do I need to rewrite all PHP files in to wap language?
2. DO I have to do this manualy, or there is some utility, which converts
automatically (profesionally)? (give a
the header() function MUST be sent prior to any other output. Otherwise, it
will fail. What else in the page precedes the header()?
-
On 9/12/01 5:54 AM, in article [EMAIL PROTECTED],
"Its Me" <[EMAIL PROTECTED]> wrote:
> session_start();
> session_
> You need to capitalize the 'L' in "Location" (HTTP headers are
> case-sensitive).
Wrong... you can use
header("location: index.php");
just fine...
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send blank email to [E
Try:
http://$HTTP_HOST/mall/menu.php";) ;
?>
You need to capitalize the 'L' in "Location" (HTTP headers are
case-sensitive).
HTH,
Colter Reed
On 9/12/01 5:54 AM, in article [EMAIL PROTECTED],
"Its Me" <[EMAIL PROTECTED]> wrote:
> session_start();
> session_destroy();
> header("location:http:/
There is an excellent set of functions called dbUtils that takes care of
this type of thing. You can get it from www.SiteCreative.com
- Jonathan
"Arief Fajar Nursyamsu" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> Dear All...
>
> Can I rename a database n
> Learning is NEVER a waste of time...
No, of course not, but having been on these lists for sometime, I get the feeling some
people (as I
would, and do) get pi**ed off if someone doesn't at least try first before asking
questions..
> p.s. Your father is a psychiatrist??? Now, there, I could
It wasn't a waste of time. Now, the next time you have a similar problem
with a mySQL query, you'll follow this procedure.
Learning is NEVER a waste of time...
p.s. Your father is a psychiatrist??? Now, there, I could use some help...
-Original Message-
From: Russ Michell [mailto:[EM
Ok ok ok!! Thank you both for the pointers, they did of course yield the problem - as
bloody always
it's something completely different! As my old-dad always says: "Everything is about
something
else" (although this was always meant in a psychiatrist-patient relationship..)
Thank you again bo
YES!!! Exactly
Russ...do what Steve syas...
-Original Message-
From: Steve Cayford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:32 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Query construction
Usually what I do when I'm having this type
You've created $sql. Good. Print it...display it...show its contents...
Does it contain the TEXT that you expect? Copy and paste it to the "mysql>"
command line in mysql.
-Original Message-
From: Russ Michell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:33 AM
To:
I'm sorry but I must be missing something fundamental here. This is how my code looks,
and if the
SQL query yields nothing and emits no error (as it currently is) it simply reverts to
error.php:
$sql = "SELECT * FROM $table_users WHERE usrName='$username' AND
usrPswd=password('$password') AND
Usually what I do when I'm having this type of problem is put the whole
sql statement into a string variable then print the variable out just
before running the query so you know exactly what's being sent to mysql.
Then I log into mysql from the command line and enter the query manually
to see
$query = "SELECT * FROM $table_users WHERE usrName='$username' AND
usrPswd=password('$password') AND affil_team RLIKE '$team+'"
print $query
what were the contents of $query
-Original Message-
From: Russ Michell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:19 AM
To: R
If you mean did the pattern I'm trying to match: $team, contain what I though it
should:
'footballSat' then yes it did. I also receieve no error message from MySQl
The string in the table field I can view/alter in phpMyAdmin and I've tried matching
$team in the
query to the string as: foo
PHP manual, chapter 19
-Original Message-
From: its me [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 8:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] uploading
i want the user to upload files to server
when i worked offline i used to write:
$updir = "C:\apache\htdocs\mal
Did you look at Chapter 19 of the PHP manual?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 8:54 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] uploading and stuff
Hello there...
I want to upload textfiles and store them in my TEXT
On Thu, Sep 20, 2001 at 05:04:37AM +0700, Arief Fajar Nursyamsu wrote:
> Can I rename a database name ?
I don't know what database you are using, but you should be able to do
something like this with most of them.
Do a backup of the database.
Create a new database with the new name.
Restore the
When you printed-out the string variable containing the SELECT statement,
what did it look like?
-Original Message-
From: Russ Michell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:01 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Query construction
Hi there:
Further to
Hi there:
Further to a previous submission (which can be ignored), I'd like the following query
to 'search' a
table field of different team names (stored as a single string), but it does't seem to
work!
"SELECT * FROM $table_users WHERE usrName='$username' AND
usrPswd=password('$password') A
> > Can I rename a database name ?
> There is no command to do so. Have you tried simply renaming
> the files and sub-directory where the database files are located?
> I've not tried that.
Simply renaming could be dangerous.
You can do this:
mysqldump old_database_name > old_database_name.tx
He's not trying to set multiple cookies...only one.
-Original Message-
From: Mark Collin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 4:01 PM
To: Rick Emery; 'Jason Caldwell'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Cookies ???
instead of setting multiple cookies, why no
There is no command to do so. Have you tried simply renaming the files and
sub-directory where the database files are located?
I've not tried that.
-Original Message-
From: Arief Fajar Nursyamsu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 5:05 PM
To: PHP-DB
Subject: [
Hello there...
I want to upload textfiles and store them in my TEXT type field in my
postgres database.
So in my html form I have this entry:
(and whatever else I had to put
there)
the script I wanted to upload the file, but somehow it does not seem to do
that:
I use the rename() function, but
Dear All...
Can I rename a database name ?
Regards
rief
--
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]
they have something you need
http://phpwizard.net
--
Hidulf
http://www.hidulf.com
"Andrius Jakutis" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello all,
>
> I need your recomendations, where to download from a good (profesional -
> many options) banner ex
check your mysql user table
make sure your login has the permission to GRANT
--
Hidulf
http://www.hidulf.com
"Its Me" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Warning: MySQL Connection Failed: Access denied for user:
'rehab@localhost' (Using password: YE
i want the user to upload files to server
when i worked offline i used to write:
$updir = "C:\apache\htdocs\mall\logos";
as logos folder is where i put the files(logos)
all my files is in a folder called mall and inside the mall folder
there is the logos folder.
what should be the equivilant of
Good idea Michiel,
I tried "$@VARIABLE" but it doens't work (not content).
Concerning the other idea, as far as I know the odbc procedure only
returns if it has run successfull or not and thus gives me a "0" or a
"1" if use:
$VARIABLE=odbc_exec ($conn,"declare @VARIABLE int exec PROZEDURNAME
'
Missed that...
Try these:
$VARIABLE = odbc_exec(...)
or try what $@VARIABLE contains...
Met vriendelijke groet,
Michiel Lange
ActuEra B.V.
"S
hello !
I have a problem, My SP does not return anything neither to Sybase Interactive SQL nor
to PHP.
When i use to try it from Sybase Central it adds me to may Query "Select [var] from
DUMMY" after execuring procedure.
What should I do to recive the contents directly from Stred Proced. ?
anyone who can translate this?
Met vriendelijke groet,
Michiel Lange
ActuEra B.V.
7k
Hi,
I run a remote procedure via ODBC on a sybse server. The procedure
returns an integer in a variable "@VARIABLE". I have to use the integer
as a variable "$VARIABLE" in PHP. Does anybody know how to get the
content of "@VARIABLE" into "$VARIABLE"?
This is the code I use:
odbc_exec ($conn,"
Hallo,
ich nutze per ODBC eine remote procedure auf einem Sybase Server. Die
Prozedur liefert mir unter anderem eine Variable zurück, die ich in PHP
weiternutzen muß. Kann mir jemand einen Hinweis geben, wie ich die
Variable der ODBC Abfrage in eine PHP Variable übertragen kann?
Hier das Beisp
Hi all:
As it stands I have a users table with several fields of personal details and a
single field representing a user's affiliated sports-team.
I also have a separate table that consists of these sport-teams.
The problem is that I'd like each user to be able to sign up for more than one tea
Hi,
Please check out the following error.
"Unable to load dynamic library './php_imap.dll' - ./php_imap.dll:
invalid ELF header in config.php on line 3"
I have loaded the php_imap.dll at runtime using the dl() function.
Can anyone tell me the reason for this error and how to solve it.
Thanx,
Vi
Warning: MySQL Connection Failed: Access denied for user: 'rehab@localhost' (Using
password: YES) in /home/sites/site92/web/mall/confirmregistration.php on line 14
Error connecting to host localhost, by user rehab
should i use this:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON
53 matches
Mail list logo
