Hi everyone and Happy New Year to one and all!!
I’m having a bit of trouble getting this to work.
What I am trying to achieve (but failing!) is to implement a quick order form on a page whereby the customer fills in the part number, this is then checked with the MySQL database which sends back the product details, description, price etc and a buy link so that they can click and buy the item.
I have the database working so that you select the products you want to view by using the css drop down menus. I want to use the same database and do a search by part number that will let the customer quickly order a product by the part number, checking with the database that it is a valid part.
I’ve got a simple form that does a search on the database, but I seem to have hit a brick wall because no matter how I configure the query I keep getting this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource…
I’m using the MySQL Get Records action, as used in the Axiom Widgets tutorial (it’s working for the menu items), it just doesn’t seem to work for the search.
Have a look at this…
This is the query in the “Build SQL here” in the Action on the results page.
SELECT cesproducts.*, cesprices.price FROM cesproducts, cesprices
partnumber = ‘$qspartnumber’
AND cesproducts.partnumber = cesprices.partnumber
The Form Setup on the Quick Order Form page is set to “POST” and the Action to the results page.
There is obviously something I’m doing wrong, but I can’t seem to find what it is, maybe I’ll have to attack this from a different angle to get it working. I also need to validate the search before it is sent.
Thank you in anticipation, and apologies for the long post.
dynamo mailing list
Update your subscriptions at: