Re: [PHP-DB] php-mysql-and the elusive eval statement....

I would think that you can't use '' special tags in the eval function (at least use only one of it). Try this ?hi But I think that what will is that it will stop execution on the '?>' sign (end of PHP code) and print out an error like 'missing closing quote' or such. On Thursday 01 November 20

Re: [PHP-DB] MySQL: Alphabetizing title results in library format

Hi, seems a bit strange. Try this select (use mysql client) mysql> select title,if(title like 'The %','yes','no') from titles; if it works try substring functions and if that works try 'order by' clause. It's at least working on server v. 3.23, so in case it will not work find out in the 'list o

[PHP-DB] Re: Using A Query Results Multiple Times

just put it in a loop. while($val = mysql_fetch_result($result)) $array[] = $val; foreach($count = 0; $count < count($array); $count++) echo $array[$count]['product_name']; foreach($count = 0; $count < count($array); $count++) echo $array[$count]['product_name']; php4 has foreach() its be

Re: [PHP-DB] php + interbase

On Thursday 01 November 2001 20:34, Jacek Krywult wrote: > I have an error messagge when try to configure php.ini to use > php_interbase.dll. > FoxServ, php ver. 4.0.6 ( I tried also 4.0.4 ), win 98. interbase local > from Delphi 5. I think that local interbase installed with delphi is pre versi

[PHP-DB] php-mysql-and the elusive eval statement....

I'm having a php/mysql problem using the eval statement. what I'm done is created a template that is database driven ie. the document is setup so that all of the head, leftside, body, right and bottom are all text comming from database query returns. all database returns are valid tested code.

[PHP-DB] Sorting output of MySQL Select Like queries

Can someone help me understand the problem with the approach I am trying or suggest a new approach? Basic Objective: Search several fields of a table for keywords/search terms and return the ID's for records containing those keywords. I would like to then sort those ID's in descending order of th

[PHP-DB] Question about MySQL, ORDER

http://paa.fragland.net/hosted/myquestion/ here you find my question, thx -- 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] Error: stub.lo file trunacted file not found

On SuSE 7.1 Latest PHP and Apache source using --with-apxs with PHP configure receive noted error. Anyone solve this? Saw thread in PHPbuilder about removing stub.c and remaking, that provided an error stating stub.c was required. Thanks Greg -- PHP Database Mailing List (http://www.php.ne

[PHP-DB] php + interbase

I have an error messagge when try to configure php.ini to use php_interbase.dll. FoxServ, php ver. 4.0.6 ( I tried also 4.0.4 ), win 98. interbase local from Delphi 5. What is the way to use interbase with php ? greetings, Jacek Krywult -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] MySQL: Alphabetizing title results in library format

