Google
  Web www.spinics.net

Re: Re: [PHP-WIN] Re: Error while inserting data into mysql

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


On Tuesday, March 1, 2011, Richard Quadling wrote;

> Can you tell me what column in the table is scloth100_qty? I can't find it.

The issue here is probably that you have some PHP code that is passing
a SELECT statement to MySQL and that SELECT includes scloth100_qty in
its column list. One debugging technique that I find useful in such
situations is to echo the query to the output web page. So, if your
original code was:

  $result_table = mysql_query ($query, $link);

Then you might try inserting the line:

  echo "<p>$query</p>";

immediately before the call to mysql_query, i.e.:

  echo "<p>$query</p>";
  $result_table = mysql_query ($query, $link);

You can then examine the actual query being passed to MySQL and work
backwards from there to correct the issue.

HTH,

-- 
Geoff


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



[PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Plagiarism Notes]     [Postgresql]     [Yosemite News]

Powered by Linux