Re: [PHP-WIN] FORMATTING HTML IN AND OUT OF MYSQL

2001-02-01 Thread phobo
see http://www.php.net/manual/en/function.nl2br.php siggy - Original Message - From: "Bikes" <[EMAIL PROTECTED]> To: "'Robert Trembath '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 7:38 PM Subject: [PHP-WIN] FORMATTING HTML IN AND OUT OF MYSQL > I have a

php-windows Digest 2 Feb 2001 06:48:22 -0000 Issue 424

2001-02-01 Thread php-windows-digest-help
php-windows Digest 2 Feb 2001 06:48:22 - Issue 424 Topics (messages 5315 through 5330): MySql Connect Problem between Win and Linux 5315 by: Robert Trembath Exec() In Windows 5316 by: Keith Stevenson Re: Nulls in database 5317 by: Larry Forrister 5319 by: T

[PHP-WIN] FORMATTING HTML IN AND OUT OF MYSQL

2001-02-01 Thread Bikes
I have a little problem. I need to allow my clients to update the news on their website via a form. The form is supposed to allow them input Latest news etc. and then it is written into a database, and taken out on the other end by then index page. The problem now, is that I when I put the text

[PHP-WIN] Formatting Date

2001-02-01 Thread Ben Cairns
I have this line of code in a script: $todays_date=date("dmY"); It generates something like this: 01022001 What I need to do is get something like this from it: Thursday, February 01, 2001 Um, How? Thanks in adavance... -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 36533

RE: [PHP-WIN] Formatting Date

2001-02-01 Thread Matthew Hopkins
The .chm file from php.net is very useful and one of the smallest formats to download. To get the output you need use; date("w, F d, Y") -Matt -Original Message- From: Flint Doungchak [mailto:[EMAIL PROTECTED]] Sent: 01 February 2001 22:10 To: 'Ben Cairns'; [EMAIL PROTECTED] Su

RE: [PHP-WIN] Formatting Date

2001-02-01 Thread Flint Doungchak
Ben, Check out the date function in the php documentation. There's a lot of formatting option there. Go to php.net and type date in the quick ref field. -Flint -Original Message- From: Ben Cairns [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 2:00 PM To: [EMAIL PROTECTED

[PHP-WIN] Re: [PHP-WINDOWS] PHP4RC2+Apache+Win

2001-02-01 Thread Christopher Derr
The new PHP 4.04pl1 has Apache Win32 module support. Instructions are in the download. Chris Giacomo Falchetti wrote: > Can PHP4 run as an Apache module on Win9x? > I'd like to use HTTP Basic Authentication, and the CGI interface don't set > the PHP_AUTH_USER variable. > > TIA, Giacomo > > BEG

RE: [PHP-WIN] passing arrays of objects

2001-02-01 Thread Doug Brewer
try $foo //array with serialized objects in it $foo = rawurlencode($foo); $url = "something/something/foobar.php?foo=$foo"; and on the next page $foo = rawurldecode($foo); $foo = unserialize($foo); disclaimer: I didn't run thru these to see if it works although it might be better to pass it a

RE: [PHP-WIN] Problem with Oracle

