SQL query

[StanleyDev]

Im making a lotto system, and I have made most of the code but I just cant figure out how to send the SQL query into the DB to record the number that user choose/and to remove the appropriate number of lotto points(made a currency as well).

The query codes are:

<?php
          $db = mysql_query ("INSERT INTO `lottery` (`id`, `username`, `num`) VALUES ('$uid','$id','$finalnum');"); 
          $db2 = mysql_query ("UPDATE `users` SET `lotto_points`='0' WHERE (`id`='$uid');"); // Remove 24 lotto point from the user, poor thing.
          ?>

I want it to send when the user clicks on a button

Could someone please write a code for a button so it could execute these query's when it is clicked.

 

[Alam]

if(isset($_POST['buttonname'])
{
  $query = "INSERT into 'lottery' ('table') , ('values') ";
}
else
...

 

[StanleyDev]

if(isset($_POST['buttonname'])
{
  $query = "INSERT into 'lottery' ('table') , ('values') ";
}
else
...

so do i replace $query with $db?
and im guessing this isnt for multi query's? likesend multiply at the same time?

 

[Alam]

so do i replace $query with $db?
and im guessing this isnt for multi query's? likesend multiply at the same time?

I only gave you the example , into the isset you type the queries you want to run..

 

[StanleyDev]

I only gave you the example , into the isset you type the queries you want to run..

so i could do this:

if(isset($_POST['buttonname'])
{
  $db = "INSERT INTO `lottery` (`id`, `username`, `num`) VALUES ('$uid','$id','$finalnum');"
  $db2 = "UPDATE `users` SET `lotto_points`='0' WHERE (`id`='$uid');"
}
else

 

[Alam]

so i could do this:

if(isset($_POST['buttonname'])
{
  $db = "INSERT INTO `lottery` (`id`, `username`, `num`) VALUES ('$uid','$id','$finalnum');"
  $db2 = "UPDATE `users` SET `lotto_points`='0' WHERE (`id`='$uid');"
}
else

Yes.

 

[StanleyDev]

Yes.

thanks alot

 

[StanleyDev]

uhm im getting this error now: Parse error: syntax error, unexpected T_VARIABLE in C:\xampp\htdocs\llot.php on line 133

Line 133 =

$db = ("INSERT INTO `lottery` (`id`, `username`, `num`) VALUES ('$uid','$id','$finalnum');");