How could I do this?

Posted on 16th Feb 2014 07:03 pm by admin

Ive got a simple lottery game, and am using an sql database to keep track of the numbers bought. But, when the person comes to buy the ticket, I have to replay to my process page which ticket they want. How could I do this?

Code: <?php
session_start();
$page = array();
$page['title'] = 'OpenTheBox | DuffLotto';
$number = 1;
include('header.php');
require_once('/home/davespri/hidden/dbcon.php');

echo '<h1>OpenTheBox - The Original Community Game</h1>';
echo '<center>
Available Numbers
</center>';
$connect = mysql_connect($host, $user, $pass);
if (!$connect) {
die('Unable to connect to Mysql');
}
mysql_select_db('davespri_Gamerecords', $connect);
$result = mysql_query("SELECT * FROM OpenTheBox2");
echo "<center><table border='1'><tr><th>Slot:</th><th>Taken by:</th></tr>";
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
if ($row['Nickname'] = 'NULL') {
$row['Nickname'] = "<center><form action=http://dufflotto.hostcell.net method=post>
<input type=submit value=Buy! name=" . $row['Slot'] . ">
</form>";

}
echo "<td>" . $row['Slot'] . "</td>";
echo "<td>" . $row['Nickname'] . "</td>";
echo "</tr>";
}
echo "</center></table></center>";
include('footer.php');
?>

Your Answer:

Login to answer

Other forums

Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do

Call db table from any PHP file
Hi,

I want to be able to call a database table that will be setup in another file called init

Tracking Unique Clicks
Hi guys and gals,

Basically I have a database which tracks clicks on my outbound links, I do

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

Search with relational database
Hey,

I have quite a complicated (for me anyway ) relational database for an apartments syste

Uploading files/images via forms
Hey all, I am building a database for work that will contain some minor data on plant species along

Need help to identify this error please
:confused:Can anyone help me tell what this error message means? Maybe tell me where to look to fix