Php mysqli : update user where amount is less then x and delete query

Question

this one, it does delete where amount is less then 1 but it doesnt update user, why not? can anyone tell me?

$data1 = mysqlI_query($link,"SELECT * FROM bubble_spends where burst <= 0");
$data  = mysqli_fetch_array($data1);

$burst123='$data[burst]';
$username123='$data[username]';
IF($data1)
{
    mysqli_query($link,"UPDATE * FROM 'users' SET 'bitcoins'='bitcoins'-'$burst123' WHERE 'username' = '$username123' ");
    mysqli_query($link,"DELETE FROM bubble_spends where amount <= 1");
}

Greets Patrick

Touheed Khan · Answer 1 · 2018-02-09T18:59:27.677

0

Update query syntax is wrong, correct query

UPDATE users SET bitcoins=bitcoins- $burst123 WHERE username = '$username123'

Remove single quote(') from table and column name and use tick(`) instead. e.g. UPDATE * FROM 'users' SET 'bitcoins'='bitcoins'-'$burst123' WHERE 'username' = '$username123'
You are using this '$burst123' which is treated as string.

Updated Query :

$data1 = mysqli_query($link,"SELECT * FROM bubble_spends where burst <= 0");
$data  = mysqli_fetch_array($data1);

$burst123='$data[burst]';
$username123='$data[username]';
IF($data1)
{
    mysqli_query($link,"UPDATE `users` SET `bitcoins`=`bitcoins`- $burst123 WHERE `username` = '$username123' ");
    mysqli_query($link,"DELETE FROM bubble_spends where amount <= 1");
}

edited Feb 09 '18 at 18:59

answered Feb 09 '18 at 18:30

Touheed Khan

2,149
16
26

it still doesnt work i really try'd alot there are no output error's – Patrick Verkennis Feb 09 '18 at 18:37
in your update query you are using single quote around table and column name, like 'users' which is not right you have to use `users`. – Touheed Khan Feb 09 '18 at 18:40
try'd it without ' also. – Patrick Verkennis Feb 09 '18 at 18:42
`echo mysqli_error($link); exit;` after update query. and show me what error you are getting – Touheed Khan Feb 09 '18 at 18:43
still no error.. IF($data1) { mysqli_query($link,"UPDATE * FROM `users` SET `bitcoins`=`bitcoins`- $burst123 WHERE `username` = '$username123' "); mysqli_query($link,"DELETE FROM bubble_spends where amount <= 1"); } ELSE { echo mysqli_error($link); exit;} – Patrick Verkennis Feb 09 '18 at 18:53
mysqli_query($link,"UPDATE * FROM users SET bitcoins=bitcoins- $burst123 WHERE username = '$username123' "); echo mysqli_error($link); exit; use like this for debugging – Touheed Khan Feb 09 '18 at 18:55
have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* FROM users SET bitcoins=bitcoins- $data[burst] WHERE username = '$data[usernam' at line 1 – Patrick Verkennis Feb 09 '18 at 18:58
i try'd this now. $burst123=$data['burst']; $username123=$data['a_username']; IF($data1) { mysqli_query($link,"UPDATE users SET bitcoins=bitcoins-$burst123 WHERE username = $username123"); echo mysqli_error($link); exit; mysqli_query($link,"DELETE FROM bubble_spends where amount <= 1"); } because username is a double variable . i made from bubble_spends username changed to a_username. didnt work – Patrick Verkennis Feb 09 '18 at 19:05
UPDATE T1 SET T1.Address = T2.New_Address FROM T1 INNER JOIN T2 ON T2.ID = T1.ID i am trying to make this work now. but it isnt easy. – Patrick Verkennis Feb 09 '18 at 19:23
try this, $data1 = mysqli_query($link,"SELECT * FROM bubble_spends where burst <= 0"); $data = mysqli_fetch_array($data1); $burst123='$data[burst]'; $username123='$data[username]'; IF($data1) { mysqli_query($link,"UPDATE `users` SET `bitcoins`=`bitcoins`- $burst123 WHERE `username` = '$username123' "); mysqli_query($link,"DELETE FROM bubble_spends where amount <= 1"); } – Touheed Khan Feb 09 '18 at 19:24

Php mysqli : update user where amount is less then x and delete query

1 Answers1