RE: Unknown Table i field list

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> -----Original Message-----
> From: Kranthi Krishna [mailto:kranthi117@xxxxxxxxx]
> Sent: Monday, October 11, 2010 5:40 PM
> To: Gary
> Cc: php-general@xxxxxxxxxxxxx
> Subject: Re:  Unknown Table i field list
> 
> echo $query;
> before
> $result = mysqli_query($dbc, $query);
> might be of help to understand what is going wrong
> 
> copy that query and execute in phpMyAdmin
> 

Or if you're on Windows, use the MySQL workbench (I don't know if it's
available on other platform) to create your sql statements.  For select, you
can do a test run of the query to see how well your DB & sql query is
optimized ;) so you'll get the idea of where any performance bottleneck is
later on :).  For example, my 2 table join select statement of 3684 rows has
initial execution time of 0.031 sec with fetch of 0.016 sec.  Subsequent
runs have 0.000 and 0.000, respectively.  Also, if you use the workbench, it
will encapsulate the fields and table(s) with ` so you know that your will
query should run without any possible mishap such as where you may have a
column name of 'name'.  Another plus is speed of which you can accurately
create your queries on the workbench.

Regards,
Tommy


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux