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
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
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:
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
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
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
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
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
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
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
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...)
$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:
-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
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
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
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
--
Regards,
Owen Franssen
Twisted Designmailto:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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
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 =
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
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
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
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.
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:
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
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
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.
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,
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
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
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
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
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
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
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
36 matches
Mail list logo