[PHP-DB] Thank you for your help!

2003-10-09 Thread Trisha
Thanks for all of your responses :) Unfortunately, I could not telnet into the server, nor could I do the mysql_connect command to get into the old server. I ended up calling the hosting company today to find out if they would be willing to create a dump for me, since they had been unresponsive

[PHP-DB] REGEXP and Variables.

2003-10-09 Thread Shannon Doyle
Hi People, Need a little assistance with the following MySQL query:- $query = SELECT employ_id,company FROM employers WHERE employ_id REGEXP '($employ_id)' OR company REGEXP '($name)' OR industry REGEXP '($industry)'; The above query gets the variables $employ_id, $name and $industry from a

Re: [PHP-DB] REGEXP and Variables.

2003-10-09 Thread Ignatius Reilly
Can't you do without REGEX? eg WHERE employ_id = '($employ_id)' OR company LIKE '($name)' REGEXes are expensive. Ignatius _ - Original Message - From: Shannon Doyle [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:18 AM Subject:

[PHP-DB] Problem with SQL Anywhere 5.5 and PHP ODBC

2003-10-09 Thread Paul Ciba
Hi everybody, i have a problem with php 4.0 an Sql Anywhere 5.5. The Webserver (Apache), the database and PHP are all installed on the same server( win 2000). PHP is using ODBC to connect to the database. This works if no other programm using the ODBC-connection ! If i start a programm that use

[PHP-DB] REMOVE ME

2003-10-09 Thread Muzzamil
Pl remove me from this mailing list Thanks [EMAIL PROTECTED] php-db Digest 8 Oct 2003 19:41:35 - Issue 2071 Topics (messages 30898 through 30907): Re: Is it possible to access MySQL table on server A from server B? 30898 by: ramki 30900 by: Cesar Schneider My SQL

Re: [PHP-DB] REMOVE ME

2003-10-09 Thread Mac Intyre, Steven
go to news.php.net and subscribe your self. On 9 Oct 2003 at 15:47, Muzzamil wrote: Pl remove me from this mailing list Thanks [EMAIL PROTECTED] php-db Digest 8 Oct 2003 19:41:35 - Issue 2071 Topics (messages 30898 through 30907): Re: Is it possible to access MySQL

Re: [PHP-DB] REMOVE ME

2003-10-09 Thread Mac Intyre, Steven
http://www.php.net/mailing-lists.php even On 9 Oct 2003 at 15:47, Muzzamil wrote: Pl remove me from this mailing list Thanks [EMAIL PROTECTED] php-db Digest 8 Oct 2003 19:41:35 - Issue 2071 Topics (messages 30898 through 30907): Re: Is it possible to access MySQL table

[PHP-DB] MySQL Regular expression

2003-10-09 Thread O Franssen
I'm not a 100% sure if this is the correct list for the following question, so I shall apologise beforehand if I upset any one. Now, I have a field in my database table in the following format: 100,30,443, etc. Representing prices for 52(53) weeks of the year and comma delimited. Now I need to

Re: [PHP-DB] MySQL Regular expression

2003-10-09 Thread Ignatius Reilly
Problem is, REGEX will only test for a match, not returning anything other than 0|1 You can instead: 1. Use a UDF doing just that (counting occurences in a string): http://www.tsc.ro/free/ (haven't tried it myself, because no Windows dll available) 2. Replace successively all figures by '' and

Re: [PHP-DB] MySQL Regular expression

2003-10-09 Thread Rory McKinley
Hi Owen You can actually do it in MySQL..using the SUBSTRING_INDEX function - SUBSTRING_INDEX(str,delim,count) If your count is positive, SUBSTRING_INDEX returns everything to the left of the count occurence of the delimiter (counting from left) If count is negative, SUBSTRING_INDEX returns

[PHP-DB] My SQL update one table, using reference from another...

2003-10-09 Thread Tristan . Pretty
I've been asked to add a field to a download capture sstem I've got. I've two tables, one that contains all the individual files info ('single_file'), and one that records the downloads ('completed_downloads'). All good... I've been asked to add a file_category (article, brochure, exe etc...)

[PHP-DB] Re: Getting last insert id?

