Re: [PHP-DB] MS SQL 7

2001-10-04 Thread Ermanno Iannacci

Which way?
I've tried with mssql_query, but it didn't work.
Thanks.

> -- Initial message ---
>
> From: "Frank M. Kromann" <[EMAIL PROTECTED]>
> To  : Ouster <[EMAIL PROTECTED]>
> Cc  : <[EMAIL PROTECTED]>
> Date: Thu, 04 Oct 2001 12:17:18 -0700
> Subject : Re: [PHP-DB] MS SQL 7
>
> If your storred procedure returns a result set you can get it with
the mssql_functions as well.
>
> If the precedure returns values or output parameters you will need
php 4.0.7 (or current cvs). The updated version of php_mssql.dll
includes three new functions aimed for storred procedures.
>
> - Frank
>
> > Is there a way to retrieve records from a stored procedure with MS
SQL 7?
> > I've tried but I couldn't get anything.
> > I read on the PHP bug site that I can only use SELECT statement,
but ODBC
> > should work; is that true?
> >
> > Thanks
> >
> >
> > --
> > 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: php-list-
[EMAIL PROTECTED]
> >
> >
> >
>
>
>
>

Sempre 'n testa 'a ranocchia gialla.


--
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]




[PHP-DB] Oracle 9i?

2001-10-04 Thread Beau Lebens

Just looking at upgrading an existing application which is potentially
turning from small-fry to enterprise level (aren't they all :P) and was
wondering what the situation is on Oracle 9i support.

I have never worked with Oracle/PHP together, but all I can find in the
manual are the ORA and OCI8 functions - can the ORA functions be used for
9i? is this a reasonable path to take?

TIA

Beau

-- 
Beau F Lebens, Technical Officer
National Key Centre for School Science and Mathematics
Science and Mathematics Education Centre
Curtin University of Technology,
GPO Box U1987 Perth, Western Australia 6845

t: +61 8 9266-7297 (has voice-mail)
f: +61 8 9266-2503 (ATT: Beau Lebens)
e: [EMAIL PROTECTED]
w: http://learnt.smec.curtin.edu.au/

-- 
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]




Re: [PHP-DB] Difference between OCI* functions and ORA_* functions

2001-10-04 Thread Philippe Saladin

FYI, You can use OCI8 on a Oracle 7 database, if the net8 client is
configured
Regards,
Philippe

"B. Perrine" <[EMAIL PROTECTED]> a écrit dans le message news:
[EMAIL PROTECTED]
ORA are for Oracle7
OCI8 for Oracle8

Read the manual on www.php.net
B.

le jeu 04-10-2001 at 17:02 Sridhar Moparthy a écrit :
> Hi All,
>
> Does any one know the difference between OCI* functions from PHP_OCI8.DLL
> and ORA_* functions  from PHP_ORACLE.DLL?
> Which one is better in terms of speed and which one is better for future
> compatibility?.
>
> Thanks in advance
> Sridhar Moparthy.
>
>
> --
> 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]





-- 
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]




Re: [PHP-DB] Email Processors Wanted Immediately!!!

2001-10-04 Thread Shooter

HAAHAHAHAHAHAHHAHAHH!!!

does this seem like a spam mail or what! :)

my suggestion. do not even  touch this email. the person is wanting some
more emails to spam.

Neil
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 04, 2001 4:04 PM
Subject: [PHP-DB] Email Processors Wanted Immediately!!!


> Dear [EMAIL PROTECTED],
>
> WE are looking for serious inquires from
> individuals who want to make a difference!!!
>
> Our company is offering an opportunity
> for individuals who want to become an
> E-Mail PROCESSOR. Work from home
> and be apart of this tremendous opportunity
> to sustain an income of your choice.
> Free 30 day trial membership, not MLM.
>
> Requirements: Computer, internet hookup,
> some basic computer skills and a little
> time & effort.
>
>
> SEND AN EMAIL TO: [EMAIL PROTECTED]
> WITH SUBJECT: "SHOW ME".
>
>
> ***Thanks for taking the time to look at this offer. Please
> accept my apologies if this email has offended you in
> any way. If you wish to no longer receive email please send
> an email message to [EMAIL PROTECTED] with "Remove"
> placed in the subject line.***
>
>
> Web Site; http://www.geocities.com/project_internetca/
>
> --
> 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]
>


-- 
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]




