Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Scott Haneda
Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: IMG SRC=thm.php?id=some_id ALT=some title thm.php use a mysql_connect to the database to access the info about the picture based on the id.

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Jørn Dahl-Stamnes
On Thursday 21 December 2006 11:03, Scott Haneda wrote: Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: IMG SRC=thm.php?id=some_id ALT=some title thm.php use a mysql_connect to the

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Scott Haneda
What you should do, is grab the 50 images ahead of time, in one select, and use some php to iterate them and display them. Second, your suggestion is not an option in my case, since the image and the thumbnails are not stored in the database. The database contain image id, image attributes

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Jørn Dahl-Stamnes
On Thursday 21 December 2006 11:28, Scott Haneda wrote: What you should do, is grab the 50 images ahead of time, in one select, and use some php to iterate them and display them. Second, your suggestion is not an option in my case, since the image and the thumbnails are not stored in the

Re: MySQL, PHP and Yahoo webhosting

2006-05-16 Thread Edward Vermillion
What does your script look like? Code? Ed On May 13, 2006, at 5:46 PM, Steve wrote: I'm fairly new to all this and duing everything step by step... I made my first (test) php site - and it works... then, i have this script where i'm supposed to find out if MySQL and PHP talk with each

Re: MySQL, PHP and Yahoo webhosting

2006-05-16 Thread Keith Roberts
Hi. call this function, phpinfo(); in a *.php file. That should return alot of usesfull info. Make sure the mysql extension is being loaded. If so check the value of the following php config var: ; Default socket name for local MySQL connects. If empty, ; uses the built-in ; MySQL defaults.

Re: mysql/php date functions..

2005-09-26 Thread gerald_clark
bruce wrote: hi... i've got a question/problem that i can't seem to figure out. it should be simple/straightforward. i'm creating a test tbl id int t1 timestamp when i do a 'select * from tbl' i get what looks like a default date/time format in the timestamp column. i do a, (from mysql)

Re: Mysql + PHP - Search

2005-01-31 Thread Matt Babineau
I just answered my own question actually! - snip from php.net - MySQL 4.0 supports a fabulous new feature that allows you to get the number of rows that would have been returned if the query did not have a LIMIT clause. To use it, you need to add SQL_CALC_FOUND_ROWS to the query, e.g.

Re: Mysql, php and unsubscribe or delete

2004-08-09 Thread Ludwig Pummer
My guess is that since your id field is not auto_increment and you're not specifying a value, all email addresses are getting an id of 0. Since your primary key is composed of both id and email, MySQL isn't complaining. [EMAIL PROTECTED] wrote: However, Problem application is giving me is in

Re: MySQL/PHP Tunneling

2004-07-10 Thread Eldon Ziegler
Karam, A much more secure way is to use OpenSSH (www.openssh.org) to create an encrypted connection between the local machine and the MySQL server and to use the -L option to forward MySQL commands from the localhost to the MySQL server. For example, ssh -l Login account URL or IP Address of

Re: [mysql-php] mysqlimport error

2004-06-09 Thread Egor Egorov
: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error

Re: [mysql-php] mysqlimport error

2004-06-07 Thread nikos
is that a problem? I want to avoid ftp db.txt files and then mysqlimport them - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying

Re: [mysql-php] mysqlimport error

2004-06-02 Thread Egor Egorov
nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What

Re: MySQL/PHP ?

2003-06-29 Thread Salam Baker Shanawa
Hi Ted, 1. Modify the query which presents all records by selecting let's say the peopleID. 2. When you build your update link you can use that ID to ask for a particular record. 3. Then you can use the same query + AND peopleID=THE_ID_OF_THAT_RECORD_EXTRACTED_FROM_THE_LINK. something like

Re: MySQL/PHP ?

2003-06-29 Thread Salam Baker Shanawa
[EMAIL PROTECTED] wrote: Thanks Salam, but a question: this would mean that I must do by hand every record ID link, no? I don't think you are building your master html page by hand, do you? No, of course no hand work. The script should take care of it e.g. in a loop while fetching the records

