[PHP-DB] Re: how to call a stored procedure in SQL Server 2000

2002-12-27 Thread Radovan Radic
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));

[PHP-DB] Re: how to call a stored procedure in SQL Server 2000

2002-12-27 Thread thien
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

[PHP-DB] Newbie q: problem with mysql_connect() on hosted service

2002-12-27 Thread Baumgartner Jeffrey
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 =

Re: [PHP-DB] Newbie q: problem with mysql_connect() on hosted service

2002-12-27 Thread Rick Widmer
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

[PHP-DB] A newbie in deep need for help

2002-12-27 Thread Ehab El Maraghy
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;

[PHP-DB] a newbie in deep need for help

2002-12-27 Thread Ehab El Maraghy
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

RE: [PHP-DB] A newbie in deep need for help

2002-12-27 Thread Rich Hutchins
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

[PHP-DB] What is a wrong parameter count error mean?

2002-12-27 Thread Jody Cleveland
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

Re: [PHP-DB] What is a wrong parameter count error mean?

2002-12-27 Thread Jeffrey_N_Dyke
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.

RE: [PHP-DB] What is a wrong parameter count error mean?

2002-12-27 Thread Rich Hutchins
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

Re: [PHP-DB] A newbie in deep need for help

2002-12-27 Thread Ehab El Maraghy
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 ?

[PHP-DB] Help with FTP

2002-12-27 Thread Dankshit
Is there a way to see how much space is left in a ftp server? thanks in advance!

Re: [PHP-DB] Help with FTP

2002-12-27 Thread Adam Williams
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! --

Re: [PHP-DB] a newbie in deep need for help

2002-12-27 Thread janet
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

RE: [PHP-DB] A newbie in deep need for help

2002-12-27 Thread Rich Hutchins
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

[PHP-DB] Upload Images...

2002-12-27 Thread Doug Coning
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

Re: [PHP-DB] A newbie in deep need for help

2002-12-27 Thread Ehab El Maraghy
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

RE: [PHP-DB] Upload Images...

2002-12-27 Thread Boaz Yahav
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

Re: [PHP-DB] a newbie in deep need for help

2002-12-27 Thread John Coder
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 =

Re: [PHP-DB] Upload Images...

2002-12-27 Thread Doug Coning
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]

RE: [PHP-DB] Upload Images...

2002-12-27 Thread Aaron Wolski
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

RE: [PHP-DB] a newbie in deep need for help

2002-12-27 Thread Rich Hutchins
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

[PHP-DB] calendar system

2002-12-27 Thread Edward Peloke
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,

[PHP-DB] Flow diagrams

2002-12-27 Thread Sridhar Moparthy
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

RE: [PHP-DB] Upload Images...

2002-12-27 Thread Boaz Yahav
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

RE: [PHP-DB] postgresql vs mysql

2002-12-27 Thread Boaz Yahav
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

RE: [PHP-DB] postgresql vs mysql

2002-12-27 Thread John W. Holmes
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

[PHP-DB] Re: crosstab for MS SQL

2002-12-27 Thread MWCT - Markus Weber
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

Re: [PHP-DB] postgresql vs mysql

2002-12-27 Thread Yasuo Ohgaki
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

Re: [PHP-DB] postgresql vs mysql

2002-12-27 Thread Garry Climacosa
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

[PHP-DB] Re: calendar system

2002-12-27 Thread Manuel Lemos
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

[PHP-DB] Re: Flow diagrams

2002-12-27 Thread Manuel Lemos
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

RE: [PHP-DB] postgresql vs mysql

2002-12-27 Thread John W. Holmes
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

Re: [PHP-DB] postgresql vs mysql

2002-12-27 Thread Yasuo Ohgaki
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

[PHP-DB] image size

2002-12-27 Thread Petre NICOARA
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

RE: [PHP-DB] image size

2002-12-27 Thread John Coder
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