PHP/mySQL Developer Partner needed...

2012-07-02 Thread Don Wieland
Greetings, I have a site that I am developing and I am looking to partner/ developer with great php/mySQL skills (for share of potential profits) to assist me in finishing this site. I am looking for someone who can invest (like myself) their time and skills to complete the site

Re: [PHP] mysql error

2011-05-05 Thread Daniel Brown
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote: Can smbd please look  at this sentence - I got an error and do not know how to fix it - I am still very unfamiliar with MYSQL: CREATE TABLE log (  idlog int auto_increment not null,  imepriimek varchar(50),  clock

Re: [PHP] mysql error

2011-05-05 Thread Michael Dykman
CREATE TABLE log (  idlog int auto_increment not null,  imepriimek varchar(50),  clock timestamp,  action varchar(30),  onfile varchar(100), filesize float(6,2), uniqueid(idlog) ); -- here is your mistake the syntax for that should be 'unique key(idlog)' if you only wanted to specify a

Re: [PHP] mySQL query assistance...

2010-11-29 Thread Daniel P. Brown
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote: Hi all, Is there a list/form to get some help on compiling mySQL queries? I am executing them via PHP, but do not want to ask for help here if it is no the appropriate forum. Thanks ;-) Yes. For MySQL queries,

Re: [PHP] mySQL query assistance...

2010-11-29 Thread Wagner Bianchi
This is the general list. If your problem is with MySQL and queries, let us know. Best regards. -- WB 2010/11/29 Daniel P. Brown daniel.br...@parasane.net On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote: Hi all, Is there a list/form to get some help on

php - mysql tandem and multi core performance

2010-09-28 Thread Giulio Mastrosanti
cheaper than the first; my question is: on your experience, how do php / mySQL behave on multicores? maybe its better a lesser_core / highest frequency system than a more_core / lower frequency? can a 12 GB / 24 GB RAM configuration make the difference? in which terms? thank you for your

Re: [PHP] MySQL select matching

