help with a query , is this correct ?

[corsacrazy]

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 ?

[tnguy3n]

there's a space in between probid_auctions and b in line

FROM probid_auctions b WHERE b.id='".$relistId."'") or die(mysql_error());

maybe that causes the error.

[corsacrazy]

afraid that didnt sort it mate

[Xenon]

you cannot insert into the table you are using within your select query.