I have this partial code:
if ($ getRecords = $ con- & Gt; Create ("Choose which one from Auction article =?")) {$ GetHtml = $ con- & gt; Prepare ("Choose from ARTICLE_DESC, where ARTICLE_NO =?"); $ GetHtml-> Tie-up ("i", $ pk); $ GetHtml-> Executed (); $ GetHtml-> Bind_result ($ ARTICLE_DESC); $ GetRecords- & gt; Bind_param ("i", $ pk); $ GetRecords- & gt; Executed (); $ GetRecords- & gt; Bind_salt ($ ARTICLE_NO, $ ARTICLE_NAME, $ SUBTITLE, $ CURRENT_BID, $ START_PRICE, $ BID_COUNT, $ QUANT_TOTAL, $ QUANT_SOLD, $ ACCESSSTARTS, $ ACCESSENDS, $ ACCESSORIGIN_END, $ USERNAME, $ BEST_BIDDER_ID, INFINISHED, $ Watch, $ BUYITNOW_PRICE, $ PIC_URL, PRIVATE_AUCTION $ $ AUCTION_TYPE, $ ACCESSINSERT_DATE, $ ACCESSUPDATE_DATE, $ CAT_DESC, $ CAT_PATH, $ COUNTRYCODE, $ LOCATION, $ CONDITIONS, $ REVISED, $ PAYPAL_ACCEPT, $ PRE_TERMINATED, $ SHIPPING_TO, $ FEE_INSERTION, $ FEE_FINAL, $ FEE_LISTING, $ PIC_XXL, $ PIC_DIASHOW, $ PIC_COUNT, $ ITEM_SITE_ID);
Which is otherwise ok, though I get an error:
Number of bind variable does not match the number of fields in the queue ready
I posted in the last line.
I'm not sure what the problem is. I want to separate some columns, such as ARTICLE_DESC, can not I use the selection *, and put it in the names of each column in the query?
Edit: Is it bound to be bound? Are there security or performance advantages to achieve? Do you really want to set the names of columns, rather using it? *.
In this way, you will know which column passes through the Bind_result method.
Comments
Post a Comment