2010-07-21 Thread Simcha Younger
On Mon, 19 Jul 2010 10:36:40 -0600 Ashley M. Kirchner ash...@pcraft.com wrote: mysql select * from table where id='1'; +---+-+-+---+ | 1 | 123 | 0.0 | C | | 1 | 234 | 0.1 | D | | 1 | 345 | 0.0 | D | | 1 | 456 | 0.1 | C | | 1 | 567 | 0.1 | G |

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-19 Thread Nigel Wood
Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a few secs #3. While Loop { INSERT data (from #2) into local MySQL } - this may take only mili secs.

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-19 Thread Johan De Meersman
On Fri, Apr 16, 2010 at 1:31 PM, Nigel Wood nw...@plus.net wrote: P.S. Sorry to the other list users for a PHP oriented discussion. Get a room, you two :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-19 Thread Michael Dykman
On this level, it's more of an apache/web-server-in-general issue. There are 2 connections to be considered here: the connection between the browser and the web server and the connection between the webserver (running PHP for example) and the database and they have very different behaviours. If

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-17 Thread Antonio PHP
Well... just summarizing my thread here. I tested this today. As Carsten mentioned... Without the function 'ignore_user_abort(true);', when the browser is closed the script will stop at some point (if there's output ('echo etc') of certain number (1,000s) of characters remaining.). Many Thanks

What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Antonio PHP
This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a few secs #3. While Loop { INSERT data (from #2) into local MySQL } - this may take only

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Jørn Dahl-Stamnes
On Friday 16 April 2010 11:39, Antonio PHP wrote: This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a few secs #3. While Loop { INSERT

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Geert-Jan Brits
As a side-note: letting a random user (such as your website visitor) wait for a couple of seconds is usually not good practice, unless you have a very good incentive for them to do so. 2010/4/16 Jørn Dahl-Stamnes sq...@dahl-stamnes.net On Friday 16 April 2010 11:39, Antonio PHP wrote: This

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Carsten Pedersen
http://php.net/manual/en/function.ignore-user-abort.php / Carsten On Fri, 16 Apr 2010 18:39:07 +0900, Antonio PHP php.anto...@gmail.com wrote: This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl;

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Carsten Pedersen
On Fri, 16 Apr 2010 11:44:42 +0200, Jørn Dahl-Stamnes sq...@dahl-stamnes.net wrote: The server does not know if the browser is closed or not (or if the network connection is losted). It will continue to execute the code until finnished. Not quite true. If it decides to flush its

ANN: DBForms from MS Access to PHP + MySQL v3.0.0. release!

2010-01-20 Thread Dmitry Narizhnykh
DMSoft Technologies is glad to announce the release of DBForms from MS Access to PHP + MySQL v3.0.0. DBForms from MS Access to PHP + MySQL allows you to convert MS Access forms to PHP driven WEB pages and Microsoft Access tables to MySQL database. This converter combines the strengths

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-18 Thread Edward S.P. Leong
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Friday, January 15, 2010 8:03 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: BTW, would you mind

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-15 Thread Edward S.P. Leong
Jerry Schwartz wrote: BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-15 Thread Jerry Schwartz
From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Friday, January 15, 2010 8:03 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: BTW, would you mind to tell me which newer

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-15 Thread Edward S.P. Leong
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Friday, January 15, 2010 8:03 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: BTW, would you mind

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-15 Thread Jerry Schwartz
Dear Jerry, OH 32 Bit php is good for working with 64 Bit MySQL ? [JS] Yes, it's fine. Remember, MySQL is a server - it doesn't care who is on the other end, so long as the queries are properly formed. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-04 Thread Jerry Schwartz
Dear Jerry, Would you mind to tell me how to update ( what tool/editor ) all of your php source code for using with your new version of php and mysql ? [JS] If I had one, I would do it. I've been using an editor named Textpad for a very, very long time but despite its many features I wouldn't

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-04 Thread Jerry Schwartz
-Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Sunday, January 03, 2010 2:13 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Dear Jerry, Sorry... I just visit www.php.net... BUT I don't quite understanding the online manual:

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-02 Thread Edward S.P. Leong
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Tuesday, December 29, 2009 10:35 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: Dear Jerry, Sorry

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-01 Thread Edward S.P. Leong
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Tuesday, December 29, 2009 10:35 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: Dear Jerry, Sorry

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-29 Thread Edward S.P. Leong
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Monday, December 28, 2009 9:25 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: -Original Message

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-29 Thread Jerry Schwartz
Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? [JS] No, I am not saying that. The system I inherited was running 5.x, and I have not had the time nor urgent need to move upwards. There are some incompatibilities that I would have to deal with. For example, although short tags

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-29 Thread Edward S.P. Leong
Jerry Schwartz wrote: Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? [JS] No, I am not saying that. The system I inherited was running 5.x, and I have not had the time nor urgent need to move upwards. There are some incompatibilities that I would have to deal with. For

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-29 Thread Jerry Schwartz
From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Tuesday, December 29, 2009 10:35 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: Dear Jerry, Sorry, did you suggest to use

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-28 Thread Edward S.P. Leong
Jerry Schwartz wrote: -Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Thursday, December 17, 2009 7:25 AM To: mysql@lists.mysql.com Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Dear all, Would you mind to give me

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-28 Thread Jerry Schwartz
From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Monday, December 28, 2009 9:25 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: -Original Message- From: Edward S.P

32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-17 Thread Edward S.P. Leong
Dear all, Would you mind to give me the suggestion ? I want to use 32bit php and mysql server on 64bit Windows 2003 Server... So, is it possible ( good for work also ) ? Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-17 Thread Jerry Schwartz
-Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Thursday, December 17, 2009 7:25 AM To: mysql@lists.mysql.com Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Dear all, Would you mind to give me the suggestion ? I want to use

Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
Hi guys I'm getting rather confused on this thing. Results returned from mysql console/query-browser is different from what's returned from same query in PHP. Maybe someone smarter than me could shed some light on what's going on. I'm clueless :( Environment is as follow: Mysql Server

Re: Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
. - Rick Original Message Date: Tuesday, September 22, 2009 10:02:06 PM +0200 From: Mogens Melander mog...@fumlersoft.dk To: mysql@lists.mysql.com Subject: Wierd PHP/MySQL result Hi guys I'm getting rather confused on this thing. Results returned from mysql

Re: Wierd PHP/MySQL result (Solved)

2009-09-22 Thread Mogens Melander
of the variable you're printing. - Rick Original Message Date: Tuesday, September 22, 2009 10:02:06 PM +0200 From: Mogens Melander mog...@fumlersoft.dk To: mysql@lists.mysql.com Subject: Wierd PHP/MySQL result Hi guys I'm getting rather confused on this thing

Re: Wierd PHP/MySQL result

2009-09-22 Thread Mark Goodge
Mogens Melander wrote: Well, no typos. The relevant piece of code: if (! $cust = mysql_fetch_assoc($res)) { echo {success: false, errors: { reason: 'Fetch Customer failed: . htmlspecialchars(mysql_error(),ENT_QUOTES) . br .

Re: Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
Yes, you are right. It's the json_encode that fail. It's strange though. The data that fail is Humlebæk. Another query, in another form, returning Værksted don't fail in json_encode. echo $cust['oname'];give the correct value. On Tue, September 22, 2009 22:56, Mark Goodge wrote: Mogens

PHP MYSQL Admin question

2009-07-23 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Trying the latest phpMYAdmin on Mac OS X. Everything is set up correct but I get #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) And I am telling config.php where the mysql.sock file is located. Help. -- MySQL General Mailing List For

Re: PHP MYSQL Admin question

2009-07-23 Thread Johnny Withers
Are you sure MySQL is running? Can you connect with any other MySQL client? On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem r...@doctor.nl2k.ab.ca wrote: Trying the latest phpMYAdmin on Mac OS X. Everything is set up correct but I

Re: PHP MYSQL Admin question

2009-07-23 Thread The Doctor
On Thu, Jul 23, 2009 at 08:47:41AM -0500, Johnny Withers wrote: Are you sure MySQL is running? Can you connect with any other MySQL client? Turns out the php.ini was not set properly. On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System Administrator a.k.a. The Root of the

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Daniel Brown
Chris; From my understanding of your question, your message (included below in its entirety) is better sent to the MySQL General list, which I've CC'd on this reply. If you haven't yet, please subscribe there at mysql-subscr...@lists.mysql.com to follow the thread for responses. If

RE: [PHP] mysql cache query as xml

2009-07-10 Thread Gavin Towey
Towey -Original Message- From: paras...@gmail.com [mailto:paras...@gmail.com] On Behalf Of Daniel Brown Sent: Friday, July 10, 2009 9:37 AM To: workerho...@studysite.eu Cc: PHP; MYSQL General List Subject: Re: [PHP] mysql cache query as xml Chris; From my understanding of your

RE: PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
Yeah I used the mysql_error and it returned Can't create table '.\website\table2.frm' (errno: 150). So what does that say? Date: Tue, 7 Apr 2009 17:38:59 +0400 From: evge...@kosov.su To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: PHP-MYSQL Question Perhaps you

Re: PHP-MYSQL Question

2009-04-07 Thread Eugene Kosov
:59 +0400 From: evge...@kosov.su To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: PHP-MYSQL Question Perhaps you don't have permissions to create tables? It would have been much clearer if your script was like this: $result=mysql_query($your_create_table_statement); if($result

RE: PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
that be the problem? Date: Tue, 7 Apr 2009 17:48:16 +0400 From: evge...@kosov.su To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: PHP-MYSQL Question # perror 150 MySQL error code 150: Foreign key constraint is incorrectly formed What does table1 look like? abdulazeez

Re: PHP-MYSQL Question

2009-04-07 Thread Eugene Kosov
Perhaps you don't have permissions to create tables? It would have been much clearer if your script was like this: $result=mysql_query($your_create_table_statement); if($result){ printSuccessful;} else {print Unsuccessful: .mysql_error()} abdulazeez alugo wrote: Hi guys, Please can anyone

Re: PHP-MYSQL Question

2009-04-07 Thread Eugene Kosov
@lists.mysql.com Subject: Re: PHP-MYSQL Question # perror 150 MySQL error code 150: Foreign key constraint is incorrectly formed What does table1 look like? abdulazeez alugo wrote: Yeah I used the mysql_error and it returned Can't create table '.\website\table2.frm' (errno: 150

PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
Hi guys, Please can anyone tell me what I'm doing wrong with the code below? It keep returning unsuccessful. $result=mysql_query(CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, table1_id INT NOT NULL, name VARCHAR(100) NOT NULL, school VARCHAR(100) NOT NULL, comment

RE: PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
Subject: Re: PHP-MYSQL Question I suppose the problem is that table1.table1_id and table2.table1_id are of different types. The first one is INT UNSIGNED and the second is just INT. abdulazeez alugo wrote: Table1 is as below: CREATE TABLE table1(table1_id INT UNSIGNED NOT NULL

Re: PHP-MYSQL Question

2009-04-07 Thread Spiros Papadopoulos
but table2 remains unsuccessful. Date: Tue, 7 Apr 2009 17:56:49 +0400 From: evge...@kosov.su To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: PHP-MYSQL Question I suppose the problem is that table1.table1_id and table2.table1_id are of different types. The first one is INT

RE: PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
I've done that but it still gives the same error message. Date: Tue, 7 Apr 2009 16:25:15 +0200 Subject: Re: PHP-MYSQL Question From: spa...@googlemail.com To: defati...@hotmail.com CC: mysql@lists.mysql.com it is not the ENGINE as Eugene mentioned above, is that you need to use UNSIGNED

RE: PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
and it returned successful. So that was the problem all along. Thanks for your suggestions. Best regards Alugo Abdulazeez. From: defati...@hotmail.com To: spa...@googlemail.com CC: mysql@lists.mysql.com Subject: RE: PHP-MYSQL Question Date: Tue, 7 Apr 2009 15:32:25 +0100 I've done

Re: PHP, MySQL questions

2008-07-23 Thread VeeJay
Hi Chaim Contents are going to be dynamic... I will go with Apache 2.2.9 and also PHP with ACP (accelator) Any suggestions? Regards VJ On Tue, Jul 22, 2008 at 10:18 PM, Chaim Rieger [EMAIL PROTECTED] wrote: VeeJay wrote: Hi there I am going to make 2 Webserver at my work going to

Re: PHP, MySQL questions

2008-07-23 Thread Ken Menzel
VeeJay wrote: Hi there I am going to make 2 Webserver at my work going to handle 50 mil hits per month... They are using Linux already. But being a FreeBSD fan, I have proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD is more Fast and Secure solution for his needs...

PHP, MySQL questions

2008-07-22 Thread VeeJay
Hi there I am going to make 2 Webserver at my work going to handle 50 mil hits per month... They are using Linux already. But being a FreeBSD fan, I have proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD is more Fast and Secure solution for his needs... And now I want to

PHP+MySQL: localhost or 127.0.0.1?

2007-10-30 Thread Tiago Cruz
Hello all, Using PHP+MySQL, I've noted that: If I use 'localhost', I'm using socket to do the connection. If the socket was wrong, the connections was failed. If I use '127.0.0.1', I'm not using socket and I'll be connected if I have permission. Now the question: Which one have better

Upgrading PHP + MySQL

2007-10-23 Thread David Zentgraf
/lib/php4/mysql.so is linked to libmysqlclient.so.10. How do I update/replace/relink the php-mysql connector to have PHP talk to MySQL using the current client libraries? Any hints'd greatly appreciated. Cheers, Dav -- MySQL General Mailing List For list archives: http://lists.mysql.com

ANN: DBForms from MS Access to PHP + MySQL v.2.1.1 released

2007-08-31 Thread Dmitry Narizhnykh
DBConvert.com announces DBForms from MS Access to PHP + MySQL v.2.1.1 release. Our application allows you to convert mdb (Microsoft Access databases) and MS Access forms to AJAX based WEB page using PHP and MySQL. DBForms for MS Access to PHP + MySQL supports elements in MS Access forms

[OFF] PHP/MySQL contractor needed

2006-09-22 Thread Brian Dunning
We need a guy for some hourly PHP/MySQL work. Large project to start with, plenty of incremental stuff down the road. Looking for someone expert, with a flexible schedule who can make hours available when we need them. Your regular hourly rate. Also - only interested in someone local

RE: cell colors PHP/MySQL

2006-08-10 Thread Daevid Vincent
, Organization is the key to success. DÆVID -Original Message- From: Nicholas Vettese [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 12:33 PM To: mysql@lists.mysql.com Subject: Re: cell colors PHP/MySQL Wouldn't using a 'switch' statement work better? Just please

cell colors PHP/MySQL

2006-08-09 Thread Brian E Boothe
i'm needing assistance in table Cell color thru MySQL i have a project were im listing a projects in a table either Complete / Active / Pending / now im needing these refrances cells to change Color whenver its lists them out on a page, [Complete] = green[Active] = Blue[Pending] =

Re: cell colors PHP/MySQL

2006-08-09 Thread Chris White
On Wednesday 09 August 2006 12:24 pm, Brian E Boothe wrote: i'm needing assistance in table Cell color thru MySQL i have a project were im listing a projects in a table either Complete / Active / Pending / now im needing these refrances cells to change Color whenver its lists them out on a

Re: cell colors PHP/MySQL

2006-08-09 Thread Nicholas Vettese
Wouldn't using a 'switch' statement work better? Just please do not ask me to show an example. :) - Original Message - From: Chris White [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, August 09, 2006 3:30 PM Subject: Re: cell colors PHP/MySQL On Wednesday 09 August

RE: cell colors PHP/MySQL

2006-08-09 Thread Logan, David (SST - Adelaide)
:[EMAIL PROTECTED] Sent: Thursday, 10 August 2006 4:55 AM To: mysql@lists.mysql.com Subject: cell colors PHP/MySQL i'm needing assistance in table Cell color thru MySQL i have a project were im listing a projects in a table either Complete / Active / Pending / now im needing these refrances cells

Re: cell colors PHP/MySQL

2006-08-09 Thread Ligaya Turmelle
Brian E Boothe wrote: i'm needing assistance in table Cell color thru MySQL i have a project were im listing a projects in a table either Complete / Active / Pending / now im needing these refrances cells to change Color whenver its lists them out on a page, [Complete] = green[Active]

sorting with php/mysql

2006-05-02 Thread ross
This is my database...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. Say I delete item 2 how can I delted the gap and 'promote item_id 3 to item_id 2

Re: sorting with php/mysql

2006-05-02 Thread Peter Brawley
Ross, This is my database. Nope, it's a table, not a database. ..I will use the item_id for the order but what if I want to change item_id 3 to item id 1? A primary key shouldn't be edited, and the literal value of an auto_increment column oughtn't to be relevant. If you really need a

Re: Run Apache/PHP/MySQL from CD?

2006-04-20 Thread Frank
Jay Paulson wrote: I have no idea if this is possible or not but is there a way to run Apache, PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows, Mac OSX and *nix. If it is possible could someone point me in the right direction? Thanks! Hi Jay, I am currently

Re: Run Apache/PHP/MySQL from CD?

2006-04-20 Thread John Hicks
Jay Paulson wrote: I have no idea if this is possible or not but is there a way to run Apache, PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows, Mac OSX and *nix. If it is possible could someone point me in the right direction? Thanks! XAMPP is a distribution of

RE: [PHP] Re: Run Apache/PHP/MySQL from CD?

2006-04-20 Thread Nicolas Verhaeghe
: [PHP] Re: Run Apache/PHP/MySQL from CD? Jay Paulson wrote: I have no idea if this is possible or not but is there a way to run Apache, PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows, Mac OSX and *nix. If it is possible could someone point me in the right direction

Run Apache/PHP/MySQL from CD?

2006-04-19 Thread Jay Paulson
I have no idea if this is possible or not but is there a way to run Apache, PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows, Mac OSX and *nix. If it is possible could someone point me in the right direction? Thanks! -- MySQL General Mailing List For list archives:

RE: Run Apache/PHP/MySQL from CD?

2006-04-19 Thread Jay Blanchard
[snip] I have no idea if this is possible or not but is there a way to run Apache, PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows, Mac OSX and *nix. If it is possible could someone point me in the right direction? [/snip] You'd have to have CD's for each OS on which

RE: Run Apache/PHP/MySQL from CD?

2006-04-19 Thread Jay Blanchard
[snip] I have no idea if this is possible or not but is there a way to run Apache, PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows, Mac OSX and *nix. If it is possible could someone point me in the right direction? [/snip] Yippee, cross-posting!

RE: Run Apache/PHP/MySQL from CD?

2006-04-19 Thread mysql
2006, Jay Blanchard wrote: To: Jay Paulson [EMAIL PROTECTED], php-general@lists.php.net, mysql@lists.mysql.com From: Jay Blanchard [EMAIL PROTECTED] Subject: RE: Run Apache/PHP/MySQL from CD? [snip] I have no idea if this is possible or not but is there a way to run Apache, PHP

Re: Run Apache/PHP/MySQL from CD?

2006-04-19 Thread Anne E. Shroeder
Yes -- try www.dwebpro.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Jigal van Hemert
it later. Basically, which option is the best between PHP/MySQL and ASP/MSSQL? It's not a giant project but it might include around 20'000 members interacting daily through forums, blogs, messages etc... It's not an easy question to answer, Marc. Win/IIS/ASP/MSSQL might need a bit more

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Joerg Bruehe
Hi Jigal, all! Jigal van Hemert wrote: [[...]] Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job. ^^ No flame war

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Peter J Milanese
@lists.mysql.com Subject: Re: PHP/MySQL vs ASP/MSSQL? Hi Jigal, all! Jigal van Hemert wrote: [[...]] Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Jigal van Hemert
Hi Joerg (and other list readers), Joerg Bruehe wrote: Jigal van Hemert wrote: Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job.

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Pooly
create it once and change it later. Basically, which option is the best between PHP/MySQL and ASP/MSSQL? It's not a giant project but it might include around 20'000 members interacting daily through forums, blogs, messages etc... A setup of ASP/MySQL could be a right option for you if you already

RE: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread J.R. Bullington
- From: Pooly [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 7:37 AM To: MySQL General Subject: Re: PHP/MySQL vs ASP/MSSQL? 2005/11/4, Marc Pidoux [EMAIL PROTECTED]: I've been using ASP for years but I have to work on a bigger project involving many users and data so of course

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Erich Beyrent
Jigal van Hemert wrote: Hi Joerg (and other list readers), Joerg Bruehe wrote: Jigal van Hemert wrote: Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). You could always run MySQL on Windows Server along with your IIS and ASP. You

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread SGreen
and several applications all linked together, I can't create it once and change it later. Basically, which option is the best between PHP/MySQL and ASP/MSSQL? It's not a giant project but it might include around 20'000 members interacting daily through forums, blogs, messages etc... It's

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Peter Brawley
. Basically, which option is the best between PHP/MySQL and ASP/MSSQL? It's not a giant project but it might include around 20'000 members interacting daily through forums, blogs, messages etc... .NET/MySQL will be a _lot_ cheaper than .NET/MSSQL. Visual Studio will save you a lot of time, but even

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Nestor
I have used both and I prefer php/mysql :-) On 11/4/05, Peter Brawley [EMAIL PROTECTED] wrote: Marc, I've been using ASP for years but I have to work on a bigger project involving many users and data so of course, Access is not an option anymore. Since it's a project requiring thousand

Re: PHP/MySQL vs ASP/MSSQL?

2005-11-04 Thread Subscriptions
Me, too. One thing that's a plus for my clients is to tell them that is will cost them less if I develop in php/mysql as opposed to ASP/MSSQL. Hosting is cheaper and I can do things in PHP that takes 5 lines as opposed to ASP/MSSQL which takes 20. heh Jenifer - Original Message

PHP/MySQL vs ASP/MSSQL?

2005-11-03 Thread Marc Pidoux
, which option is the best between PHP/MySQL and ASP/MSSQL? It's not a giant project but it might include around 20'000 members interacting daily through forums, blogs, messages etc... Thanks, Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

PHP MySQL connection problem

2005-06-10 Thread Andre Matos
Hi list, I am getting slow connections between php4 and MySQL 4.1.9. There are some connections that are very fast, but others can take from 5 to 20 second or more (usually it takes less than 0.1 second to create a new connection). I tried to identify if there is a pattern but it seems that

Re: PHP MySQL connection problem

2005-06-10 Thread Greg Donald
On 6/10/05, Andre Matos [EMAIL PROTECTED] wrote: I am getting slow connections between php4 and MySQL 4.1.9. There are some connections that are very fast, but others can take from 5 to 20 second or more (usually it takes less than 0.1 second to create a new connection). I tried to

Php/Mysql problem - undiefined method mysql_connect()

2005-05-16 Thread CIKALA Frédéric ROSI/SIPROD
error: Call to undefined function: mysql_connect() in /var/www/html/TechUnix/include/connexion.php on line 10 So i checked google and found out that a special rpm was needed .. so i've looked for it and when i try to install it, it tells me that : [EMAIL PROTECTED] dl]# rpm -ivh php-mysql

Re: Slow access Apache + PHP + MySQL

2005-03-28 Thread Santino
What is your MySql configuration file? What query is slow? Have you tested your query with mysql tool from a command line? What is your schema? What is the result of describe select ... I suggest you to look at dns because, if i'm not wrong, MySql tries to resolve ips and this can slow down

Re: Slow access Apache + PHP + MySQL

2005-03-27 Thread Santino
It could be a DNS problem, but you must give us more details. Santino At 10:47 -0500 26-03-2005, Andre Matos wrote: Hi List, I have 4 web based systems developed using PHP4 and MySQL accessed for 10 users. The Web Server and Database Server were running ok on a Mac OS X 10.3 G4 dual. However,

Slow access Apache + PHP + MySQL

2005-03-26 Thread Andre Matos
Hi List, I have 4 web based systems developed using PHP4 and MySQL accessed for 10 users. The Web Server and Database Server were running ok on a Mac OS X 10.3 G4 dual. However, since we move to a new server, the access becomes very slow. This was not expected since we move to a 64 bits high

RE: Slow access Apache + PHP + MySQL

2005-03-26 Thread gunmuse
-Original Message- From: Andre Matos [mailto:[EMAIL PROTECTED] Sent: Saturday, March 26, 2005 8:47 AM To: 'mysql@lists.mysql.com ' Subject: Slow access Apache + PHP + MySQL Hi List, I have 4 web based systems developed using PHP4 and MySQL accessed for 10 users. The Web Server and Database

php - mysql connection

2005-03-08 Thread Star Smile Center for Esthetic Dentistry
Hi, I am a new mysql user. I installed a MySQL, PHP and Apache on my computer with Windows XP. All my php scripts run fine unless I try to connect to mysql ?php echo start here; $a = mysql_connect(localhost, test, test); echo $a; echo stop here; ? I don't get any response even error message

RE: php - mysql connection

2005-03-08 Thread Jay Blanchard
[snip] I am a new mysql user. I installed a MySQL, PHP and Apache on my computer with Windows XP. All my php scripts run fine unless I try to connect to mysql ?php echo start here; $a = mysql_connect(localhost, test, test); echo $a; echo stop here; ? I don't get any response even error

Re: php - mysql connection

2005-03-08 Thread Eric Bergen
mysql_connect('localhost', 'my_user', 'my_pass') or die(mysql_error()): On Tue, 8 Mar 2005 11:28:47 -0600, Jay Blanchard [EMAIL PROTECTED] wrote: [snip] I am a new mysql user. I installed a MySQL, PHP and Apache on my computer with Windows XP. All my php scripts run fine unless I try to

Re: Problem with PHP + MySQL + InnoDB

2005-03-03 Thread Gleb Paharenko
Hello. How to force to kill process which make lock of table ? since PHP make many persistent connection to MySQL and i don't know which one is locking the table :( You may get information about processes on your MySQL server using SHOW PROCESSLIST and kill the weird process with the

  1   2   3   4   >