2003-10-09 Thread pete M
$new_id = mysql_query('select last_insert_id()'); your can also user it within a query - eg $sql = ' insert into related table parent_id, data , data2) values (last_insert_id(), 23, 45); pete hris Payne wrote: Hi there everyone, I use the below to insert some data into my database:

[PHP-DB] RE: REGEXP and Variables.

2003-10-09 Thread Jeremy Shovan
-Original Message- From: Shannon Doyle [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:19 AM To: [EMAIL PROTECTED] Subject: REGEXP and Variables. Hi People, Need a little assistance with the following MySQL query:- $query = SELECT employ_id,company FROM employers WHERE

Re[2]: [PHP-DB] MySQL Regular expression

2003-10-09 Thread O Franssen
Actually in response to my previous comment, would the following achieve wwhat I want? ... and strcmp('$foot_budget', substring_index(substring_index(rates, ',', $selecteddate), ',', -1)) = -1 and strcmp('$head_budget', substring_index(substring_index(rates, ',', $selecteddate), ',', -1)) = 1

Re: [PHP-DB] mysql_error() (was Re: Getting last insert id?)

2003-10-09 Thread pete M
http://www.php.net/manual/en/function.mysql-error.php Ben Edwards wrote: On Thu, 2003-10-09 at 16:33, pete M wrote: $new_id = mysql_query('select last_insert_id()'); your can also user it within a query - eg $sql = ' insert into related table parent_id, data , data2) values

[PHP-DB] {OFF]

2003-10-09 Thread João Cândido de Souza Neto
Please, anybody know any news about javascript? Thanks for all. -- João Cândido de Souza Neto - [EMAIL PROTECTED] Mr. Mídia Propaganda e Marketing - www.mrmidia.com.br Farol Sul de Minas - www.farolsuldeminas.com.br Farol News - www.farolnews.com.br (35) 3212-4291 -- PHP Database Mailing List

Re[2]: [PHP-DB] MySQL Regular expression

2003-10-09 Thread O Franssen
-- Regards, Owen Franssen Twisted Designmailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] MySQL Regular expression

2003-10-09 Thread O Franssen
This almost worked :p I applied your suggestion in the following way: select * from ihrproperties where region = 'Kerry' and 0 substring_index(substring_index(rates, ',', 41), ',', -1) 1568 But of course my prices are saved as text so is there a way to type cast the result of the

[PHP-DB] ODBC to MSSQL on FreeBSD for PHP

2003-10-09 Thread rick rice
What do I need and where can I get it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Parse Errors...

2003-10-09 Thread NIPP, SCOTT V (SBCSI)
I keep receiving a parse error every time I try and view the page I am working on. I am developing this very simple application in DreamWeaver MX 2004. Here are lines 3-16: ?php mysql_select_db($database_Prod, $Prod); $query_Host = SELECT Name FROM systems; $Host =

Re: [PHP-DB] Parse Errors...

2003-10-09 Thread Micah Stevens
What line is the parse error on? On Thu October 9 2003 12:01 pm, NIPP, SCOTT V (SBCSI) wrote: I keep receiving a parse error every time I try and view the page I am working on. I am developing this very simple application in DreamWeaver MX 2004. Here are lines 3-16: ?php

[PHP-DB] pass by reference

2003-10-09 Thread Jeremy Shovan
How do you pass by reference? I tried $var = myFunction($var1, $var2); but it gave me a warning saying that pass by reference is depreciated

Re: [PHP-DB] pass by reference

2003-10-09 Thread Chris Boget
How do you pass by reference? I tried $var = myFunction($var1, $var2); but it gave me a warning saying that pass by reference is depreciated function myFunction( $var1, $var2 ) { } You now have to do it in the function definition, not the function call. Chris -- PHP Database Mailing List

Re: [PHP-DB] pass by reference

2003-10-09 Thread Jennifer Goodie
How do you pass by reference? I tried $var = myFunction($var1, $var2); but it gave me a warning saying that pass by reference is depreciated Call time pass by refrence is depreciated you should read the manual to see how it should be done.

Re: [PHP-DB] pass by reference

