I have sp like this in MSSQL
CREATE procedure dsp_ani_usage_period @from_date datetime, @to_date
datetime, @max_usage money
which does join select from some tables using these params for where
And i execute it from PHP
if(!isset($date_from))
{
$date_from=date(m/d/Y,strtotime(-1 month));
Thanks you Radovan and Frank very much
I highly appreciate your answer.
It helps me to solve my problem quickly.
thanks both of you agian
Radovan Radic [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have sp like this in MSSQL
CREATE procedure
Sorry to bother you experts with a simple question (well, two actually).
I'm new to PHP and mysql. I'm using a hosted service (so I don't have access
to configuration files, server, etc). Recently, the server crashed. Since
resurrecting, all files attempting to connect to MySQL using
$dbcnx =
At 10:45 AM 12/27/02 +0100, Baumgartner Jeffrey wrote:
Fatal error: Call to undefined function: mysql_connect() in
/home/.sites/22/site13/web/werks/formtest2.php on line 8
This means that MySQL is not enabled within PHP. There is nothing you can
do about it. The hosting company needs to
Hi everybody
I have installed php4 and mysql on IIs winxp
I am trying to retrieve a password and print it using a query which is written as
followos
$query2 = select passwd from user where username = '$username';
$result = mysql_result($query2);
echo centerBOld Password was $result /B/center;
Hi everybody
I have installed php4 and mysql on IIs winxp
I am trying to retrieve a password and print it using a query which is
written as followos
$query2 = select passwd from user where username = '$username';
$result = mysql_result($query2);
echo centerBOld Password was $result /B/center;
am
Nope. Use this statement:
$result = mysql_query($query2);
The mysql_query() function actually performs the query to the db for you and
returns a resource with your result set contained within.
The mysql_result() function extracts the contents of a given cell from your
result set; it does not
Hello all,
I'm trying to get a php application working that uses ldap. Anyway, when I
try to login, I get this error message:
Warning: Wrong parameter count for ldap_error() in
/var/www/html/mail/mail132/plugins/webcalendar/includes/user-ldap.php on
line 101
What exactly does that mean?
-Jody
the function takes a certian number of required arguments(or parameters)
and you're not passing enough. For this funtion it only takes one, which
is the ldap resource link identifier. which was probably set in $var =
ldap_connect(ldap_server). here the resource link identifer would be
$var.
Usually it means that you're not passing the expected number of arguments to a
function. For example, the substr() function takes a minimum of two, maximum of three
parameters: the string to search, the start position and the length of the substring
to return. To correctly use the function, you
Rich
thanx for answering
I did what you said yesterday before using mysql_resut it returns resource
id#3 didn't know what is it and how can i transform it it the data inside
the cell
i corrected the situation and i waited to give me res.id#3 but it doesn't
write anythingany suggestions ?
Is there a way to see how much space is left in a ftp server?
thanks in advance!
use system() to run /bin/df
depending on the OS you might need to add a flag to it like -h (linux) or
-k (solaris).
www.php.net/system
Adam
On Fri, 27 Dec 2002, Dankshit wrote:
Is there a way to see how much space is left in a ftp server?
thanks in advance!
--
In a message dated 12/27/02 8:26:10 AM Pacific Standard
Time, [EMAIL PROTECTED] writes:
I am trying to retrieve a password and print it using
a query which is
written as followos
$query2 = select passwd from user where username =
'$username';
$result = mysql_result($query2);
echo
Yes, first you use:
$result = mysql_result($query2);
That will return something like resourceID #3. That's right. What you need
to do now is to use a function to access the resource. For example, if you
have a table named User with the following columns:
ID
username
passwd
and you want to
Hi All,
I've got a question about creating an Update page. I have an update page
that has a form with about 15 fields in it that update records in my MySQL
database. One of the fields is an IMAGE field that stores an image name. I
want to this PHP page to do several things:
1) edit and update
man i have tried everything the sentece is always printed without the
variable
don't know what is happening
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm guessing it's better for the people that will use this page to have
it all in one page
but less convenient for you to develop it like that :)
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow.
-Original Message-
From: Doug Coning
On Fri, 2002-12-27 at 04:19, Ehab El Maraghy wrote:
Hi everybody
I have installed php4 and mysql on IIs winxp
I am trying to retrieve a password and print it using a query which is
written as followos
$query2 = select passwd from user where username = '$username';
$result =
Yes, but do you know where I can find a sample of merging the upload script
with the Update script?
Thanks!!!
Doug
- Original Message -
From: Boaz Yahav [EMAIL PROTECTED]
To: Doug Coning [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, December 27, 2002 1:09 PM
Subject: RE: [PHP-DB]
Write your own.
You'll spend more time trying to find something than it will take you to
create your own. Plus.. anything that you do find will need
modifications anyway so may as well write your own.
Define the scope/parameters
Write out the logic
Program the script
:)
Aaron
-Original
Aha! John, you're right. I remember stumbling over this the first time I
used it. Sorry for any confusion, Ehab.
More info here:
http://www.php.net/manual/en/function.mysql-result.php
-Original Message-
From: John Coder [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 2:09 PM
Hello all,
I need to create a basic calendar page for my office where people can post
their days off. All the data will be stored in the mysql db. Does anyone
know of any good code I an use to get me started? I have seen a lot online
of calendar systems but I just want something to start with,
Hi Every one,
I have information about some processes in the database that tells different
process dependencies. I need to display that information as a process flow
diagram. Do you know how to prepare and display process flow diagrams
dynamically. Do you know anything like JPGraph or Java script
Is there something you don't know how to do or are you just looking for
something ready made?
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow.
-Original Message-
From: Doug Coning [mailto:[EMAIL PROTECTED]]
Sent: Friday, December
This is why i was amazed to see this : http://www.mysql.com/eweek/index.html
-Original Message-
From: David Bryant [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 10:43 PM
To: 'Ryan Jameson (USA)'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] postgresql vs mysql
I've worked
I wish they had included PG on that list of databases. That would have
been good to see regardless of the results.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
-Original Message-
From: Boaz Yahav
Have you tried the MS Access Syntax ? - e.g.:
TRANSFORM Sum(cube_by_c.netc_bd) AS [Summe von netc_bd]
SELECT cube_by_c.pthr_product_c AS PROD_C, xref_prod.pthr_desc_x AS [DESC]
FROM cube_by_c LEFT JOIN xref_prod ON cube_by_c.pthr_product_c =
xref_prod.pthr_product_c
WHERE
This benchmark do not help much in real life, if one care database
performance.
Database performance will vary a lot with configuration/schema/query/etc.
It's very easy to make one is better while another is not.
I suggest to take benchmark by yourself with schema and query that
is similar to
i emailed the author (dyck timothy) of this article (server database clash)
by eweek he told me that they benchmark DB's according to market share that
is why they didnt included PG (not widely used).
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'Boaz Yahav' [EMAIL
Hello,
On 12/27/2002 06:20 PM, Edward Peloke wrote:
I need to create a basic calendar page for my office where people can post
their days off. All the data will be stored in the mysql db. Does anyone
know of any good code I an use to get me started? I have seen a lot online
of calendar
Hello,
On 12/27/2002 06:00 PM, Sridhar Moparthy wrote:
I have information about some processes in the database that tells different
process dependencies. I need to display that information as a process flow
diagram. Do you know how to prepare and display process flow diagrams
dynamically. Do you
This benchmark do not help much in real life, if one care database
performance.
Did you even read the article? They used a real-world bookstore
application called Nile written in JSP and tested it with 50 to 1,000
concurrent users.
Database performance will vary a lot with
John W. Holmes wrote:
This benchmark do not help much in real life, if one care database
performance.
Did you even read the article? They used a real-world bookstore
application called Nile written in JSP and tested it with 50 to 1,000
concurrent users.
Real life differs from systems to
Hi guys,
Do you know any methods or code for finding out the images width
height either with php or javascript
I have a little trouble manipulating the big images. Also, I don't keep
the images in the database, are files on a server.
Thanks,
Petre NICOARA
--
PHP Database Mailing List
Hi guys,
Do you know any methods or code for finding out the images width
height either with php or javascript
I have a little trouble manipulating the big images. Also, I don't keep
the images in the database, are files on a server.
look at
36 matches
Mail list logo
