[PHP-DB] mysql_query

2009-08-10 Thread Ron Piggott
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

[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? > > R

Re: [PHP-DB] mysql_query

2009-08-10 Thread Phpster
On Aug 10, 2009, at 4:15 AM, "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

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 "fi

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 d

[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 datab

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 applicatio