how do I execute an SQL query in PHP

[StanleyDev]

so i was wondering if someone could make a php code to run an SQL query when the user clicks a button. I have written the sql query in php already i just have no clue how to excute it, also could someone tell me if this php code works? :

 $Suser = ('"/userme.php"');

^^^^^^^^^ this code is to check that page for the user's username to use within this sql query:

$id = mysql_query ("SELECT $Suser FROM users;");

^^^^^^^^ will this work?

 

[Alam]

("SELECT users FROM users");

That should work.

 

[StanleyDev]

("SELECT users FROM users");

That should work.

but how would i choose a specific user when they enter a page?

 

[brsy]

$id = mysql_query("SELECT . '$Suser' . FROM users");

 

[Deviant]

but how would i choose a specific user when they enter a page?

I don't know but from what the code looks like maybe ("SELECT username FROM users")

 

[StanleyDev]

I don't know but from what the code looks like maybe ("SELECT username FROM users")

ok, and do you know how i could execute the sql querys when the users press's the button?

 

[Alam]

but how would i choose a specific user when they enter a page?

("SELECT * FROM users WHERE username='$username'")

That is an idea of what you are asking for.

 

[brsy]

Simply create a new page, and type:

<?php
header('Location: http://link.com/fileYouCreate.php');
?>

 

[Deviant]

ok, and do you know how i could execute the sql querys when the users press's the button?

What are you trying to create? A random users page? ( Since it's in Habbo section )

 

[StanleyDev]

no im trying to create a lotto system, i got everything but how to send the 2 query's (1 for username id and number) and (to deduct the coins)