The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
help with a query , is this correct ?
here is the query
[sql]if ($_GET['option']=="relist") { $relistId = $_GET['id']; $today = date( "Y-m-d H:i:s", time() ); $closingdate = closingdate($today,$_GET['duration']); $relistAuction = mysql_query("INSERT INTO probid_auctions (itemname, description, picpath, quantity, auctiontype, bidstart, rp, rpvalue, bn, bnvalue, bi, bivalue, duration, country, zip, sc, scint, pm, category, active, payment_status, startdate, enddate, closed, keywords, nrbids, maxbid, clicks, ownerid, hpfeat, catfeat, bolditem, hlitem, private, currency, swapped, postage_costs, insurance, type_service, isswap, acceptdirectpayment, directpaymentemail, addlcategory, deleted) SELECT itemname, description, picpath, quantity, auctiontype, bidstart, rp, rpvalue, bn, bnvalue, bi, bivalue, duration, country, zip, sc, scint, pm, category, active, payment_status, startdate, enddate, closed, keywords, nrbids, maxbid, clicks, ownerid, hpfeat, catfeat, bolditem, hlitem, private, currency, swapped, postage_costs, insurance, type_service, isswap, acceptdirectpayment, directpaymentemail, addlcategory, deleted FROM probid_auctions b WHERE b.id='".$relistId."'") or die(mysql_error()); $newId = mysql_insert_id();[/sql] and here is the error i get from it INSERT TABLE 'probid_auctions' isn't allowed in FROM table list any ideas ? |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|