[PHP-DB] cannot connect to mysql on windows

2006-02-25 Thread raj
Hello, I have apache 2 and mysql 4.1 and php5 and am unable to connect to mysql database server, and keep getting the following error: Fatal error: Call to undefined function mysql_connect() in D:\backup\test.php on line 10 I have removed the semicolon before the line:

[PHP-DB] Re: cannot connect to mysql on windows

2006-02-25 Thread El Bekko
raj wrote: Hello, I have apache 2 and mysql 4.1 and php5 and am unable to connect to mysql database server, and keep getting the following error: Fatal error: Call to undefined function mysql_connect() in D:\backup\test.php on line 10 I have removed the semicolon before the line:

Re: [PHP-DB] Query select value on MAX Date

2006-02-25 Thread Neil Smith [MVP, Digital media]
At 08:47 25/02/2006, you wrote: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=_=_NextPart_001_01C63997.1A6B1B7D Date: Sat, 25 Feb 2006 08:07:36 +0900 Message-ID: [EMAIL PROTECTED] From: [EMAIL PROTECTED] To: 'php-db@lists.php.net' Subject: FW: [PHP-DB] Query select

[PHP-DB] Writing to a file

2006-02-25 Thread Ron Piggott (PHP)
I wonder if someone would tell me the command in PHP that allows me to write to a file --- for example test.txt Just for this example I would like the word apple to be the contents of test.txt Now if I want to re-create test.txt --- erasing all the contents and start over and this time have the

RE: [PHP-DB] Writing to a file

2006-02-25 Thread Bastien Koert
www.php.net/fwrite bastien From: Ron Piggott (PHP) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Subject: [PHP-DB] Writing to a file Date: Sat, 25 Feb 2006 21:42:25 -0500 I wonder if someone would tell me the command in PHP that allows me to write to a file

[PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Chris Payne
Hi there everyone, This line of code USED TO WORK but now it gives me a Coudln't Execute Query error: $query2 = SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) LIMIT $offset,

RE: [PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Chris Payne
Hi there, I'm using asd just to test the search, here's the output from the statement echoed to the screen: SELECT word,def,photo, if(locate('asd',word),1,2) as meFirst ,MATCH(word,def) AGAINST ('asd' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('asd' IN BOOLEAN MODE)

Re: [PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Murray @ PlanetThoughtful
On 26/02/2006 3:03 PM, Chris Payne wrote: Hi there everyone, This line of code USED TO WORK but now it gives me a Coudln't Execute Query error: $query2 = SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST

[PHP-DB] FOUND THE PROBLEM WITH THE BAD CODE

2006-02-25 Thread Chris Payne
Hi there everyone, thanks to everyone for the help with the bad MySQL query. it turns out there was some bad JAVASCRIPT at the top and the search itself was fine, I tested it on my dev machine and just realized I have an older version of MySQL on here than on the server and the server was FINE