Re: MySQL PHP Development IDE

[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 in the mysql integration than I would
say that you could probably go with a different IDE.  PHPed's db integration
and built-in php debugger are about the only two things that set it apart
from other IDE's.

 I am well aware of the conflict a few months ago
> between MySQL and NuSphere, but I have never heard anything one way or the
> other about PHPEd.

 At nearly $500 per package, it is not a decision I wish
> to make without some feedback from the community.
>
> 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?
>
> Any feed back (either to the list or me me privately) will be appreciated.

Before you make a commitment, you can apply for a trial version of
PHPed.  You have to give them real contact information, (I think I've gotten
like 5 sales-pitch emails since I downloaded my free trial 3 months ago.)
So you can give it a shot before you buy... and at $500 you should probably
try it first.

As for feedback on experience with the editor:
When you try to install the editor (at least this was what it did three
months ago)  It wants to install it's own copies of Apache and MySQL.  kind
of un-handy if you've got current installs you want to use.  I think it gave
you the option to keep your own, but after I got everything installed, the
database integration wouldn't work.  So I decided that I had free time on my
hands, I hosed my installs of apache and mysql and let it install it's own
stuff. after that I still couldn't get it to work properly.  I probably
could have tweeked something here or there and gotten everything to go, but
my reaction was kind of like.. "I'm going to pay $300 to have to play with
it this much to get it to work?"  It just didn't seem worth it Given that I
currently used allaire's homesite and the only things that PHPed had over
that in features was the db integration and php debugger, and I had already
worked out my own solutions to those problems.

I recommend downloading the trial version before you buy.  I also recommend
downloading the trial version of homesite as well.  Homesite gives you
syntax highlighting, project management, web deployment.  "scriptable"
deployment wich lets you decide what gets sent, where it gets put etc... all
in a script that you can re-run.  Plus homesite let's you edit the ide to
add in features that you may need
(http://www.macromedia.com/software/homesite/)  Or look into Quanta
depending on what platform you plan on developing on.

I found it ironic that if you buy PHPed standard, it only runs on windows
platforms, and that if you decided to buy PHP advantage, "then" you get
linux support.  seems like it should be the other way around given that the
product they are trying to sell was built on the back of Open Source
technologies.

> Gerald Jensen
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Fw: Does MySQL work with VMWare?

[Joel Wickard]

why not run cygwin?  I run postgres on my win2k box through cygwin.  It
would be less resource intensive.


> - Original Message -
> From: "BD" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, January 31, 2002 9:02 AM
> Subject: Does MySQL work with VMWare?
>
>
> > I have a Win2k machine and want to know if it is practical for
development
> > purposes to run MySQL in a VMWare linux window. Has anyone tried it? Are
> > there any caveats? TIA
> >
> > Brent
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL on the Playstation2? (OT? You betcha)

[Joel Wickard]

when you're in the programming gig for the science, you want to do
EVERYTHING.  when you're in it for the money, you want to do what's
practical, not neat.  For me computers and computer programming is a part of
who I am, not just a job, but a passion.  Sometimes it's hard for us to
remember that not everyone in the industry reveres programming in this
manner.

- Original Message -
From: "Carsten Gehling" <[EMAIL PROTECTED]>
To: "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 2:02 AM
Subject: Re: MySQL on the Playstation2? (OT? You betcha)


> From: "Colin Faber" <[EMAIL PROTECTED]>
> Sent: Thursday, January 31, 2002 7:07 AM
>
>
> > I think a better question would be why ;-)
>
> To quote our beloved Basil Fawlty: "Do you think this is what made the
> British Empire great?"
>
> When asked why anyone would want to climb Mount Everest, George Lee
Mallory
> answered: "Because it was there".
>
> Need I say more? :-)
>
> > It's not that I don't love my PS2 I just don't see it as a very good
> > database machine you know ;-)
>
> Aye. Neither is a matchbox-sized webserver any good. Still someone made
it.
> :-)
>
> - Carsten
>
> query :-)
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

next insert id

[Joel Wickard]

database,sql,query,table


I need to find out what the next value will be in an auto_increment field
will be. could someone help me out with the select statement?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MyVBQL in depth help needed

[Joel Wickard]

mysql, database

http://shop.barnesandnoble.com/booksearch/results.asp?WRD=MySql&userid=6AF42
HL01D


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Access -> Mysql conversion

[Joel Wickard]

I'm looking for a program, standalone, or web-based, to convert a current
access database to mysql.  any hints?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Mac OSX !?!?!?

[Joel Wickard]

try calling session_start() as the very first thing in your php script.

- Original Message -
From: "René Fournier" <[EMAIL PROTECTED]>
To: "PHP General" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 7:41 PM
Subject: Re: [PHP] Mac OSX !?!?!?


