[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] Re: [PHP-WIN] Re: Error while inserting data into mysql
From:       nagendra prasad <nagendra802000 () gmail ! com>
Date:       2011-03-01 11:44:43
Message-ID: AANLkTi=dn19zbePYKEb0yP3_wu3q+PmtTERAXH36NMOD () mail ! gmail ! com
[Download RAW message or body]


Thanks Geoff Lane, I saw my mistake. Their was no scloth100_qty in my mysql
table. Once again Thanks buddy :)


On Tue, Mar 1, 2011 at 4:53 PM, Geoff Lane <geoff@gjctech.co.uk> wrote:

> 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
>
>


[prev in list] [next in list] [prev in thread] [next in thread]