[PHP-DB] Email Processors Wanted Immediately!!!

2001-10-04 Thread terrycrowe_webdirect2001

Dear [EMAIL PROTECTED],

WE are looking for serious inquires from 
individuals who want to make a difference!!!

Our company is offering an opportunity
for individuals who want to become an
E-Mail PROCESSOR. Work from home 
and be apart of this tremendous opportunity
to sustain an income of your choice. 
Free 30 day trial membership, not MLM.

Requirements: Computer, internet hookup,
some basic computer skills and a little 
time & effort. 

 
SEND AN EMAIL TO: [EMAIL PROTECTED]
WITH SUBJECT: "SHOW ME".


***Thanks for taking the time to look at this offer. Please
accept my apologies if this email has offended you in
any way. If you wish to no longer receive email please send 
an email message to [EMAIL PROTECTED] with "Remove" 
placed in the subject line.*** 


Web Site; http://www.geocities.com/project_internetca/

-- 
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]




[PHP-DB] updating records in ODBC with cursor

2001-10-04 Thread m0sh3

is there a way to update records with cursor thru ODBC?

thanx




-- 
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]




[PHP-DB] Date

2001-10-04 Thread Devon

Is there a way that the default sql data base date -00-00 can be changed
using php?

Cheers



-- 
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]




Re: [PHP-DB] Howto make a double LEFT JOIN

2001-10-04 Thread Bas Jobsen

Hello Sheridan Saint-Michel,

Well it works fine, tnx!!!

But now i want to understand it too.

bit_count(bit_or(1<999.999.999))

Now i thougth bit_count(bit_or(32<
To: "Bas Jobsen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 04, 2001 8:02 PM
Subject: Re: [PHP-DB] Howto make a double LEFT JOIN


> Sheridan Saint-Michel
> Website Administrator
> FoxJet, an ITW Company
> www.foxjet.com
>
>
> - Original Message -
> From: "Bas Jobsen" <[EMAIL PROTECTED]>
> To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, October 03, 2001 2:52 PM
> Subject: Re: [PHP-DB] Howto make a double LEFT JOIN
>
>
> > Hello Sheridan Saint-Michel,
> >
> > Let's see.
> >
> > Table2 contains data with a unique identifier (id)
> > b.e
> > id|url
> >
> > Table1 and Table3 contain the same identifier (id) but it isn't unique
> now.
> > Table1 and Table3 contain couting of action. Cause i want to count only
> the
> > actions of the last X hours, each count is on a row apart. Each row in
> this
> > table contains a timestamp, so i could do something like "DELETE FROM
> Table1
> > WHERE time identifier
> > (sid)).
> >
> > Table1 and Table3:
> > sid|id|count|time
> >
> > count is always 1
>
> You probably don't need count, as each entry implies one event, unless you
> are using
> it for something else I don't know about... otherwise this looks good.
>
> > Oke, what do i want?
> >
> > First i want to know which id's  are in Table1 and how many times (know
> not
> > all the id's from Table2 have to be in Table1(or in Table3, and not all
> the
> > id's from Table1 have to be in Table3))
> >
> > something like: "SELECT DISTINCT id, SUM(count) FROM table1 GROUP BY id"
> >
> > For each id found in Table1 i want to know two things:
> >
> > 1) the url from Table2
> > 2) is there any row in Table3 where table1.id=table3.id and if so, how
> many
> > are there?
> >
> > This is it.
> >
> > thanks!!!,
> >
> > Bas
>
> Okay, now that you have added a unique Primary Key to each table this
> becomes a doable task.  The query to do everything you list here should
be:
>
> select table1.id,bit_count(bit_or(1< count1,bit_count(bit_or(1< table1 left join table3 using(id) left join table2 using(id) group by
> table1.id;
>
> As you can see, count is never used... which is why I said you probably
> don't need it.
>
> Let me know if this helps
>
> Sheridan Saint-Michel
> Website Administrator
> FoxJet, an ITW Company
> www.foxjet.com
>
>
> --
> 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]
>


-- 
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]




[PHP-DB] PHP with Domino Notes

2001-10-04 Thread Kiko

Hi..

There is any possibility to work with Domino Notes databases in PHP?

Thanks,
Kiko


-- 
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]




[PHP-DB] Other ODBC driver besides an openlink one?

2001-10-04 Thread Ricky Theil

We have had nothing but problems with our openlink drivers connecting to an
oracle database from our bug tracking software, so I'm not allowed to use
openlink odbc drivers. Is there another way to set up an odbc connection to
a linux system using php and odbc??? I know I can do native connections, but
I'm having a few problems installing oracle on Linux.
 
Thanks
 
Ricky



[PHP-DB] RE: [PHP-WIN] Setting up MySQL for PHP

2001-10-04 Thread Charles Butler

Even with it being on a separate server, setting up MySQL and PHP to
work together is almost flawless, with ODBC and MySQL being enabled by
default on the windows PHP ver, just plugin the code.. To test this
theory you can always use the following code (as I do when setting up a
new server):



That will test to see if you can connect to the host. Simple :)