2003-10-09 Thread Ignatius Reilly
Specify it only at function definition: myFunction( $var1, $var2 ) { // ... } $var = myFunction( $var1, $var2 ) ; Ignatius _ - Original Message - From: Jeremy Shovan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 9:54 PM Subject:

Re: [PHP-DB] ODBC to MSSQL on FreeBSD for PHP

2003-10-09 Thread Robert Twitty
You should use the mssql extension for this purpose. Another alternative is odbtp. -- bob On Thu, 9 Oct 2003, rick rice wrote: What do I need and where can I get it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database

[PHP-DB] Hyperlinking to a new page

2003-10-09 Thread Shiloh Madsen
Ok, I know this should be easy, but im just blanking on how to do it. I have a webpage where you put in a city name, and it queries a database of all the cities in the US and brings back all cities matching that name. This part works just fine. What I want to do now is to create a hyperlink for

Re: [PHP-DB] Hyperlinking to a new page

2003-10-09 Thread Jordan S. Jones
a href=/location/to/page.php?city_id=2342343City Name/a Shiloh Madsen wrote: Ok, I know this should be easy, but im just blanking on how to do it. I have a webpage where you put in a city name, and it queries a database of all the cities in the US and brings back all cities matching that name.

Re: [PHP-DB] Hyperlinking to a new page

2003-10-09 Thread Rob
I believe what you want to do is just add the variable onto the URL, like this... script.php?variable or script.php?variablevariable Does that help? Thanks, Robert Gillen http://www.GifArt.com - Original Message - From: Shiloh Madsen To: [EMAIL PROTECTED] Sent: Thursday,

Re: [PHP-DB] Hyperlinking to a new page

2003-10-09 Thread Rob
Sorry I made a little mistake in my reply. Here is the correct syntax for what I think will work for you... script.php?variable=1 or script.php?variable=1variable=2 Thanks, Robert Gillen http://www.GifArt.com - Original Message - From: Rob To: Shiloh Madsen ; [EMAIL

Re: [PHP-DB] Hyperlinking to a new page

2003-10-09 Thread Cal Evans
script.php?key=valuekey=valuekey=value i.e. http://www.yourserver.com/yourscript.php?city=mobilestate=al or http://www.yourserver.com/yourscript.php?cityid=666 This will allow you to use $_REQUEST['city'] in the page you are calling to retrieve the city from the first example. You can also use

Re: [PHP-DB] Hyperlinking to a new page

2003-10-09 Thread Jordan S. Jones
Yes.. J Shiloh Madsen wrote: actually theres a problem with this, the page returned usually has several returns in it, so i cant hand code the id in there, will it work to do page.php?city_id=$city_id? - Original Message - From: Jordan S. Jones [EMAIL PROTECTED] To: Shiloh Madsen

[PHP-DB] CONGRATULATIONS You Win

2003-10-09 Thread Francis Weeny
SUNSWEETWIN PROMO LOTTERY,THE NETHERLANDS. ALFONSTRAAT B56, 1002 BS AMSTERDAM, THE NETHERLANDS. TO THE MANAGER FROM: THE DESK OF THE PROMOTIONS MANAGER, INTERNATIONAL PROMOTIONS/PRIZE AWARD DEPARTMENT, REF: OYL /26510460037/02 BATCH: 24/00319/IPD ATTENTION: RE/ AWARD NOTIFICATION; FINAL NOTICE We

[PHP-DB] [SPAM?] [PHP-DB] CONGRATULATIONS You Win

2003-10-09 Thread Francis Weeny
This mail is probably spam. The original message has been attached along with this report, so you can recognize or block similar unwanted mail in future. See http://spamassassin.org/tag/ for more details. Content preview: SUNSWEETWIN PROMO LOTTERY,THE NETHERLANDS. ALFONSTRAAT B56, 1002 BS

Re: [PHP-DB] mysql_error() (was Re: Getting last insert id?)

2003-10-09 Thread Ben Edwards
On Thu, 2003-10-09 at 16:33, pete M wrote: $new_id = mysql_query('select last_insert_id()'); your can also user it within a query - eg $sql = ' insert into related table parent_id, data , data2) values (last_insert_id(), 23, 45); Is there also a similar way of getting the last error

Re: [PHP-DB] Php433 running on RedHat73 with support to OCI8

2003-10-09 Thread Michael Mauch
Christopher Jones wrote: Adriano Rocha wrote: I'm running Linux RedHat7.3 with PHP 4.3.3. root # ./configure --with-oci8 (no errors) root # make (no errors) root # make install (no errors) ... it does not create the oci8.so file. That's perfectly normal. --with-oci8 configures for