> Somebody suggested I post the source--good idea! So here it is... The
> header.inc file, in its entirety:
>
> 
> 
> 
> Site :: Jupiter :: Europa
> 
> 
> 
> // DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY
> // GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME
>
> $path = explode("/",$PHP_SELF);
> if (!$lang) { $lang = $path[sizeof($path)-2]; }
> $file = $path[sizeof($path)-1];
> $prename = explode(".",$file);
> $name = $prename[sizeof($prename)-2];
>
> // SECURITY CHECK
>
> session_start();
> if (!$PHPSESSID) { die;
> } elseif (!$auth) { die;
> } elseif ($auth != $path[sizeof($path)-2]) { die; }
>
> $language = "All Languages";
> if ($lang == "en") { $language = "English"; }
> if ($lang == "fr") { $language = "FranÁais"; }
> if ($lang == "es") { $language = "EspaÒol"; }
> if ($lang == "de") { $language = "Deutsch"; }
> if ($lang == "it") { $language = "Italiano"; }
>
> $priv = 2;
>
> // CONNECT TO DATABASE
>
> $db = mysql_connect("localhost","database","password");
> mysql_select_db("database",$db);
>
> // FETCH TABLE NAMES
>
> $listtables = mysql_list_tables("database",$db);
>
> // FETCH SELECTED TABLE DATA
>
> $fields = mysql_list_fields("database", $table, $db);
> $columns = mysql_num_fields($fields);
>
> ?>
> 
> 
> 
> 
>
>  alink="#00" leftmargin="20" topmargin="20" marginwidth="0"
> marginheight="0" background="../../common/bg.gif">
>  if ($language) { echo " href=../index.php4>Europa"; }
> if ($table) { echo " :  class=adminnormalgrey>Tables"; }
> ?>
>  
> 
>
> On Wednesday, January 16, 2002, at 06:01  PM, Richard Baskett wrote:
>
> > Kind of hard to say without source code for the session part..
> > Although the
> > MySQL warnings, I got those because MySQL does not automatically start
> > in
> > OSX, if you know it's started then Im not sure, but if not.. go here to
> > get
> > the autostart utility:
> >
> > http://www.entropy.ch/software/macosx/mysql/
> >
> > This link will have information and a link of where you can download the
> > utility.
> >
> > Rick
> >
> >
> > "The human mind is not capable of grasping the Universe. We are like a
> > little child entering a huge library. The walls are covered to the
> > ceilings
> > with books in many different tongues. The child knows that someone must
> > have
> > written these books. It does not know who or how. It does not
> > understand the
> > languages in which they are written. But the child notes a definite
> > plan in
> > the arrangement of the books---a mysterious order which it does not
> > comprehend, but only dimly suspects." - Albert Einstein
> >
> >> From: René Fournier <[EMAIL PROTECTED]>
> >> Date: Wed, 16 Jan 2002 17:50:06 -0700
> >> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> >> Subject: [PHP] Mac OSX !?!?!?
> >>
> >> Can someone PLEASE explain why I get the following error message under
> >> OSX (PHP+MySQL), but not under Windows ME or Linux?
> >>
> >> 
> >> Warning: Cannot send session cache limiter - headers already sent
> >> (output started at
> >> /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
> >> /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19
> >>
> >> Warning: Unable to save MySQL query result in
> >> /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44
> >>
> >> Warning: Supplied argument is not a valid MySQL result resource in
> >> /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45
> >> ---
> >>
> >> After these lines, the pages load fine. I'm using PHP Session ID
> >> variables (or trying to)--they work fine as I said under other OSes,
> >> but
> >> now break under OSX.
> >>
> >> ...Rene
> >>
> ---
> René Fournier
> [EMAIL PROTECTED]
> >>
> >>
> >> --
> >> PHP General Mailing List (http://www.php.net/)
> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >> For additional commands, e-mail: [EMAIL PROTECTED]
> >> To contact the list administrators, e-mail: php-list-
> >> [EMAIL PROTECTED]
> >>
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail  > [EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread,

Re: MySQL on Linux 2.4 question

[Joel Wickard]

600,000  row table?
what are you storing on that bad boy?


- Original Message -
From: "Weaver, Walt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 2:17 PM
Subject: MySQL on Linux 2.4 question


> Anyone else out there been playing with the new Linux 2.4 kernel?
>
> I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB
> tests. The results were dramatic; updating a 600,000 row table went from
21
> minutes and change to 6 minutes and change.
>
> Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same update ran in
about
> 8 minutes.
>
> This is obviously a big improvement, if my tests are valid. It's SUCH a
big
> improvement that I'm wondering if I messed something up.
>
> Any comments/statement of support/snide remarks will all be appreciated.
>
> Thanks,
>
> --Walt Weaver
>   Bozeman, Montana
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

INSERT OR UPDATE

[Joel Wickard]

Hello all,

I need to write a query that will insert data into a table if there is no
row matching a pre-specified ID, but will update a row if it matches a
pre-specified ID.

Any pointers would be great.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Benchmarking

[Joel Wickard]

Hello,
I've looked around on mysql.com, and through the directories of my mysql
install I'm looking for information on benchmarking my mysql database, but
I'm not interested in seeing how it performs against other databases, I'm
interested in testing how my designs will perform when scaled.  If anyone
can give me any pointers it would be great.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Benchmarking

[Joel Wickard]

Hello,
I've looked around on mysql.com, and through the directories of my mysql
install I'm looking for information on benchmarking my mysql database, but
I'm not interested in seeing how it performs against other databases, I'm
interested in testing how my designs will perform when scaled.  If anyone
can give me any pointers it would be great.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

sub selects

[Joel Wickard]

can you perform sub selects in mysql?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL on Win2000

[Joel Wickard]

Yes you can use phpmyadmin for windows2000,  I always have.

Here's a little bonus for you even though you didn't ask for it.

Save this to a batch file:

@echo off
set zdate=%date%
set zdate=%zdate: =%
set zdate=%zdate:/=-%
C:\mysql\bin\mysqldump -A > E:\mysqlDataBackup\%zdate%.txt 

(replace the second path to whatever backup directory you want)

set it up as an automatic task (start/settings/automatic tasks) 
and it will create backups of all your databases.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

time_format();

[Joel Wickard]

Hello all.

 I'm developing a web-based app with php / mysql.  I'm interested in hearing
 peoples opinions on a fairly trivial subject.  I have a feature on a page
 that retrieves times out of a mysql database.  I was considering formatting
 the date with javascript, or php, but it would be easiest to just format it
with the mysql time_format() function.  I've never used mysql's built in
 functions before and I was wondering if I'm going to see any performance
 drawbacks from formatting it with mysql instead of passing that off onto
the
 other servers.

 -Joel


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php