For more information, either read the MySQL documentation along with the
PHP documentation, or check out devshed's tutorials. 
--
Charles Butler
[EMAIL PROTECTED]
Research and Development
American Telanet Corp. 


-- 
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]




Re: [PHP-DB] MS SQL 7

2001-10-04 Thread Frank M. Kromann

If your storred procedure returns a result set you can get it with the mssql_functions 
as well.

If the precedure returns values or output parameters you will need php 4.0.7 (or 
current cvs). The updated version of php_mssql.dll includes three new functions aimed 
for storred procedures.

- Frank

> Is there a way to retrieve records from a stored procedure with MS SQL 7?
> I've tried but I couldn't get anything.
> I read on the PHP bug site that I can only use SELECT statement, but ODBC
> should work; is that true?
> 
> Thanks
> 
> 
> -- 
> 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]
> 
> 
> 




-- 
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]




RE: [PHP-DB] Bug in new PHP Version?

2001-10-04 Thread Mark Roedel

> -Original Message-
> From: Luditus [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, October 03, 2001 3:13 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Bug in new PHP Version?
> 
> 
> I just downloaded the new 4.06 PHP Version and installed it on a new
> machine.
> 
> My application does not work properly anymore, nor does mysqladmin.
> 
> This are some warnings:
>
> [snip]
> 
> Does anybody have an idea?

You don't say what version you were upgrading from, but if you jumped
forward a few versions, I believe there was a change in the default
value of the error_reporting configuration option that'd result in the
display of more non-fatal warning messages (things like the unitialized
variable message you posted).

Note that, for the most part, your application should still behave the
way it did before (except for the printing of those messages).  I didn't
see anything in either of the messages you posted that appeared to
indicate a change in functionality...do you have some reason to believe
that things aren't working the same behind the scenes as they did
before?


---
Mark Roedel |  "Blessed is he who has learned to laugh
Systems Programmer  |   at himself, for he shall never cease
LeTourneau University   |   to be entertained."
Longview, Texas, USA|   -- John Powell 

--
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]




Re: Re[2]: [PHP-DB] padding an id field

2001-10-04 Thread Raquel Rice

On Thu, 4 Oct 2001 14:17:22 -0300
WebDev <[EMAIL PROTECTED]> wrote:

> Thursday, October 04, 2001, 1:13:59 PM, you wrote:
> 
> RR> When you define your auto-incrementing column, can't you
specify
> RR> "ZEROFILL"?  I believe it pads to the left with zeroes.
> 
> Hello Raquel,
> 
> Yes, but is it possible to append a code such as 'abc' along with
the
> zerofill to create an id like 'abc000123' for the 123rd id record.
> 
> /Merle
> 

I don't believe that's a possibility.  However, if I were doing it
myself, I would have two columns ... one that contained the 'abc'
identifier (or whatever) and the second which contained the
auto-incremented ID.  Then when I retrieved the full ID, I would do
it using ...

SELECT concat(first_id,auto_id) AS full_id FROM id_table ORDER BY
full_id;

-- 
Raquel

Don't be afraid of opposition. Remember, a kite rises against ...
not with ... the wind.
  --Hamilton Mabie

  
  

-- 
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]




Re: [PHP-DB] Difference between OCI* functions and ORA_* functions

2001-10-04 Thread B. PERRINE

ORA are for Oracle7
OCI8 for Oracle8

Read the manual on www.php.net
B. 

le jeu 04-10-2001 at 17:02 Sridhar Moparthy a écrit :
> Hi All,
> 
> Does any one know the difference between OCI* functions from PHP_OCI8.DLL
> and ORA_* functions  from PHP_ORACLE.DLL?
> Which one is better in terms of speed and which one is better for future
> compatibility?.
> 
> Thanks in advance
> Sridhar Moparthy.
> 
> 
> -- 
> 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]



