RE: php version

2003-09-05 Thread Cory Lamle
Contents are Direct Alliance Corporation CONFIDENTIAL - Your best bet is to grab 4.3.1 or greater Windows version even has gui installer... http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror This message is for the designated recipient(s) only and contains Direct Alliance Corporation p

RE: Mysqlcc vs Phpmyadmin

2003-07-31 Thread Cory Lamle
Contents are Direct Alliance Corporation CONFIDENTIAL - - For writing long sql statements I prefer mysqlcc, and the tab feature is nice. - Phpmyadmin also has some handy feature. Most of it is preference... If learn to use both then all the better... -Original Message- From: Dathan

SQL Syntax

2003-07-22 Thread Cory Lamle
Contents are Direct Alliance Corporation CONFIDENTIAL - How do you type check in mysql. I have a column of type varchar(20) with both floats and strings. Is there a way to check the type? Example: Select If(is_float(col1), 'is a float', 'not a float') as typ

MYSQL INDEX CREATION...

2003-07-16 Thread Cory Lamle
Contents are Direct Alliance Corporation CONFIDENTIAL - I have a table with 10 cols. 8 of which all need to be searched on independently of each other. Does creating 8 separate indexes for that table affect the speed of how mysql searches each index? In other words would keeping my indexes to on

RE: CF & MySQL

2003-07-15 Thread Cory Lamle
Contents are Direct Alliance Corporation CONFIDENTIAL - Andrew, I have setup all the environments you are talking about. CF with MS SQL is much easier to setup and get going than PHP and mysql. However I have see twice the speed and stability with my applications that are written in PHP and

RE: mysql startup script problem

2003-07-09 Thread Cory Lamle
Contents are Direct Alliance Corporation CONFIDENTIAL - Duane, Does mysql actually start back up? Or just get hung on step(4)? I know I have had problems running scripts over ssh because the sudo environment user wasn't being executed as root. (where a cron_tab was actually execu