Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

Hello Ross, why don't use: explain select . and you'll see what mysql is thinking... ;) -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

On Saturday 17 July 2004 09:31, Ross Honniball wrote: Attention all Sql gurus, Is there a way to FORCE mysql resolve specific conditions within a query before wasting it's time trying to resolve other conditions? www.mysql.com -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

[PHP-DB] HELP: mySQL table name

I need information about how can I get the table name from this query : select * from test_table as t when I use : $field=mysql_fetch_field($result, $i); $field-table return the name of the table as t but I need the real name of the table test_table. How can I do

Re: [PHP-DB] HELP: mySQL table name

From: Adrian Donoiu [EMAIL PROTECTED] I need information about how can I get the table name from this query : select * from test_table as t when I use : $field=mysql_fetch_field($result, $i); $field-table return the name of the table as t but I need the real name of the table

RE: [PHP-DB] Help MySQL server has gone away

I do not think php is the problem here. Take a look here http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Gone _away There are some good pointers on what to do... Regards Joakim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Help MySQL server has gone away

ok, I have a script that takes files from a HTTP post and loads them into a mySQL database. Whenever I try to load a file greater than a meg ot two, I get mySQL error #2006, MySQL server has gone away. I checked upload_max_filesize in php.ini and that's not the problem, also MAX_FILE_SIZE

[PHP-DB] HELP! (mysql)

hello, can one of you clever people guys 30 seconds to help a lady...? can someone just tell me the best way to create a new table in a mysql database? should i use the mysql_query() function? thank you boys, xxx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

RE: [PHP-DB] HELP! (mysql)

// -Original Message- // From: Duncan Abbott [mailto:[EMAIL PROTECTED]] // Sent: Friday, 26 October 2001 9:17 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] HELP! (mysql) // // // hello, // // can one of you clever people guys 30 seconds to help a lady...? // // can someone just tell me

[PHP-DB] Help ! MySQL Problem

Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " and it don't work ! Please help! Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] Help ! MySQL Problem

ok you must get your variables like row1, row2 etc from anywherelse then try this format too insert them at your db mysql_connect("localhost","username","password") or die ("cant connect database"); @mysql_select_db("databasename") or die("cant connect database"); mysql_query("INSERT INTO

Re: [PHP-DB] Help ! MySQL Problem

Thanks, but it doesn't work ! "Brinzoi Constantin Aurelian" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Thu, 8 Mar 2001, Rosen wrote: Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from