--
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]




Re: [PHP-DB] Howto make a double LEFT JOIN

2001-10-04 Thread Sheridan Saint-Michel

Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com


- Original Message -
From: "Bas Jobsen" <[EMAIL PROTECTED]>
To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 03, 2001 2:52 PM
Subject: Re: [PHP-DB] Howto make a double LEFT JOIN


> Hello Sheridan Saint-Michel,
>
> Let's see.
>
> Table2 contains data with a unique identifier (id)
> b.e
> id|url
>
> Table1 and Table3 contain the same identifier (id) but it isn't unique
now.
> Table1 and Table3 contain couting of action. Cause i want to count only
the
> actions of the last X hours, each count is on a row apart. Each row in
this
> table contains a timestamp, so i could do something like "DELETE FROM
Table1
> WHERE time (sid)).
>
> Table1 and Table3:
> sid|id|count|time
>
> count is always 1

You probably don't need count, as each entry implies one event, unless you
are using
it for something else I don't know about... otherwise this looks good.

> Oke, what do i want?
>
> First i want to know which id's  are in Table1 and how many times (know
not
> all the id's from Table2 have to be in Table1(or in Table3, and not all
the
> id's from Table1 have to be in Table3))
>
> something like: "SELECT DISTINCT id, SUM(count) FROM table1 GROUP BY id"
>
> For each id found in Table1 i want to know two things:
>
> 1) the url from Table2
> 2) is there any row in Table3 where table1.id=table3.id and if so, how
many
> are there?
>
> This is it.
>
> thanks!!!,
>
> Bas

Okay, now that you have added a unique Primary Key to each table this
becomes a doable task.  The query to do everything you list here should be:

select table1.id,bit_count(bit_or(1

[PHP-DB] sybase extensions

2001-10-04 Thread Chevalier, Arthur

Hello,

I am very new to PHP and am having problems finding out information
regarding loading up the Sybase extensions for IIS on Win2K. Any help would
be greatly appreciated.

Art Chevalier
Sybase Replication Administrator
Space and Naval Warfare Center, Chesapeake
1-757-523-8303

  

-- 
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]




[PHP-DB] MySql special characters (éàôï)

2001-10-04 Thread Tom Landry

Hi !

My question is pretty simple. How do I specify a language for MySQL ? I
cannot retreive (or correctly insert, i'm not sure) any accentuated
characters (french canada) from my database with php, ODBC or the mysql
client. I may be a little off-topic, but it's pretty important for me to be
able to display these characters on my webpage.

Thank you



-- 
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]




[PHP-DB] MS SQL 7

2001-10-04 Thread Ouster

Is there a way to retrieve records from a stored procedure with MS SQL 7?
I've tried but I couldn't get anything.
I read on the PHP bug site that I can only use SELECT statement, but ODBC
should work; is that true?

Thanks


-- 
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]




[PHP-DB] Re: Bug in new PHP Version?

2001-10-04 Thread Hidulf

which version you ised before? and which version of the mysqladmin you are
using? seems you need a new version of mysqladmin.

--
Hidulf
http://www.hidulf.com
"Luditus" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi there,
>
> I just downloaded the new 4.06 PHP Version and installed it on a new
> machine.
>
> My application does not work properly anymore, nor does mysqladmin.
>
> This are some warnings:
>
>
> Warning: mysql_db_query is deprecated; use mysql_select_db() and
> mysql_query() instead in c:\dokumente und
> einstellungen\administrator\desktop\my
> files\projects\globosapiens\07_production\actual\mysqladmin\lib.inc.php on
> line 506
>
>
> Warning: Undefined variable: picture in c:\dokumente und
> einstellungen\administrator\desktop\my
>
files\projects\globosapiens\07_production\actual\gallery\app_local\dsp_album
> .inc on line 273
>
>
>
> Does anybody have an idea?
>
> Cheers Andy
>
>



-- 
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]




[PHP-DB] padding an id field

2001-10-04 Thread WebDev

Is there anyway to pad an id field in MySQL?  I have a table with a PK
field (id).  This field is auto incrementing a 6 digit number ie.
000223.  Is there anyway to pad this id so that it is padded with a
code along with the auto incrementing part, such as ABC000223.  Now I
wouldn't want the ABC pad to change but the 6 digits would still auto
incr as required.

