Re: Re: Error while inserting data into mysql
| From: | Geoff Lane | Date: | Tue, 01 Mar 2011 11:23:14 +0000 |
| Subject: | Re: Re: Error while inserting data into mysql | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47703@lists.php.net to get a copy of this message | ||
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