RE: mysql-php link failure

2003-06-16 Thread Grimes, Dean
? Thanks, Dean -Original Message- From: Boyd Lynn Gerber [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 4:03 PM To: Grimes, Dean Cc: '[EMAIL PROTECTED]' Subject: Re: mysql-php link failure On Fri, 13 Jun 2003, Grimes, Dean wrote: I'm having some trouble with linking mysql-4.0.13

RE: mysql-php link failure

2003-06-16 Thread Boyd Lynn Gerber
On Mon, 16 Jun 2003, Grimes, Dean wrote: Have you been able to compile Apache/MySQL/PHP successfully on SCO 5.0.6? If so, could you send me a listing of the patches you have installed? Yes, This is what I have on my system OSS629A: SCO HTTP Security Supplement (ver 1.0.0)

Re: mysql-php link failure

2003-06-13 Thread Boyd Lynn Gerber
On Fri, 13 Jun 2003, Grimes, Dean wrote: I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am getting following error: //usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1:

Re: Mysql / PHP image link problem.

2003-06-04 Thread Paul DuBois
At 19:20 +0100 6/3/03, Daniel Crompton wrote: I have a mysql table column called 'imagecolumn' The rows contain links i.e. image.gif image.gif null image.gif image.gif To display in my web page im using: img src=?php echo $row_Recordset1['imagecolumn']; ? This displays the above images in my

Re: Mysql / PHP image link problem.

2003-06-04 Thread Roman Neuhauser
keep the lines at or under 72 characters, please. # [EMAIL PROTECTED] / 2003-06-03 19:20:17 +0100: To display in my web page im using: img src=?php echo $row_Recordset1['imagecolumn']; ? This displays the above images in my html page The problem i have is where the field in my

RE: Mysql / PHP image link problem.

2003-06-04 Thread Jonathan Villa
You'll have to check if the result is NULL or not. Try this ? echo ($row_Recordset1['imagecolumn'] != NULL || ($row_Recordset1['imagecolumn'] != ) ? img src=\.$row_Recordset1['imagecolumn'].\ : ; ? This is print out nothing if your result is equal to null. On another notes, how do you

Re: Mysql / PHP image link problem.

2003-06-04 Thread Becoming Digital
FWIW, there is a PHP-DB mailing list that might prove more helpful to you. I know certain folk on both lists can get mighty annoyed when an off-topic question is posted, so I thought I'd give you a heads-up. [EMAIL PROTECTED] Edward Dudlik Becoming Digital www.becomingdigital.com -

RE: Mysql / PHP image link problem.

2003-06-04 Thread Peter Lovatt
?php if($row_Recordset1['imagecolumn']) echo 'img src='.$row_Recordset1[imagecolumn].''; ? Peter -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 20:57 To: [EMAIL PROTECTED] Subject: Re: Mysql / PHP image link problem. FWIW, there is a PHP-DB

Re: MySql, PHP, and Dates

2003-03-31 Thread Bruce Feist
Uttam wrote: u can use highly customizabe MySQL DATE_FORMAT() function for retrieving date in desired format. Thanks for the detailed information. For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date) function to return unix timestamp of the date and use the php date functions

Re: MySql, PHP, and Dates

2003-03-31 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-31 07:38:44 -0500: Uttam wrote: u can use highly customizabe MySQL DATE_FORMAT() function for retrieving date in desired format. Thanks for the detailed information. For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date) function to return

Re: MySql, PHP, and Dates

2003-03-30 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500: I'm experienced with SQL, but new to MySql and PHP, which I'm using together to create a dynamic web site. Right now, I'm having minor difficulties with date formatting. It seems that when I retrieve a date from MySQL into PHP, it shows up

Re: MySql, PHP, and Dates

