close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Syntax Error - Adding Product Details

Thread began 1/15/2012 11:14 am by greg_herr420504 | Last modified 1/18/2012 11:00 am by greg_herr420504 | 1499 views | 5 replies

Ray BorduinWebAssist

I don't see where the problem is, but I can try to help you narrow it down.

There are 4 recordsets on your page... this error is coming from when one of those queries is running on one of the lines that ends in:

or die(mysql_error());

die(); will stop the code processing at that point and write whatever string is passed to it. In this case it is writing the error string.

What you can do, is add code before each line that has that code like:

echo("Recordset 1 ");

and write before the second time the die() appears:

echo("Recordset 2 ");

and do the same for the third and fourth.

Then when you view the page again it will look something like:

Recordset 1 Recordset 2 Recordset 3 Unknown column '1' in where clause

This would narrow down that the error was in the third recordset.

Then you could remove all of your echo statements since you have narrowed it down and in place of the last echo statement you saw, add a die statement with the sql... so if it was recordset 3 you would replace it with:

die($query_rsSize);

This would write the full sql statement to the page that is being run. That should allow you to see what might be the problem with that sql statement and fix it.

If you get that far and can't spot the issue, try taking that sql statement into phpMyadmin and debug it in the Query window there... you can also post it back here and I might be able to spot the problem.


Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...