A little simple PHP help...

Discussion in 'PHP' started by JoseYe, Mar 10, 2008.

0
Page 2 of 2
  1. lawrenz

    lawrenz Peon

    Messages:
    246
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #21
    $query = "UPDATE tb_ads SET ad_url='$url', ad_description='$description', clicksleft='{$_POST['clicksleft']}', premium='{$_POST['premium']} WHERE ad_id='$id'"; <-- you have an error on your premium, no ' ending before WHERE

    mysql_query($query) or die(mysql_error());

    try this:
    $clicksleft= $_POST['clicksleft'];
    $premium = $_POST['premium'];
    $id = $_POST['id']; <-- must include it in hidden or on a read only textfield so that so that you have a base what row to download. =)

    $sql = "UPDATE tb_ads SET ad_url='$url', ad_description='$description', clicksleft='$clicksleft', premium='$premium' WHERE ad_id='$id'";
    if(!$q = mysql_query($sql))
    {
    die("Error:" . mysql_error());
    }
    else
    {
    echo "Update successfull...";
    }
     
    lawrenz, Mar 24, 2008 IP
  2. andrepcg

    andrepcg Peon

    Messages:
    78
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #22
    it doesn't work... now there is no error but there is no update too. the modified ads is not modified
     
    andrepcg, Mar 24, 2008 IP
Page 2 of 2