Re: [PHP] PHP / Query trouble

2006-03-23 Thread PHP Mailer
Chris skrev: PHP Mailer wrote: Jay Blanchard skrev: [snip] User i am running is locally granted all in permission. Using reply =) [/snip] Use reply-all, that way if the person that was helping you is not there any more others can help. Echo the query statement out and see what it looks like.

Re: [PHP] PHP / Query trouble

2006-03-23 Thread Chris
PHP Mailer wrote: Jay Blanchard skrev: [snip] User i am running is locally granted all in permission. Using reply =) [/snip] Use reply-all, that way if the person that was helping you is not there any more others can help. Echo the query statement out and see what it looks like. Please post th

Re: [PHP] PHP / Query trouble

2006-03-23 Thread PHP Mailer
PHP Mailer skrev: Jay Blanchard skrev: [snip] User i am running is locally granted all in permission. Using reply =) [/snip] Use reply-all, that way if the person that was helping you is not there any more others can help. Echo the query statement out and see what it looks like. Please post tha

Re: [PHP] PHP / Query trouble

2006-03-23 Thread PHP Mailer
Jay Blanchard skrev: [snip] User i am running is locally granted all in permission. Using reply =) [/snip] Use reply-all, that way if the person that was helping you is not there any more others can help. Echo the query statement out and see what it looks like. Please post that to the list.

RE: [PHP] PHP / Query trouble

2006-03-23 Thread Jay Blanchard
[snip] User i am running is locally granted all in permission. Using reply =) [/snip] Use reply-all, that way if the person that was helping you is not there any more others can help. Echo the query statement out and see what it looks like. Please post that to the list. -- PHP General Mailing L

RE: [PHP] PHP / Query trouble

2006-03-23 Thread Jay Blanchard
[snip] [snip] $optimizeTableQuery = mysql_query("OPTIMIZE TABLE '".$tableName."'"); [/snip] Take the single quotes away from the table name. http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html Make sure they are the right kind of tables. Trie

RE: [PHP] PHP / Query trouble

2006-03-23 Thread Jay Blanchard
[snip] > $optimizeTableQuery = mysql_query("OPTIMIZE TABLE > '".$tableName."'"); [/snip] Take the single quotes away from the table name. http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html Make sure they are the right kind of tables. -- PHP General Mailing List (http://www.php.net/

RE: [PHP] PHP / Query trouble

2006-03-23 Thread Jay Blanchard
[snip] #--> If submitted if($_GET['method']=="optimize") { #--> Set to array $allTables = mysql_query("SHOW TABLES"); if(!$query){ print mysql_error(); } while($table = mysql_fetch_assoc($allTables)) #for($i = 0; $tableName = mysql_fetch_array($allTables);) { #--> Walk that array foreach($table as

[PHP] PHP / Query trouble

2006-03-23 Thread PHP Mailer
Hello folks, Trying to grab all tables available in a database and optimize them. The following code , or rather query is being trouble-some and i am out of ideas. #--> If submitted if($_GET['method']=="optimize") { #--> Set to array $allTables = mysql_query("SHOW TABLES"); if(!$query){ print