[PHP-DB] Re: mysql_query

2009-08-10 Thread David Robley
Ron Piggott wrote: I have the syntax mysql_query(INSERT INTO );); If this is successful I want to do update a column in one of my tables $query = UPDATE ... ; mysql_query($query); How do I test if the INSERT INTO mysql_query, in order to trigger the UPDATE? Ron You could

Re: [PHP-DB] mysql_query

2009-08-10 Thread Phpster
On Aug 10, 2009, at 4:15 AM, Ron Piggott ron@actsministries.org wrote: I have the syntax mysql_query(INSERT INTO );); If this is successful I want to do update a column in one of my tables $query = UPDATE ... ; mysql_query($query); How do I test if the INSERT INTO

Re: [PHP-DB] adding a simple WHERE clause to this MySQL query causes the result to contain 0 rows?!

2009-08-10 Thread John Butler
If you're using windows, it's very easy. http://www.apachefriends.org/en/index.html It has a webserver (apache), mysql, phpmyadmin + a bunch of other stuff included in the one download. One click installer .. voila. I'm on mac here where I develop. I see they say the mac version is in

Re: [PHP-DB] adding a simple WHERE clause to this MySQL query causes the result to contain 0 rows?!

2009-08-10 Thread sono-io
On Aug 10, 2009, at 7:07 AM, John Butler wrote: If you're using windows, it's very easy. http://www.apachefriends.org/en/index.html It has a webserver (apache), mysql, phpmyadmin + a bunch of other stuff included in the one download. One click installer .. voila. I'm on mac here where I

[PHP-DB] Mysql multiple queries Vs. Query in multi-dimensional array

2009-08-10 Thread Drew Stokes
Hello all, I have an enterprise application that needs to be optimized/re- engineered. In the process of re-designing the framework, i stumbled across the idea of storing large mysql result sets in multi- dimensional arrays for easy/quick reference. Basically, my application polls the

Re: [PHP-DB] Mysql multiple queries Vs. Query in multi-dimensional array

2009-08-10 Thread Chris
Drew Stokes wrote: Hello all, I have an enterprise application that needs to be optimized/re-engineered. In the process of re-designing the framework, i stumbled across the idea of storing large mysql result sets in multi-dimensional arrays for easy/quick reference. Basically, my