2003-03-30 Thread B. van Ouwerkerk
This is not a MySQL question. http://www.php.net/manual/en/function.explode.php (probably) visit: http://www.php.net/links.php for tutorials on PHP. If you can control the layout of the database you could use another type of column. See the MySQL manual for more information. B. At 21:47

RE: MySql, PHP, and Dates

2003-03-30 Thread Mark Armendariz
/function.strtotime.php). Mark -Original Message- From: Roman Neuhauser [mailto:[EMAIL PROTECTED] Sent: Sunday, March 30, 2003 9:28 AM To: Bruce Feist Cc: MySQL List Subject: Re: MySql, PHP, and Dates # [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500: I'm experienced with SQL, but new to MySql

RE: MySql, PHP, and Dates

2003-03-30 Thread Uttam
u can use highly customizabe MySQL DATE_FORMAT() function for retrieving date in desired format. Relevant portion from manual is reprodcued below inside quotes. For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date) function to return unix timestamp of the date and use the php

Re: MySql, PHP and Javascript

2003-02-01 Thread Benjamin Pflugmann
Hi. On Fri 2003-01-31 at 08:27:11 +, [EMAIL PROTECTED] wrote: Is it possible to mix javascript and PHP in the same script?? Of course. One (PHP) is run on the server side in order to create a page which is sent to the client (here: the browser). The other (Javascript) may be contained in

Re: MySql, PHP and Javascript

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
Steve, this list is not the right place to ask JavaScript questions. Please check out an appropriate list at http://php.net/. But, anyway, it's possible to mix JS and PHP, no problem. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de

Re: MySql, PHP and Javascript