2001-02-01 Thread Matt Hopkins
If you haven't already done so try uncommenting the ;extension=php_oracle.dll in the Windows Extensions section of your php.ini file. Also I'd assume you would need to put the php_oracle.dll into a folder such as winnt\system32. Matt -Original Message- From: Bikes [mailto:[EMAIL PROTE

[PHP-WIN] passing arrays of objects

2001-02-01 Thread Conover, Ryan
I was wondering if I can pass an array that has serialized objects to next page via url encoding $foo //array with serialized objects in it with the following encoding something/something/foobar.php?foo=echo($foo) and be able too unserialize $foo on the next page(foovar.php) ryan -- PHP Wi

RE: [PHP-WIN] Nulls in database

2001-02-01 Thread Svensson, B.A.T.
>I am trying to write a query to bring back rows that have null >values set in them. Try write WHERE [Start Construction Date] IS NULL OR [Actual Completion Date] IS NULL or alternatively selecting both nulls and empty attributes with or without white spaces: WHERE isnull([Actual Comple

[PHP-WIN] RE: [PHP] Nulls in database

2001-02-01 Thread Carlos Andre Marques Moreira
Actually you should use is null, or is not null (if you want to retrieve the rows that don't have null values), either uppercase or lowercase. Your query should be something like that: SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion Date] FROM common WHERE [Start Con

[PHP-WIN] Fixed it

2001-02-01 Thread Robert Trembath
Nevermind. It turned out to be a case-sensitivity issue between Windows and Linux in the MySQL Query. Excuse me for being Stupid.;-) Robert

Re: [PHP-WIN] Newbie - Help!!!!!

2001-02-01 Thread Tom Mathews
If there was an error with the DB connection, then the 'or die' clause should pick it up? If nothing has changed between the IIS nad Apache implementation then I don't know what is happenning If however you have changed the table structure at the same time... or maybe don't have any records on you

Re: [PHP-WIN] Nulls in database

2001-02-01 Thread Toby Miller
You are trying to compare for a value that does not match, correct? Try this: SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion Date] FROM common WHERE [Start Construction Date] <> '' OR [Actual Completion Date] <> '' Also, your query was saying if [Start Construction Da

php-windows Digest 1 Feb 2001 17:17:32 -0000 Issue 423

2001-02-01 Thread php-windows-digest-help
php-windows Digest 1 Feb 2001 17:17:32 - Issue 423 Topics (messages 5299 through 5314): Win2K/PHP4.0.4pl1 - include_path mess (won't include from the current directory) 5299 by: PHPBeginner.com 5303 by: Doug Brewer 5307 by: PHPBeginner.com system function doesn't wo

[PHP-WIN] Re: [PHP] Nulls in database

2001-02-01 Thread Juan
Réponse au message | [PHP] Nulls in database | du jeudi 1 février 2001, 18:05 : This is from memory concerning my old SQL class but isn't there something specific in sql lines saying that to find null values you should use : ISNULL Since an empty string is different from a null entry. CR> I am t

Re: [PHP-WIN] Newbie - Help!!!!!

2001-02-01 Thread Toby Miller
Everything the errors are pointing to is the result reference returned in $result. If your query fails and you just try to read the result you will get that error. Try something like this: $result = mysql_query( "SELECT * from nctd_reviews WHERE model_year='$year' AND manufacturer_name='$make' OR

Re: [PHP-WIN] Nulls in database

2001-02-01 Thread Larry Forrister
Try: [Start Construction Date] is null or:[Start Construction Date] is not null ~~LF "Conover, Ryan" wrote: > I am trying to write a query to bring back rows that have null values set in > them. I cannot figure out how to do this. I can bring back all rows that do > not have nulls with the

[PHP-WIN] Exec() In Windows

2001-02-01 Thread Keith Stevenson
Hi, Im having a Problem running an application from a PHP page using the Exec() function (as well as all the other program execution fuctions) on a Windows NT Server running Apache. The code I attempt to run is : $ReturnVal = exec("Application.exe"); It returns with Unable to F

[PHP-WIN] MySql Connect Problem between Win and Linux

2001-02-01 Thread Robert Trembath
For some reason the configuration when set to localhost for the mysql server works on Windows/PHP in Apache and IIS5 but on Linux I get: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/iShopHouston/NewVehicles

Re: [PHP-WIN] Newbie - Help!!!!!

2001-02-01 Thread Toby Miller
There seems to be a problem with your database connection. Can we see the header include? -Toby - Original Message - From: "Robert Trembath" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 10:20 AM Subject: [PHP-WIN] Newbie - Help! I don't understand

[PHP-WIN] Nulls in database

2001-02-01 Thread Conover, Ryan
I am trying to write a query to bring back rows that have null values set in them. I cannot figure out how to do this. I can bring back all rows that do not have nulls with the following query. SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion Date] FROM common WHERE [St

RE: [PHP-WIN] PHP vs JSP ?

2001-02-01 Thread Svensson, B.A.T.
But still there is much of truth in that remark. The answer is of course, both for softdrinks and scriptlanguages: it depends on. I guess in most case it is not actually about the language, but more related to the skills of the one who develops the system. As the story says: there are tools avail

RE: [PHP-WIN] Nulls in database

2001-02-01 Thread Richard
I don't know ANYTHING about ANY of this stuff...but where I come from (C) you would use 2 equal signs (==) to match values. Dunno if that applies here, but usually when you use 1 equal sign, you are assigning values. Rick -Original Message- From: Conover, Ryan [mailto:[EMAIL PROTECTED]]

[PHP-WIN] server error: authenticate

2001-02-01 Thread Nicholas_Chen
Dear All, I don't think there is something wrong with the following piece of script, but it does make Apache send a 500-server-internal-error. The error.log of Apache indicates "malformed header from script. Bad header=HTTP/1.0 401 Unauthorized ...". Would you please give me a hand? Thank yo

[PHP-WIN] Newbie - Help!!!!!

2001-02-01 Thread Robert Trembath
I don't understand why I getting an error on this. it ran on my IIS/PHP machine but on my Apache/PHP I get errors. Here the code and the results, Please help: New Vehicle Search"; mysql_select_db( $db ) or die ( "Couldn't open $db: ".mysql_error() ); $result = mysql_query( "SELECT * fr

RE: [PHP-WIN] Win2K/PHP4.0.4pl1 - include_path mess (won't include from the current directory)

2001-02-01 Thread PHPBeginner.com
Thanks Doug! You have just fixed it for me! I've tried it before (since I know how to do it on Linux) except that I haven't close the path with a backslash. At that point I though it won't work the way on Linux does. Thanks a bunch, I appreciate your help. Cheers, Maxim Maletsky www.PHPBeginne

RE: [PHP-WIN] Problem with Oracle

2001-02-01 Thread Bikes
I have a very big problem please. I installed Oracle on my Windows Professional server. However, whenever I try to call the Oracle OIC connect function, it tells me that the function is invalid. Please, I need to know if there is anything I need to do to enable me to connect to the Oracle server u

Re: [PHP-WIN] RE: links to php install bundles and tutorials

2001-02-01 Thread Tom Mathews
I suggest we leave this thread until end of play on Monday (then the weekenders can have a chance to see it as well). If no-one has any info about a FAQ by then, then maybe we should go ahead with the kill-9 idea? Tom [EMAIL PROTECTED] wrote: > I would put something like that up on www.kill-9.d

RE: [PHP-WIN] Win2K/PHP4.0.4pl1 - include_path mess (won't include from the current directory)

2001-02-01 Thread Doug Brewer
include_path= ".;e:\apache\lib\php\;" use a semi-colon to separate paths DB | -Original Message- | From: PHPBeginner.com [mailto:[EMAIL PROTECTED]] | Sent: Thursday, February 01, 2001 2:54 AM | To: PHPLIB; [EMAIL PROTECTED]; PHP | Subject: [PHP-WIN] Win2K/PHP4.0.4pl1 - include_path

Re: [PHP-WIN] RE: links to php install bundles and tutorials

2001-02-01 Thread kill-9
I would put something like that up on www.kill-9.dk or on www.php-unlimited.com (when it is done.) and am willing to help out. The server running both sites can take the load with no problem. Space is also no problem and mysql included so it could be searchable. But are you sure there isn't alr

[PHP-WIN] RE: links to php install bundles and tutorials

2001-02-01 Thread Simon Willison
Does this mailing list have an FAQ anywhere? [Simon Willison] -Original Message- From: Paul Trapnell [mailto:[EMAIL PROTECTED]] Sent: 01 February 2001 01:00 To: php Subject: re: links to php install bundles and tutorials --thanks for the additional tutorial link (the Meloni one at W

Re: [PHP-WIN] RE: links to php install bundles and tutorials

2001-02-01 Thread Tom Mathews
If there is a FAQ, I've never found it. However, the list is archived daily (twice daily?) on php.net and you can search the archive if you can be bothered! Anyone know who to contact about setting up a FAQ on php.net? Or has anyone got a reliable site with space (and the time to manage) a FAQ? I

[PHP-WIN] system function doesn't work

2001-02-01 Thread Emile Schenk
when I use the system function (or similars) on my system: win2k+apache I get tghe following error: unable to fork Anyone got a solution? Emile. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

php-windows Digest 1 Feb 2001 05:16:53 -0000 Issue 422

2001-02-01 Thread php-windows-digest-help
php-windows Digest 1 Feb 2001 05:16:53 - Issue 422 Topics (messages 5282 through 5298): Re: Problem with Oracle 5282 by: Asendorf, John 5283 by: Gonzalo Vera Re: How can I make PHP to work on Win98 ? 5284 by: Gonzalo Vera 5285 by: Richard 5286 by:

[PHP-WIN] Win2K/PHP4.0.4pl1 - include_path mess (won't include from the current directory)

2001-02-01 Thread PHPBeginner.com
Hello guys, I have the following problem: in my PHP.ini (which stays under c:\WINNT) I have include_path= "P:\includes; " ; UNIX: "/path1:/path2" Windows: "\path1;\path2" doc_root= ; the root of the php pages, used only