On Thu, Nov 01, 2001 at 04:43:00AM -0500, Ian Evans wrote: > Cami wrote: > > > Try this: > > mysql> select *,(case when title like '%The%' then substring (title, 5, 255) > > when title like '%A%' then substring (title, 3, 255) when title like '%An%' > > then substring (title, 4, 255) else title e

Re: [PHP-DB] php bulletin/dicussion board

If you have mySQL phpBB is excellent http://www.phpbb.com/ HTH Paul - Original Message - From: "Tom Hodder" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 3:52 PM Subject: [PHP-DB] php bulletin/dicussion board : : Hi, : : can anyone recommend a good

[PHP-DB] Re: Error: No such file or directory

Ok, solution seems to be eliminating comments in the script. When comments are removed, script errors also disappear. "Greg Robinson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hmm, > Seems if I execute ./configure (with arguments) from termial (shell pro

Re: [PHP-DB] php bulletin/dicussion board

http://phorum.org/ Russ On Thu, 1 Nov 2001 15:52:01 - Tom Hodder <[EMAIL PROTECTED]> wrote: > > Hi, > > can anyone recommend a good php discussion/bulletin board thats free, as I > need to choose one and have been over whelmed by the variety available. > > Cheers > > Tom Hodder > > >

[PHP-DB] php bulletin/dicussion board

Hi, can anyone recommend a good php discussion/bulletin board thats free, as I need to choose one and have been over whelmed by the variety available. Cheers Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-ma

[PHP-DB] Re: Ordering titles in MySQL (long)

Hi Ian, I tried a couple different things, trying to chop off leading articles. I didn't want to maintain a 2nd column for titles, but eventually had to succumb to this. (My difficulty is that I'm using French and English titles (for a bilingual interface), so I actually have four fields: my fie

[PHP-DB] Re: Error: No such file or directory

Hmm, Seems if I execute ./configure (with arguments) from termial (shell prompt) no error. But when executed from shell script there is an error. Does this make sense? "Greg Robinson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Executing from a script file

RE: [PHP-DB] retrieve data from more db

Simply indicate the database name in you query: SELECT cust2000.mytable.*, cust2001.mystable.* FROM cust2000.mytable, cust2001.mystable WHERE cust2000.mytable.cust_ID=cust2001.mystable.cust_ID; -Original Message- From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October

[PHP-DB] Error: No such file or directory

Executing from a script file I continue to receive the following errors when compiling PHP4: System: SuSE 7.1, latest Apache & PHP source ./myphpmakefile: --with-apache=/usr/local/src/apache/apache_1.3.22: No such file or directory ./myphpmakefile: --with-config-file-path=/www/conf: No such file o

Re: [PHP-DB] Ms-Access to Mysql converter

On Thu, 1 Nov 2001 16:17:38 +0550 [EMAIL PROTECTED] wrote: Most of them availalbe in the downloads section of mysql.com : http://www.mysql.com/downloads/contrib.html Look at the sections clients, converter and "using MySql with Other Products" hth pa -- PHP Database Mailing List (http://www.ph

[PHP-DB] Re: MySQL: Alphabetizing title results in library format

I'm new so I could be totally off track here but could you not use the php string manipulation functions in conjunction with strtoupper() to produce the desired result prior to inserting in the db? "Ian Evans" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Bac

[PHP-DB] Ms-Access to Mysql converter

can anyone tell me which is a good Ms-Access to MySQL converter under open source /demo /commercial/etc. -TIA Sharmad -- 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

[PHP-DB] PostgreSQL to MySQL

hi i have a .sql file that was dumped from PostgreSQL and i want to import that into MySQL. I haven't got a clue how i am gonna approach that. Can anyone suggest me a good starting point? maybe a script or something that can perform the action for me ??? ax -- PHP Database Mailing List (http

RE: [PHP-DB] MySQL: Alphabetizing title results in library format

Have you tried it like this: mysql> select case when title like '%The %' then substring (title, 5, 255) when title like '%A %' then substring (title, 3, 255) when title like '%An %' then substring (title, 4, 255) else title end as sort_col from titles order by sort_col; I can't tested, but that's

Re: [PHP-DB] MySQL: Alphabetizing title results in library format

Cami wrote: > Try this: > mysql> select *,(case when title like '%The%' then substring (title, 5, 255) > when title like '%A%' then substring (title, 3, 255) when title like '%An%' > then substring (title, 4, 255) else title end) as sort_col from titles order > by sort_col; Argh, that still prod

RE: [PHP-DB] MySQL: Alphabetizing title results in library format

Hi Ian, Try this: mysql> select *,(case when title like '%The%' then substring (title, 5, 255) when title like '%A%' then substring (title, 3, 255) when title like '%An%' then substring (title, 4, 255) else title end) as sort_col from titles order by sort_col; Hope it helps, Cami -Original Me

Re: [PHP-DB] MySQL: Alphabetizing title results in library format

Petr Tuma wrote: > What error message it produce? Ok, table titles is composed of: +--+-++ | titlesid | releaseyear | title | +--+-++ mysql> select *,(case when title like 'The %' then substring (title, 5, 255) wh

[PHP-DB] Sql with Sybase variables @@

Hi, Is the following possible: $conn = sybase_connect("SERVER,"login","passwd"); $sql = "select @@version"; $result = sybase_query($sql,$conn); while($row = sybase_query($result)) { $r = $row[0]; echo "$r"; } I tried but get a strange error message that I dont understand, what wou