[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 would be

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)

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

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 produces

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

[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

[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

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

[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

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,

[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 I

[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

[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,

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

[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 prompt)

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

[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

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

[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.

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 version

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

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

I would think that you can't use '?' nad '?' special tags in the eval function (at least use only one of it). Try this ?php eval(?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