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