Is this possible without doing any field editing, exclusively with a
MySQL utility?

thanks
/Merle



-- 
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]




RE: [PHP-DB] MYSQL Problems Please help

2001-10-04 Thread Jason Wong

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: 04 October 2001 17:11
>To: Jason Wong
>Subject: Re: [PHP-DB] MYSQL Problems Please help
>
>
>Jason,
>
>Mysql is running, so thats not the problem.
>I tired to run your updatedb to no avail.
>my directory for mysql is /var/lib/mysql
>so I tried the configure with the directory /var/lib still no joy.
>
>I really dont want to have to rebuid the box again as I have been
>doing this
>for a couple of days now.
>
>Any other ideas??
>
>Thank you for your help it is much appreciated

OK, you say you can't find "mysql.h", that is a file which is provided by
the MySQL-devel package --have you installed it?

Next, you need to configure php using
"--with-mysql=/dir/to/parent/of/mysql/mysql.h".

regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
Tel: +852-2573-5033
Fax: +852-2573-5851


-- 
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]




RE: [PHP-DB] MYSQL Problems Please help

2001-10-04 Thread Jason Wong

>-Original Message-
>From: Peter [mailto:[EMAIL PROTECTED]]
>Sent: 04 October 2001 16:42
>To: [EMAIL PROTECTED]
>Subject: [PHP-DB] MYSQL Problems Please help
>
>
>I am runing RH 7 Mysql (installed of RPM), Apache (compiled
>version) and PHP
>4.0.4pl1
>configure command './configure' '--with-xml'
>'--with-apache=../apache_1.3.19' '--enable-shared-pdflib'
>'--enable-track-vars'

[snip]

>and I am getting the following error
>
>Warning: MySQL Connection Failed: Can't connect to local MySQL server
>through socket '/var/lib/mysql/mysql.sock' (111) in
>/home/webgen/public_html/index3.php on line 10

It sounds like the mysql server is not running.

Do:

  /etc/init.d/mysql status

If that says "mysql is not running" (or words to that effect) then do:

  /etc/init.d/mysql start



>I have tried to recompile PHP using --with-mysql but it wont
>compile even if
>I specify the mysql location. It claims it cant find mysql.h

IIRC you have to specify the parent directory. EG if you had:

  /usr/include/mysql/mysql.h

then you would specify "/usr/include"

>runnig locate mysql.h brings back nothing.

If this is a fresh install you probably need to run "updatedb" to update the
db that locate uses.


regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
Tel: +852-2573-5033
Fax: +852-2573-5851


-- 
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]




[PHP-DB] MYSQL Problems Please help

2001-10-04 Thread Peter

I am runing RH 7 Mysql (installed of RPM), Apache (compiled version) and PHP
4.0.4pl1
configure command './configure' '--with-xml'
'--with-apache=../apache_1.3.19' '--enable-shared-pdflib'
'--enable-track-vars'

I am trying to connect to a mysql database using the following:



";
$host = "localhost";
$user = "root";
$password = "password here";
$database = "webgen";
echo "trying to connect to $host as $user";
$db = mysql_connect($host,$user,$password) or
die ("Connection could not be established");
echo "Connected";
echo "End of PHp.";
?>



and I am getting the following error

Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/home/webgen/public_html/index3.php on line 10

I have tried to recompile PHP using --with-mysql but it wont compile even if
I specify the mysql location. It claims it cant find mysql.h

runnig locate mysql.h brings back nothing.



-- 
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]




[PHP-DB] Re: PHP and MS Access

2001-10-04 Thread Russ Michell

For information:

For step by step info on using ODBC to connect MySQL to M$ Access go to:
http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm

Cheers.
Russ

On Wed, 3 Oct 2001 15:47:07 -0500 Carlos Augusto Abarca <[EMAIL PROTECTED]> 
wrote:

> This is absolutely not true. Although there isn´t a direct way to connect to
> Access from PHP (like you can do with PosgresSQL) you may connect to access
> using an ODBC connection. The only thing they have to do is Configure an
> ODBC DSN in their server pointing to your specific DB file and that´s it.
> 
> I hope I understood your problem correctly and I hope this answer is
> satisfactory.
> 
> 
> 
> 
> -- 
> 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]
> 

#---#

  "Believe nothing - consider everything"   
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam

  www.theruss.com

#---#


--
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]