[PHP-DB] Query with Access

2001-03-31 Thread Fernando Buitrago
Well, this is my code, but it dosen't work, please, help me, this table has 5 records, and the result of the query is -1. Code Lista Datos Regards -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL P

[PHP-DB] Informix user wierdness

2001-03-31 Thread Graeme Merrall
This is more an Informix question rather than a PHP question but I hope someone can help I've installed the Linux-SE version and CSDK of Informix from informix.com and installation has gone fine including createing the demo DB. I can also start 'dbaccess' and browse/query the tables so the envvars

[PHP-DB] array_diff usage

2001-03-31 Thread Martin Skjöldebrand
I'm daft. I don't understand the PHP Manual. I have two arrays: Open[0] contains 1 2 3 4 5 Closed[0] contains 1 2 Now: $test = array_diff($Open, $Closed); $lines = count($test); print $lines; Gives me: 1 I thought it should be 3. While: for ($counter =0; $counter <= $lines -1; $counter++) {

Re: [PHP-DB] send a html page into an email

2001-03-31 Thread Phil Jackson
I think you will have to send mime mail to send the page as an attachment. See http://www.wrox.com/Books/Book_down.asp?section=11_3&isbn=1861002963&subject=&subject_id= There you can download some source code from the "Proffesional PHP" book as a zip file. There will be a "mime_mail.inc" and a "

Re: [PHP-DB] Renaming a Table in a database

2001-03-31 Thread Michael Gerholdt
>From the mySQL manual: G.1 Things that must done in the real near future RENAME table as table, table as table [,...] Regards, Michael Gerholdt > Greetings! > > Can anyone tell me the SQL sintax to rename a Table in a MySql > database??? > > Thanks!!! > > ...

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Szeto
I have use other example and set the '/var/lib/mysql/mysql.sock' to chmod 777 this example work Thank you everybody. Ted Rolle <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Excellent diagnosis, sir! However, it is woefully and pitifully

[PHP-DB] Plugins??

2001-03-31 Thread Chris Hall
Hey guys, anyone built a plugin for macromedia dreamweaver 3 or 4, maybe ultradev? what about firstpage 2000?? the ones at macromedia's site arent that good IMHO, so if somone has built one and thinks it rocks send it to me, i could use it. :) thanks -- Chris Hall sytems administrator funnelbox

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Ted Rolle
Excellent diagnosis, sir! However, it is woefully and pitifully short on curative information. On Sun, 1 Apr 2001, Felix Kronlage wrote: > On Sun, Apr 01, 2001 at 06:50:24PM +0800, Szeto wrote: > > > I am new to Linux environment > > so what. You could still read the error-message: >

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Felix Kronlage
On Sun, Apr 01, 2001 at 06:50:24PM +0800, Szeto wrote: > I am new to Linux environment so what. You could still read the error-message: | Warning: MySQL Connection Failed: Can't connect to local MySQL server | through socket '/var/lib/mysql/mysql.sock' (111) in this suggests, that you

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Szeto
I am new to Linux environment what is mean by socket and what is the file.extensive and location Felix Kronlage <[EMAIL PROTECTED]> wrote in message 20010401003741.A5849@mad">news:20010401003741.A5849@mad... On Sun, Apr 01, 2001 at 06:05:28PM +0800, Szeto wrote: > the MySQL is on c

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Felix Kronlage
On Sun, Apr 01, 2001 at 06:05:28PM +0800, Szeto wrote: > the MySQL is on coz, it show in > > > Warning: MySQL Connection Failed: Can't connect to local MySQL server > > > through socket '/var/lib/mysql/mysql.sock' (111) in is there a socket in /var/lib/mysql ? -fkr -- gpg-fingerprint: 076E 1E

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Szeto
the MySQL is on coz, it show in Ted Rolle <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Mysql isn't up? > > > On Sun, 1 Apr 2001, Szeto wrote: > > > Hello > > > > The code below i use in testing the connection (written in php4) > > > if(!mysql_connect("l

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Ted Rolle
Mysql isn't up? On Sun, 1 Apr 2001, Szeto wrote: > Hello > > The code below i use in testing the connection (written in php4) >if(!mysql_connect("localhost","khaimun","akyweb")) { > print "could not connect to mysql!"; > } > mysql_select_db("focalmail"); > ?> > > -

[PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Szeto
Hello The code below i use in testing the connection (written in php4) --- Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/test/test-db.php4 on line 2 could not connect to mysql! Warning: MyS

RE: [PHP-DB] CSS versus Includes

2001-03-31 Thread Michael Geier
this post is about apples and oranges... CSS (Cascading Style Sheets) have nothing to do with includes. They only have to do with formatting elements on a web page. They can be written inside the document, or can referenced externally via a tag. Includes can be anything from a configuration fil

RE: [PHP-DB] RE: [PHP] RE: what exactly are /path/to/blah lookingfor? .h? .so? .a? what?!

2001-03-31 Thread Daevid Vincent
I get the "No such file or directory" right after the "license box" shows up in the PHP4 compile. Like this (no matter what directory I've tried in that big old list so far): ./WTConfigure: --with-openlink=/usr/local/openlink/lib: No such file or directory "./WTConfigure" is just a shell script

[PHP-DB] Renaming a Table in a database

2001-03-31 Thread Valter Santos
Greetings! Can anyone tell me the SQL sintax to rename a Table in a MySql database??? Thanks!!! Valter Santos WEB/WAP Consultant Email : [EMAIL PROTECTED] Mobile: +351 93 9650075 WeDo Consulting - http://www.wedo.pt

Re: [PHP-DB] Oracle8i, PHP4, Apache

2001-03-31 Thread Rouvas Stathis
Define necessary env vars in Apache startup script. putenv has no effect after httpd has started. Good Luck, -Stathis. Martin Lustig wrote: > > Hi all, > > i have a trouble with settiong of environment for apache web server with php > and oracle8i database. > My connection to the database from

[PHP-DB] Oracle8i, PHP4, Apache

2001-03-31 Thread Martin Lustig
Hi all, i have a trouble with settiong of environment for apache web server with php and oracle8i database. My connection to the database from php script thru OCI functions working but my problem is, that php script hasn't all environment variables from OS (ORACLE_HOME,ORACLE_SID,NLS_LANG). I hav

Re: [PHP-DB] putenv() doesn't seem to work!! Groan!

2001-03-31 Thread Martin Lustig
I just have similar problem on the Sun Solaris unix... My putenv () command doesn't affect next part of the script. |-)) Martin. ""Scott Fletcher"" <[EMAIL PROTECTED]> pí¹e v diskusním pøíspìvku 99viqu$av6$[EMAIL PROTECTED]">news:99viqu$av6$[EMAIL PROTECTED]... > One more thing, could it be tha

[PHP-DB] retrieving images

2001-03-31 Thread Mike Baerwolf
Hello, I'm trying to retrieve and output all the binary images in my images table. This is what I have, $result = mysql_query("SELECT * FROM images",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { $filetype = ($myro

[PHP-DB] send a html page into an email

2001-03-31 Thread Pedro M. S. Oliveira
hello all. this is what i need to do i have a dinamic page, buitl with mysql and php, and then i have this form saying, send this page to a friend. how can i send the content of the page to an email addy? thank you all *** Pedro Miguel Silva Oliveira Cel