i found that even i have not the php.ini in my SYSTEMROOT, php can still run
... why?
For window XP, should it be placed in c:/WINDOWS? or any other ?
thx for answer!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
If this is the right forum, can anyone tell me if I can post a form to two
addresses. I'd like to submit the results of a form to both a mailing list
and a MySql table. Thank you.
Frank Carotenuto, D.D.S.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
, Ingres II 2.5
I hope there's anyone can help me.
thanks
Frank Pietsch
--
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]
yves,
Start the transaction with ibase_trans() before you call ibase_execute.
As to how is it possible, I don't really know for sure. I would presume it
has to do with how Interbase handles transactions.
Frank
--
Franklin J. Balak Jr.
Quality Assurance Data
you're using MS SQL but as I've said each application can be
different and have its own unique needs.
Good Luck,
Frank
Well,
My Site runs now on Solaris. Both the front end (Web Server / php code /
Apache) and the Database (Backend server).
We had some problems with Mysql and we don't find
server to reply.
Thanks in advance,
Frank[EMAIL PROTECTED]
--
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]
and then it's a simple
join to your fact table.
Good Luck,
Frank [EMAIL PROTECTED]
On 1/29/02 9:21 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Garry Optland [EMAIL PROTECTED]
Date: Tue, 29 Jan 2002 19:10:25 +1100 (EST)
To: [EMAIL PROTECTED]
Subject: Date operations.
Hi All,
I
On 1/31/02 11:48 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: DL Neil [EMAIL PROTECTED]
Reply-To: DL Neil [EMAIL PROTECTED]
Date: Fri, 1 Feb 2002 16:28:16 -
To: Frank Flynn [EMAIL PROTECTED], [EMAIL PROTECTED], Garry Optland
[EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Date
one field and more work for you - and it will always
work.
Good Luck,
Frank
On 2/1/02 12:42 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Peter Lovatt [EMAIL PROTECTED]
Date: Fri, 1 Feb 2002 08:09:56 -
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Ensuring users
to be one - but there isn't). As
for using a DELETE and then an INSERT statement - that's just about as much
work for the DBMS as an UPDATE.
Good Luck,
Frank
On 2/4/02 6:30 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Miles Thompson [EMAIL PROTECTED]
Date: Mon, 04 Feb 2002 14:20:29 -0400
you want with the date.did and data */
$did = odbc_result($res2,1);
$data = odbc_result($res2,2);
}
}
Not so messy, No?
Good Luck,
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
set
to My Name inside of each form.
Good Luck,
Frank
From: [EMAIL PROTECTED]
Date: Mon, 11 Feb 2002 05:27:57 EST
To: [EMAIL PROTECTED]
Subject: Forms carrying values.
Hi list, hope someone can help me here.
I have content management system I have designed. I am still learning php so
in MySQL (MySQL
is a little weak with sub-queries). Even if that command fails you can walk
the list by selecting the cardnumber and doing a for each loop inside of PHP
- this would take a little longer but it would give you valid results.
Good Luck,
Frank
On 2/19/02 6:16 PM, [EMAIL PROTECTED
to only have one date column if $start == $end
if you wanted to do this - PHP couldn't care less about 'square' results.
Good Luck,
Frank
On 2/19/02 6:16 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Rod Wilkinson [EMAIL PROTECTED]
Date: Wed, 20 Feb 2002 08:09:46 +0700
To: [EMAIL PROTECTED
be made (which is what you want).
Good Luck and get back to work on your own Theses...
Frank
On 2/20/02 6:46 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Beau Lebens [EMAIL PROTECTED]
Date: Thu, 21 Feb 2002 09:59:21 +0800
To: PHP DB (E-mail) [EMAIL PROTECTED]
Subject: SELECT where
.
Personally I like to leave it printing $query until I've got all the code
working well and am polishing us the App.
It's hard to tell what you're sending to the DB as we don't know what's in
$user_deposit and how PHP is interpreting it. Print out $query - that's
where the beef is anyway...
Frank
On 2
and re-run if the first finds nothing.
Good Luck,
Frank
On 2/24/02 10:19 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Jonathan Underfoot [EMAIL PROTECTED]
Date: Sun, 24 Feb 2002 13:35:43 -0500
To: [PHP-DB] [EMAIL PROTECTED]
Subject: The Debacle
I'm putting together a table
is not NULL - be sure you blank fields are NULL and not
- A clever way to search for both and NULL in the same query is:
SELECT * FROM foo WHERE NOT bar
This may not work in all DBMS's but give it a try; OR would work too.
Good Luck,
Frank
On 2/26/02 2:20 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED
Well off the top I'd say your forgot the join condition between the
fo_topics and the fo_forums tables. Right now you're counting the Cartesian
product of the two tables.
Also you can't select an aggregate function (like count) and regular columns
without a group by on the same columns.
F
on
children invalid and come back later).
This can be particularly useful when you want to put up a results page
quickly.
Just a thought.
Frank
On 3/4/02 5:49 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Aron Pilhofer [EMAIL PROTECTED]
Reply-To: Aron Pilhofer [EMAIL PROTECTED]
Date: Mon
easier, right?
Good Luck,
Frank
On 3/7/02 4:40 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Andy [EMAIL PROTECTED]
Reply-To: Andy [EMAIL PROTECTED]
Date: Fri, 8 Mar 2002 01:06:09 +0100
To: [EMAIL PROTECTED]
Subject: counting of values in one field possible with one sql statement
the stories should defiantly be on
a different Front End - perhaps not that powerful if money's an issue but
having it separate reduces the chances that something on that box (an
Upgrade, bug or even an editor doing something unusual) would bring down the
whole site.
Good Luck,
Frank
On 3/10/02 8:23
mind getting them back multiple times).
I know this will work in all the big ones (Oracle, MS SQL, IBM) but I'm less
sure about MySQL as I don't use it all that much. This is standard SQL.
Good Luck,
Frank
On 3/18/02 10:53 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Summit [EMAIL
you will have two different records in the address table - identical except
for the authority field.
Easy as pie...
Good Luck,
Frank
On 3/22/02 8:25 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Ljungan [EMAIL PROTECTED]
Date: Fri, 22 Mar 2002 18:07:06 +0100
To: [EMAIL PROTECTED
See below...
On 3/23/02 2:20 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Ljungan [EMAIL PROTECTED]
Date: Sat, 23 Mar 2002 11:17:15 +0100
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] marking DB entries...
Thanks Frank!
Just to be certain, cant I
If two users enter the same
trying to do.
Good Luck,
Frank
Regards Raymond
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
of the address would be useful I suppose and I
clearly need to spot user error like a value over 255.
Is there anything out there that I might use or at least look at for ideas?
Thanks
Frank [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
not using an index
properly.
Good Luck,
Frank
From: Lisi [EMAIL PROTECTED]
What exactly does it mean when a table becomes fragmented? How do you know
when it's happened and something should be done? All the docs and books
talk about how bad it is but I'm still confused on what this is and when
but for MySQL it's:
SHOW TABLE STATUS FROM ... LIKE ...
In MS SQL it's:
sp_spaceused ...
In Informix it's:
onstat (-something I forget which but there help in onstat)
I forget Oracle but it's somewhere in the Enterprise manager...
Good Luck,
Frank
--
Frank Flynn
Poet, Artist Mystic
and the ODBC stuff will do everything you
need anyway. It worked first time and every time since for me.
Good Luck,
Frank
On 4/19/02 1:54 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
-Original Message-
From: Rob Fraser [mailto:[EMAIL PROTECTED]]
Sent: 19 April 2002 08:44
To: [EMAIL PROTECTED
and .htpasswd
files but I'm not sure yet...
Can anyone suggest the best way to protect my database? If it is to
complicated to be explained in an email please suggest just the functions
names and I'll try to find the way...
Thanx
Achilles
--
Frank Flynn
Poet, Artist Mystic
--
PHP Database
/ but I expect you've already fount that.
-I don't remember what ODBC driver I'm using but it just worked and I've
never needed to mess with it since installing it.
Good luck,
Frank
From: Robert Webb [EMAIL PROTECTED]
Date: Fri, 26 Apr 2002 10:23:11 -0400
To: [EMAIL PROTECTED]
Subject: Newbie
This would make the query only return the 5, 3 row.
Good Luck,
Frank
On 5/1/02 12:24 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Dave Carrera [EMAIL PROTECTED]
Date: Wed, 1 May 2002 13:02:51 +0100
To: [EMAIL PROTECTED]
Subject: Count and group ?
Hi All
I have added a row to my
an aggregate for this to work) See also GROUP BY
Good luck,
Frank
From: César L. Aracena [EMAIL PROTECTED]
Date: Tue, 21 May 2002 01:49:28 -0300
To: PHP DB List [EMAIL PROTECTED]
Subject: Adding totals
Hi all,
Is there a way for me in PHP4 to add all the contens (floating numbers
page. If it's significantly slower try inserting timestamps between the
blocks of code so you can tell what's taking so long (it may not be the
DB at all).
Good Luck,
Frank
On 5/30/02 10:31 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Leif K-Brooks [EMAIL PROTECTED]
Date: Thu, 30
is something like $15,000 per CPU
for the Standard Edition and $40,000 per CPU for Enterprise Edition.
MS and IBM's offerings are cheaper but still quite expensive.
Good Luck,
Frank
On 5/31/02 12:13 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Craig Williams [EMAIL PROTECTED]
Date: Fri
? It violates one of the
rules of good DB design (having identical information in more than one
place). I'll bet there's a better way to do what you're trying to do here.
Frank
On 5/31/02 12:13 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Leif K-Brooks [EMAIL PROTECTED]
Date: Fri, 31 May 2002
in tact for performance and only rebuild
it after you modify any of the values in the original table.
Feel free to write back if you have more questions.
Good luck,
Frank
On 6/9/02 6:18 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: SP [EMAIL PROTECTED]
Date: Sat, 8 Jun 2002 20:09:22
Hi I made this.
?
//config.php
$sqlhost = localhost;
$sqluser = root;
$sqlpasswd = password;
$sqldatabase = project;
?
?
//sqlclass.php
require('config.php');
class Connect {
var $link;
function Connect() {
$this-link = mysql_connect($sqlhost,$sqluser,$sqlpasswd);
$select =
try this.
?php
$sqlhost = localhost;
$sqluser = root;
$sqlpasswd = password;
$sqldatabase = test;
//using pconnect to stay connect all the time to
//close the connect use mysql_close($link);
$link = mysql_pconnect($sqlhost,$sqluser,$sqlpasswd);
mysql_select_db($sqldatabase);
?
- Original
server);
}
mysql_select_db($sqldatabase);
}//end of function connect
}//end of class
?
than to call the link I just did.
$class = new Connect;
$class-link;
So anybody want more info on how to use this class I made email me at
[EMAIL PROTECTED]
cheers :)
Frank Mancuso [EMAIL PROTECTED
If I have a database x with populated tables and I would like to copy it
to another empty database for Testing purposes, how is that done through
phpMyAdmin?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Jeremy,
This question probably should be posted to the MySql mailing list but here
goes.
Take a look at this link:
http://www.mysql.com/doc/en/Where_optimisations.html
Your example was not very explicit so I am not sure, but I believe you are
in need of a
WHERE clause. For example;
Select a,
all the records
in ascending order so also not in random..
Regards,
Frank
Thanks guys for the info; I will speak to my ISP!
Have a nice weekend!
Regards,
Frank
- Original Message -
From: Rich Gray [EMAIL PROTECTED]
To: Frank Keessen [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 2:36 AM
Subject: [PHP-DB] RE: [PHP] Random
.
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi David,
Try this one:
?
function formatDate($val)
{
setlocale (LC_ALL, '');
$arr = explode(-, $val);
return strftime (%A %e %B %Y, mktime (0, 0, 0, $arr[1], $arr[2],
$arr[0]));
}
echo formatDate($DatePick);
?
Regards,
Frank
- Original Message -
From: David Shugarts [EMAIL
from right now). Is this possible? If so, how. Thanks for the
help.
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-recursive] Error 1
make[2]: Leaving directory `/usr/local/php4/php-4.2.2/ext/interbase'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/php4/php-4.2.2/ext'
make: *** [all-recursive] Error 1
i see an error, but i dont now what i must do.
Can anybody help me?
Thank you.
Frank
Subscribe digest
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
*/
echo result[classDescription]
/* don't forget to reset this */
$thisClassID = result[classID];
}
/* now display the section info... */
Good Luck,
Frank
On 2/17/04 9:49 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: mayo [mailto:[EMAIL PROTECTED
button only needs to store the web_user value and the number
of the row you're on now. If you need some sample code I can send you some
but really it's pretty straight forward in the PHP side.
Good Luck,
Frank
--
Frank Flynn
Poet, Artist Mystic
--
PHP Database Mailing List (http
results if $_GET['search'] is very small like one
letter.
Good Luck,
Frank
On 2/24/04 8:20 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Nitin Mehta [EMAIL PROTECTED]
Date: Tue, 24 Feb 2004 13:18:24 +0530
To: [EMAIL PROTECTED], -{ Rene Brehmer }- [EMAIL PROTECTED]
Subject: Re: [PHP-DB] how
another query
Any idea
--
Frank Flynn
Poet, Artist Mystic
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Too true - this is why a page that I promised would only take a few minutes
winds up taking all week.
But it makes steady employment for the QA team...
Frank
On 2/24/04 10:37 AM, Andy Armstrong [EMAIL PROTECTED] wrote:
Frank Flynn wrote:
And if you'd like to make wild carding optional
face=Arial size=-1? echo($Description); ?/font/td
tdfont face=Arial size=-1? echo($Price); ?/font/td
?
}
?
Good Luck,
Frank
On 3/8/04 12:50 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Aleks @ USA.net [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Mon, 8 Mar 2004 15:50:01
a GROUP BY at all).
Good Luck,
Frank
On 3/22/04 9:09 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
Date: Mon, 22 Mar 2004 18:12:35 +0100
To: [EMAIL PROTECTED]
Subject: Looking for simpler way to do this...
I'm working with PHP 4.3.0 w. MySQL 4.0.14b
(varchar, getdate(), 102)
Then change the . for - and change the getdate() for your date column.
Good Luck,
Frank
From: charalambos nicolaou [EMAIL PROTECTED]
Date: Thu, 06 May 2004 13:13:27 +0300
To: [EMAIL PROTECTED]
Subject: Insterting date in an MySQL table
Hi everyone,
I want to created
connections to 500 or so different MySQL servers? Any feedback
would be appreciated.
thanks
frank dziuba
a SELECT statement and the results
are put into this cursor and now you can run a loop of some kind on that
cursor.
Personally I can't remember the last time I used one, but I know I have used
one - I remember looking it up.
Frank
--
Frank Flynn
Poet, Artist Mystic
--
PHP Database Mailing List
The method doesn't matter, use whatever you like.
Did this quick just for the fun, it seems to work. Set $search to
whatever you'd like to try or to your GET or POST argument.
,,, eurpoe won't cause a problem but + + + europe will generate
some odd SQL (although it will work as expected -
to be ways of running it on Fedora
Core. I am using RH 7.3 because 7.2 was the last free distro identified and
I had it handy.
Zap me a mail if you need more info - news sites etc.
Cheers,
Frank.
* 1 CPU for the dataserver - you can run it on a multi cpu system with more
than 2 Gb RAM. In a dual CPU
).
-if there is an error what does the error look like? It should not
reveal anything about your data, database, structure,
Good Luck,
Frank
On Oct 4, 2004, at 7:31 PM, [EMAIL PROTECTED] wrote:
From: Stuart Felenstein [EMAIL PROTECTED]
Date: October 4, 2004 1:28:04 PM PDT
To: [EMAIL PROTECTED]
Subject: Multi
long) could you tolerate loosing?
It's a kind of interesting discussion and the only wrong answers are
not to back up and perhaps to back up to the same disk if you want to
be able to recover. But if you answer these questions we'll give you
some options.
Frank
On Oct 27, 2004, at 6:57 AM, Perry
/31/69.
What am I doing wrong?
Thanks,
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Ramil and Jochem,
Having mySQL format the date is the best solution... thanks!
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
INTO newTable (column1, column2, ...)
SELECT column1, column2, ... FROM oldTable WHERE column3 some
date /* or whatever */
DELETE FROM oldTable WHERE column3 some date /* or whatever */
Be sure the two where clauses match exactly.
Good Luck,
Frank
On May 19, 2005, at 3:28 PM, [EMAIL PROTECTED] wrote
FROM purchaseItems WHERE orderID = '789' and itemIDs =
whatever
Good Luck,
Frank
On May 20, 2005, at 5:02 PM, [EMAIL PROTECTED] wrote:
From: mayo [EMAIL PROTECTED]
Date: May 20, 2005 4:45:05 PM PDT
To: 'Miguel Guirao' [EMAIL PROTECTED], php-
[EMAIL PROTECTED]
Subject: RE: [PHP-DB] multiple
Philip Wasshington wrote:
[snip]
After installing php-4.3.9-3.6.src.rpm on RHEL4 I modified the
php.spec file to
add --with-sybase-ct=/opt/sybase/OCS-12_5
Try adding --with-apxs as well!
Cheers, Frank.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
=
therowkey')
Cheers, Frank.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
that belong to the right hand table will be
NULL where there is no row to join to).
But if you could be more specific - send the schema and precisely
what you were looking to do I could give you an example of how to
make it work.
Good Luck,
Frank
On Sep 1, 2005, at 5:00 AM, [EMAIL PROTECTED
of mySQL 'view' will be a reserved
word (and views will be supported). This is not causing your problem
but you do want to choose another name for your table.
Good Luck,
Frank
On Sep 19, 2005, at 11:25 AM, [EMAIL PROTECTED] wrote:
From: Yui Hiroaki [EMAIL PROTECTED]
Date: September 19, 2005 11
not be there (http:/mysql.com/ is like this - type anything after
that URL and it will go to that page if it finds it or it will go to
the generic search page).
You've got a lot of work in front of you, Good Luck,
Frank
fine for what your after.
Good Luck,
Frank
On Dec 10, 2005, at 5:02 PM, [EMAIL PROTECTED] wrote:
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Date: December 10, 2005 5:04:28 PM PST
To: PHP DB php-db@lists.php.net
Subject: SELECT
Reply-To: [EMAIL PROTECTED]
I am trying to put together a SELECT
) depending on how deep you want to get.
Good Luck,
Frank
On Jan 6, 2006, at 2:45 PM, [EMAIL PROTECTED] wrote:
From: swoll2 [EMAIL PROTECTED]
Date: January 6, 2006 3:34:52 AM PST
To: php-db@lists.php.net
Subject: retaining and displaying line returns in a text field
Good morning -
I'm trying to get
withstand. BTW you prolly won't get any insurance of this
risk unless you are prepared to pay a big premium - which defeats the
purpose!
Others no doubt will be able to add more control layers - these are just
what first comes to mind in a few minutes.
Bon voyage!
Frank.
--
PHP Database Mailing List
If you only have Wednesdays in you table - that is select the next 12
records after today it's easy:
SELECT * FROM christian_discipleship WHERE created_for_date now()
ORDER BY created_for_date ASC LIMIT 12
Good luck,
Frank
On Oct 6, 2006, at 8:29 PM, [EMAIL PROTECTED] wrote:
I am
where concat(user, '@', host) like
(select CURRENT_USER())\G
That worked for me, I'm sure you can go join to INFORMATION_SCHEMA and
do more exotic (more precise) things too.
Good Luck,
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
that store_by?
Good Luck,
Frank
On Aug 9, 2011, at 11:31 AM, php-db-digest-h...@lists.php.net wrote:
From: Chris Stinemetz chrisstinem...@gmail.com
Subject: foreign key
Date: August 9, 2011 11:31:51 AM PDT
To: php-db@lists.php.net
Okay. I am pretty new to mysql so this may seem like
on the same line. Other
than that it looks correct - what is the error?
Frank
From: Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com
Subject: mysqldump
Date: January 1, 2013 3:50:50 PM PST
To: PHP Database List php-db@lists.php.net
Reply-To: erosenb...@hygeiabiomedical.com
Dear
Or is there a better way to check multiple options against an enum inside
your select statement?
IN
for example: orderstatus IN ( 'Cancelled', 'New', 'Denied', 'Expired')
However this is not exactly what you are doing. You want different orderdate
$yesterday depending on the orderstatus.
MSSQL does not have complete the same functions. You can use SELECT TOP 10.
You could also define mssql.batchsize in php.ini. This way php only reads the
specified number of rows. You can the use mssql_fetch_batch() to read batches of data
on the same query.
- Frank
Hi,
Having used
will need to restart the server for any
changes to kick in.
- Frank
Hi!
I have PHP4.05 and MSSQL7 desktop on Win2k.
Problem occurs when I query results contain some extended characters, for
example ä or similar. In place of these chars thaere are some
non-aphanumeric ones displayed like
on Windows.
- Frank
--
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]
What version of php are you using ?
Handling of binary data from MSSQL Server was changed from php4.0.5 to php4.0.6.
As far as I can tell You should not have any problems with php4.0.6
- Frank
I am preparing a report for a database at my company that will be shown on
the web. It has
mssql_* functions. You can
enable the mssql functions by uncommenting ;extension=php_mssql.dll in php.ini. This
requires that you are running on Windws and you install the client tools from MS SQL
Server on yor PHP box.
With ODBC and native MSSQL you can access remote or local databases.
- Frank
Hi Brad,
Your parameter is named $title and you are converting a variable called $input to an
array.
You could catch this type of errors if you change the setting for error_reportiong in
php.ini.
- Frank
can somebody help me with the following code:
function multi_word($title
are the lack of support for varchar, nvarchar columns larger than 256 bytes. This is a
limmitation in the C-library provided by Microsoft.
If you can use the Text type, this will not be a problem.
- Frank
Hello Everyone!!
We are making on the project with PHP4 and MSSQL7. Everything is based
. This
makes it difficult to create a native connection.
- Frank
You can try to modify the connect string because php's connect to database
through TCP/TP.
Tell me the result.
Graycloud [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello, My php is
Hi Adam,
Host name should not include the port number. If you need to use a non standard port
number you should create a client configuration (using client network utility) and
then use the name of the configuration as the host name.
- Frank
I have PHP running on Apache for win32
extension. It works with version 6.x, 7.x and 2000 but it does
not support all features of 7.0 and 2000.
- Frank
Has anybody succeeded in running PHP, using ODBC and the MS SQL Server
ODBC driver? If so, I can use some guidance.
Many thanks
Todd
--
Todd Cary
Ariste Software
Hi
Try to remobe 'DNS=' from the connect
$conn=odbc_connect(dnsname,userid,password);
should do the trick.
- Frank
Hi:
I'm trying to establish a connection with SQL 7.0.
My system runs W2000, Apache, PHP4. I created a DNS odbc file (with MS
Access) and checked that the connection
This problem has just been fixed in CVS.
- Frank
Hello!
How can I force PHP to fetch datetime field i 'mmdd hh:mm:ss' WITHOUT
using MSSQL query like *SELECT convert(varchar,dtfield,20) as 'dtfield'* and
so on?
I have a few tables on MSSQL with the different structures and some
Hi,
Depending on the database you are selecting from you could do it in one select like
this:
select category, count(*) from $table group by category order by category;
- Frank
How would you get the count of each category?
Like this - http://www.scriptsearch.com
Would you have to run
stuff.
So the MSSQL extension does not use (slow) ODBC to communicate with the server, but
jus a set of old libraries.
- Frank
The VARCHAR(255) bug is actually a limitation imposed by ODBC - so I
suspect the MSSQL library uses ODBC for communication with a SQLServer
installation. I've
.
- Frank
Hello,
I am trying to install gdlibrary on windows. Unfortunatelly this seams to be
too complicated. There are 3 components: zlib, pnglib and gdlibrary. All of
them seam to need to be compiled. I did not find binarys for win 2000. Does
anybody know a good description on how to install
the tools. One of the toiols is called Client Network
Utility. You can use this to specify aliases for your host names s[ your system knows
the protocol to use.
- Frank
P.S You also need to enable the mssql extension !
I have PHP on windows 2000 web server
I would like to remote to a MS SQL
--with-ibm-db2 and get the ODBC functions linked directly with CLI. This is not
currently available on Windows.
- Frank
To connect to Microsoft SQL 7 I'm using the following script which works
fine:
?php
$query=SELECT * FROM DB1;
$queryupd=UPDATE DB1 SET dateval='20010101' where dateval
with the SQL
Server, but this will not be available from a Linux/Unix box.
- Frank
Hi,
I ran into the same problem, but the problem I have is that I can't
switch to TEXT Datatype because MSSQL doesen't support SELECT DISTINCT
or GROUP BY on them. The Workaround:
SELECT CAST (fieldxyz AS TEXT
.
- Frank
BTW:
0 wasn't the right answer, but I get by with 10. :-)
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, May 15, 2002 4:27 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Text Field in SQL Server
I got it:
In php.ini there is a setting
1 - 100 of 163 matches
Mail list logo