2003-01-31 Thread Josh Trutwin
Hi All Is it possible to mix javascript and PHP in the same script?? Client-side Javascript can be sent to the user along with your html. For Example: echo (HTMLHEAD\n); echo (SCRIPT TYPE=\text/javascript\\n); echo (!--\n; echo (function hello() {\n); echo ( alert('Hi');\n); echo (}\n);

Re: MySql, PHP and Javascript

2003-01-31 Thread Kevin Smith
Hi Steve, Yes, it is possible to mix PHP and JavaScript, for example: var givemeaphpvalue = ?php echo $phpvalue; ?; I use PHP and Javascript together quite often. Regards, Kevin - Original Message - From: Steve Davies [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31,

Re: MySql, PHP and Javascript

2003-01-31 Thread Kamara Eric R-M
Hi Steve, You can definitely mix javascript and PHP in the same script so long as you follow the correct syntax for each language.There is no way out here really...if you want to include javascript in your scripts then you have to learn it:-) unless you want to hire someone to do it for you...

RE: MySql, PHP and Javascript

2003-01-31 Thread [EMAIL PROTECTED]
Is it possible to mix javascript and PHP in the same script?? Yes it is, but you have to remember that PHP is server side and Javascript is Client side. I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like

RE: MySql, PHP and Javascript

2003-01-31 Thread Hoffman, Geoffrey
Absoulutely. Since PHP is server-side you can write javascript dynamically on the fly which are then executed client-side. Here's a simple example: !-- yourpage.php-- script language=Javascript var today = '?php echo date(Y-m-d, time()); ?'; /script -Original Message- From: Steve

Re: MySql, PHP and Javascript

2003-01-31 Thread Doug Thompson
Steve: On Fri, 31 Jan 2003 08:27:11 +, Steve Davies wrote: Is it possible to mix javascript and PHP in the same script?? Certainly. Exactly as HTML and PHP are intermingled in a document. I have a number of web based apps written in PHP/MySql and while they are functionally pretty

Re: MySql, PHP and Javascript

2003-01-31 Thread Brent Baisley
Of course. Javascript is a client side scripting language and is run in the users browser, whereas PHP is run on the server. The javascript is just text to the PHP parser, like HTML. Javascript will allow you to do dynamic stuff, but if you are looking for aesthetics you would be better off

RE: MySql, PHP and Javascript

2003-01-31 Thread Jennifer Goodie
PHP is server side, javascript is client side, they do not interact with each other. PHP gets parsed by on the server before the page is rendered, javascript is interpreted by the browser. You can either have PHP generate the javascript or just put it in the page. Rollovers have nothing to do

Re: MySql, PHP and Javascript

2003-01-31 Thread Brian
- Original Message - From: Steve Davies [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 3:27 AM Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP in the same script?? Short answer: Yes :) Longer explanation: Javascript is

RE: mysql php and blank variables...

2003-01-29 Thread Sherzod Ruzmetov
:when i type :mysql_query(insert into table_name ('$var list'...); i come :up with a bunch :of :blank/empty variables... Try to debug your query by outputting to the stdout instead of sending to the mysql server. You can do it by simply echo()ing your query as it is to the

Re: mysql php and blank variables...

2003-01-29 Thread Sunfire
ok will try that too... - Original Message - From: Sherzod Ruzmetov [EMAIL PROTECTED] To: Sunfire [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 7:07 AM Subject: RE: mysql php and blank variables... :when i type :mysql_query(insert into table_name

Re: MySQL PHP

2003-01-18 Thread Kamara Eric R-M
Hello Ryan, Did u compile PHP with mysql support enabled?as in did your configure line have something like this ./configure --with-mysql=/path/to/mysql? Regards, Eric === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box

Re: MySQL PHP

2003-01-18 Thread Ryan McDougall
Hey everyone, Thank you all for your quick responses and the problem was that I did not have mysql support installed for php... installed the required rpm and did a httpd restart and it wrks now!! Thanx again, Ryan __ Do you Yahoo!? Yahoo! Mail

Re: MySQL PHP

2003-01-18 Thread Stefan Hinz, iConnect \(Berlin\)
- Original Message - From: Kamara Eric R-M [EMAIL PROTECTED] To: Ryan McDougall [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED]; RedHat 8.0 Psyche [EMAIL PROTECTED] Sent: Saturday, January 18, 2003 5:26 PM Subject: Re: MySQL PHP Hello Ryan, Did u compile PHP with mysql support enabled?as in did

Re: MySQL-PHP-Apache2

2003-01-02 Thread Boris Penchev
Hi, I think that your problem is because you do not enter your root MySQL password in your connection to it. $db = mysql_connect(localhost, root); Try with this: $db = mysql_connect(localhost, root, your_root_mysql_password) or die(Could not connect: . mysql_error()); Best Regards, Boris

Re: MySQL + PHP : 'Commands out of sync; You can't run this command now'

2002-11-18 Thread Antoine
Just replying to myself... After replacing mysql_pconnect() with mysql_connect(), the problems seems gone so far. So chances are it is a bug on the PHP side. Regards Antoine. Hi, I'm having weird errors right now, running MySQL queries from PHP as an Apache module. Sometimes (in a

Re: MySQL + PHP : Commands out of sync; You can't run this command now

2002-11-18 Thread Jocelyn Fournier
Hi, It's known bug of PHP, which has just been fixed in 4.3 CVS. Use mysql_connect instead of mysql_pconnect as a workaround of the problem. (or get the latest CVS version of php 4.3.0) For more infos : http://bugs.php.net/bug.php?id=19529 Regards, Jocelyn - Original Message - From:

Re: MySQL + PHP : Commands out of sync; You can't run this command now

2002-11-18 Thread Steven Roussey
Comment out the body of the _restore_connection_defaults in php_mysql.c file in PHP. Recompile, etc. Or don’t use persistent connections. Should be fixed in PHP 4.3.   See http://bugs.php.net/?id=19529 for more info. Sincerely, Steven Roussey http://Network54.com/  

Re: MySQL + PHP : Commands out of sync; You can't run thiscommand now

2002-11-18 Thread Paul DuBois
At 18:24 +0100 11/18/02, Antoine wrote: Hi, I'm having weird errors right now, running MySQL queries from PHP as an Apache module. Sometimes (in a seemingly random way) some queries fail and mysql_error() displays Commands out of sync; You can't run this command now. I would say it seems to

RE: OT Re: Mysql, PHP and a wrapper

2002-09-25 Thread Brian . Duke
sometimes I'm my own worst wenzu. -Original Message- From: Danny Haworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:54 AM To: [EMAIL PROTECTED] Subject: OT Re: Mysql, PHP and a wrapper -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Filter: query , sql Hi Brian

OT Re: Mysql, PHP and a wrapper

2002-09-25 Thread Danny Haworth
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Filter: query , sql Hi Brian, | I'm running apache-1.3.23-14 on a redhat 7.3 system. | I have installed the php-rpm and the php_mysql.rpm from Redhat. | installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4. | | Cannot connect to my

Re: Mysql, PHP and a wrapper

2002-09-25 Thread Pablo
On 9/24/02 3:04 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: can someone tell me how to preinclude /DB/* functions in my Zend engine so I do not have to include_once in every script. You could set auto_prepend_file in php.ini, httpd.conf, or in a .htaccess file:

Re: mysql php question

2002-06-24 Thread Larry Irwin
Not really a simplistic one, but simple to set-up and use: http://phpnuke.org Very nice dynamic php/mysql based web site you can download and install. Larry Irwin CCA Medical - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 2:16

Re: mysql php question

2002-06-24 Thread Taylor Lewick
gotcha, thanks, which manual is that? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. [EMAIL PROTECTED] 06/24/02 01:39PM in the php manual in the section of functions about mysql, it has a few examples. SNIP

RE: mysql php question

2002-06-24 Thread Cal Evans
The one at www.php.net -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 1:50 PM To: [EMAIL PROTECTED] Subject: Re: mysql php question gotcha, thanks, which manual is that? Taylor Lewick Unix System Administrator Fortis Benefits 816 881

Re: mysql php question

2002-06-24 Thread Gerald R. Jensen
Taylor ... Check out ... http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html ... or ... http://vtwebwizard.com/tutorials/mysql/ - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 1:16 PM Subject: mysql php

Re: MySQL - PHP - Banner ad click through tracker

2002-05-01 Thread olinux
Check out phpADs http://sourceforge.net/projects/phpadsnew/ olinux --- Craig Westerman [EMAIL PROTECTED] wrote: Does anyone here have a PHP script that will store banner ad click throughs in a MySQL database? If not, is anyone here interested in doing this project? Thanks Craig

Re: MySql-PHP-Zlib-LIBJPEG-GD

2002-04-24 Thread taraben . a
Hi Jumac, Jumac wrote: Greetings all, Special greetings to Nathan,Andrew and Jan for previous help. I have some new problems ( big surprise! ) some of which will seem stupid for sure but i'm using the excuse of being a newbie..so i should be forgiven :-). 1.Like i said before I am

Re: mysql/php on Win2000

2002-03-26 Thread jake williamson 28
i've got IIS (so i can do ASP), apache, php, mysql and darwin streaming server all running on a w2k box that i use for web dev. i've set the services to start manually and depending on what i'm doing for the day i'll start them up individually. all works, it's fast and rarely give me hassle -

Re: mysql/php on Win2000

2002-03-25 Thread Chris Hedemark
Any advice, or links to useful docs would be appreciated. You did say *any* advice. Keep that in mind... My advice to you is to load some popular flavor of UNIX on that machine, such as Linux or OpenBSD, in order to have a more standard environment for this. Windows may work, but you're

Re: mysql/php on Win2000

2002-03-25 Thread Curtis Maurand
The only problem with Win2K is that a lot of the components for PHP aren't there. Also PHP will run as an ISAPI module, but its not recommended. The preferred method is as a CGI (read 25% performance hit). Win2K doesn't multi-task/multi-thread as well as either of the *nix's mentioned and its

RE: mysql/php on Win2000

2002-03-25 Thread Alexander, Chris
As far as OS's are concerned, I'm an equal opportunity bigot, I hate them all. :) Using these tools on your home PC running some flavour of Windows will work fine. That's the way I work, devel on the WinXP box, ftp the files/changes to my Linux web server. Everything seems to work - excepting

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
IIS: Kill the services, and disable them If you need to know which ones let me know. Oracle8i: No, they use different ports. I run Oracle8, mySQL, SQL Server7 without any problems -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
PROTECTED] Subject: Re: mysql/php on Win2000 The only problem with Win2K is that a lot of the components for PHP aren't there. Also PHP will run as an ISAPI module, but its not recommended. The preferred method is as a CGI (read 25% performance hit). Win2K doesn't multi-task/multi-thread as well

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
Properties and select Disable in the drop down box -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:34 PM To: 'Todd Williamsen' Cc: [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 Hi, if you think that IIS and Apache are going to have problems

RE: mysql/php on Win2000

2002-03-25 Thread Andrew Hazen
-Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:29 PM To: 'Andrew Hazen'; [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 IIS: Kill the services, and disable them If you need to know which ones let me know. Oracle8i: No, they use

RE: mysql/php on linux

2002-03-23 Thread Andy Cheng
Apache not understand the php script? Thanks From: Jim Philips [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: 18 Mar 2002 21:59:09 -0500 You should not save php scripts in cgi-bin. They need to be in your document root directory or a sub-directory

RE: mysql/php on linux

2002-03-23 Thread Todd Williamsen
Sounds like php isn't compiled correctly. Make sure the module for php is installed in apache -Original Message- From: Andy Cheng [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 1:48 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: mysql/php on linux Hello all

RE: mysql/php on linux

2002-03-23 Thread Jim Philips
phpinfo(); ? and not result of the phpinfo() function. When I run php phpinfo() at the shell command, it out puts the html result. What is problem, my Apache not understand the php script? Thanks From: Jim Philips [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] Subject: RE: mysql/php

RE: mysql/php on linux

2002-03-23 Thread Andy Cheng
of http.conf is different. How do I check if the module is load or installed? From: Dustin Rabe [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: Sat, 23 Mar 2002 11:57:53 -0800 (PST) Try adding this to your http.conf file in apache. ScriptAlias /php/ c:/php

Re: mysql/php on linux

2002-03-23 Thread Ken Anderson
. How do I check if the module is load or installed? From: Dustin Rabe [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: Sat, 23 Mar 2002 11:57:53 -0800 (PST) Try adding this to your http.conf file in apache. ScriptAlias /php/ c:/php/ AddType

Re: mysql/php on linux

2002-03-20 Thread bob parker
On Tuesday 19 March 2002 11:35, you wrote: Hi all, I too new to php and mysql, trying to get things works. I installed Redhat 7.2, Apache, mysql and php. I copied a sample php script from the internet and save it as phptest.php in my cgi-bin. When calling it from my browser, I got Format

Re: mysql/php on linux

2002-03-18 Thread Jim Philips
There is a tool that will automate the installation process, if you like. It can be found at: http://www.apachetoolbox.com/ You tell it what you want and with what features. Then it proceeds to download the files, configure, make and install them. It works quite well in my experience. On Mon,

RE: mysql/php on linux

2002-03-18 Thread Todd Williamsen
PHP http://www.php.net/manual/en/install.linux.php mySQL http://www.mysql.com/doc/L/i/Linux.html I never had any problems with mysql and PHP talking to each other on Linux, and I am very wet behind the ears with Linux. Maybe you can give us an error messages you are receiving, and that will

RE: mysql/php on linux

2002-03-18 Thread Andy Cheng
it in my cgi-bin? Could some one send me a working php script and instruct me how to test it? Thanks From: Todd Williamsen [EMAIL PROTECTED] To: 'Andrew Hazen' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: Mon, 18 Mar 2002 08:50:28 -0600 PHP http://www.php.net

Re: mysql php - while loops

2002-02-27 Thread DL Neil
Craig, [BTW there is a set of PHP lists, including PHP-DB - mentioned because 'purists' sometimes object to 'PHP questions'!?] The following lists 12 items from a fruits table. $results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice FROM fruits); while ($data =

Re: mysql php - while loops

2002-02-26 Thread Paul DuBois
At 18:42 -0600 2/26/02, Craig Westerman wrote: The following lists 12 items from a fruits table. $results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice FROM fruits); while ($data = mysql_fetch_array($results)) { ? p?=$data[date]? - ?=$data[appleprice]? - ?=$data[orangeprice]?

Re: mysql php - while loops

2002-02-26 Thread Sommai Fongnamthip
if you decide to display only first 4 item try to used limit clause after the SQL statement. otherwise use any count variable within your loop. Sommai At 20:33 26/2/2002 -0600, Paul DuBois wrote: At 18:42 -0600 2/26/02, Craig Westerman wrote: The following lists 12 items from a fruits table.

RE: MySQL php - assigning date variables

2002-02-25 Thread Daniel Rosher
SQL statement are: What is proper way to define a variable to include all dates newer than 1995-01-01? $query = ??? select * from table where date '1995-01-01' What is proper way to define a variable to include all dates older than 1995-01-01? $query = ??? select * from table where

Re: MySQL php - assigning date variables

2002-02-25 Thread Georg Richter
On Tuesday, 26. February 2002 00:18, Craig Westerman wrote: What is proper way to define a variable to include all dates newer than 1995-01-01? What is proper way to define a variable to include all dates older than 1995-01-01? What is proper way to define a variable to include all

RE: MySQL php - assigning date variables

2002-02-25 Thread Craig Westerman
SQL statement are: What is proper way to define a variable to include all dates newer than 1995-01-01? $query = ??? select * from table where date '1995-01-01' What is proper way to define a variable to include all dates older than 1995-01-01? $query = ??? select * from table where

Re: MySQL PHP Development IDE

2002-02-21 Thread Robert Cross
His interest lies not so much in using for database table modeling, but for PHP and Perl development. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? I've just finished using Quanta+ for doing a

Re: MySQL PHP Development IDE

2002-02-21 Thread Joel Wickard
This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. If he's not really that interested

RE: MySQL PHP Development IDE

2002-02-21 Thread Craig Shepherd
/PHAkt/ -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: 21 February 2002 14:58 To: 'Joel Wickard'; [EMAIL PROTECTED] Subject: RE: MySQL PHP Development IDE There is three options I use: 1. Macromedia Dreamweaver UltraDev4 with a PHP plugin or extension 2

RE: MySQL PHP Development IDE

2002-02-21 Thread Craig Shepherd
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is pretty good. It creates PHP scripts that manipulate MySQL databases. It is free and allows comparable functionality to the 'native' UltraDev languages (ASP, JSP, Cold Fusion). For more info -

Re: MySQL PHP Development IDE

2002-02-21 Thread BD
At 06:37 AM 2/21/2002 , you wrote: This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. I am well

RE: MySQL PHP Development IDE

2002-02-21 Thread Gerald Jensen
Thanks for the advice ... I'll take a look at dbg2 ... if I get stuck, I'll shoot you a plea for help! Gerald Jensen -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 9:38 AM To: Gerald R. Jensen Cc: [EMAIL PROTECTED] Subject: Re: MySQL PHP

Re: MySQL / PHP Augmenting Variables For UPDATE

2002-02-12 Thread Zak Greant
On Wed, 2002-02-06 at 07:51, Matt Rudderham wrote: Hi, I am making a form for editing the rows in a table. It displays each row as a row in a table(structure id tinyiny,name varchar(30) ), with the value inside a textbox so it can be changed. When doing the $submit to MySQL, I need do

Re: MySQL / PHP Augmenting Variables For UPDATE

2002-02-06 Thread Zak Greant
On Wed, 2002-02-06 at 07:51, Matt Rudderham wrote: Hi, I am making a form for editing the rows in a table. It displays each row as a row in a table(structure id tinyiny,name varchar(30) ), with the value inside a textbox so it can be changed. When doing the $submit to MySQL, I need do

Re: Mysql/Php Help?

2002-01-20 Thread Richard Ellerbrock
I really suggest you do a little homework and read the tutorials in both the php and mysql manuals. They are really valuable and should give you the examples you need. Maintainer IPPlan (https://sourceforge.net/projects/iptrack/) sql Gary Lefko wrote: Can someone writ eme an example of

Re: MySQL + php + Red Hat Linux 6.2

2001-12-27 Thread Benjamin Pflugmann
Hi. On Thu, Dec 20, 2001 at 04:01:03PM +0800, [EMAIL PROTECTED] wrote: Hello, My System is Red Hat 6.2 and need to run with php4 and imp ( www.horde.org/imp )... I found the MySQL packages ( RPM ) at www.mysql.com MySQL 3.23.46 Server (i386) (6M) MySQL 3.23.46 Benchmark/test suites

RE: MySQL/PHP

2001-09-06 Thread Antonio Ortega Sancho
de 2001 21:02 Para: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Asunto: Re: MySQL/PHP Chakravarthy K Sannedhi wrote: $db=mysql_connect (localhost,myname,mypassword); mysql_select_db (newone,$db); $result = mysql_query (select * from namelist); [snip] Warning: MySQL Connection

Re: MySQL/PHP

2001-09-05 Thread Adams, Bill TQO
Chakravarthy K Sannedhi wrote: $db=mysql_connect (localhost,myname,mypassword); mysql_select_db (newone,$db); $result = mysql_query (select * from namelist); [snip] Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket

Re: MySQL/PHP

2001-09-05 Thread Steve Suehring
hmm. Are you sure that MySQL is running? Conversely, does the file /var/lib/mysql/mysql.sock exist? Steve At 11:52 AM 9/5/01 -0700, Chakravarthy K Sannedhi wrote: Hello all, I am trying to integrate the mysql with php. As I am using the Red Hat 7.0, I know that they come pre-installed and

Re: MySQL/PHP

2001-09-05 Thread Chakravarthy K Sannedhi
--- Steve Suehring [EMAIL PROTECTED] wrote: hmm. Are you sure that MySQL is running? Conversely, does the file /var/lib/mysql/mysql.sock exist? Steve The mysql server is running and the mysql.sock file exists. Also I am able to connect to the mysql database by any of the following

Re: MySQL/PHP

2001-09-05 Thread Adams, Bill TQO
Chakravarthy K Sannedhi wrote: --- Steve Suehring [EMAIL PROTECTED] wrote: hmm. Are you sure that MySQL is running? Conversely, does the file /var/lib/mysql/mysql.sock exist? Steve The mysql server is running and the mysql.sock file exists. Also I am able to connect to the mysql

RE: MySQL/PHP

2001-09-05 Thread Dennis Herndon
, September 05, 2001 5:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL/PHP --- Steve Suehring [EMAIL PROTECTED] wrote: hmm. Are you sure that MySQL is running? Conversely, does the file /var/lib/mysql/mysql.sock exist? Steve The mysql server

RE: mysql-php mailing list

2001-08-09 Thread Jason Radley
Thank you all for your help!!! The problem was set_time_limit(0); Thank YOU ALL! -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 4:20 PM To: Jason Radley Cc: [EMAIL PROTECTED] Subject: Re: mysql-php mailing list Jason Radley

Re: mysql-php mailing list

2001-08-08 Thread Stefan Hinz
Dear Jason, maybe the problem is your provider cut CPU time to something like 6 seconds per call? Here in Germany, we have ISPs that do exactly this. So, it's actually not a timeout but rather a CPU out. Ask your ISP for such restrictions. Hope it helps. Regards, -- Stefan Hinz

  1   2   >