Purchasing script help

[valiantofficer]

I need to get a script together that will buy a "ticket" from my website, and then will update the mysql database to reflect that a ticket has been sold. So far, I have this as my main page:

<?php

mysql_connect(localhost,root,toor);

mysql_select_db(games_;
echo"<center>";

include("image1.php");

$sql="Select * from ballgames";

$num=mysql_numrows($result);

$i=0;

echo "<center>
<table border=3>

<tr>

<td>Game Date

<td>Game Time

<td>Teams Playing
<td>Tickets Available
<td>Buy Tickets

</tr>";

while ($data=mysql_fetch_assoc($result))
{

$id=mysql_result($result,$i,'gameid');

$gamedate=mysql_result($result,$i,'gamedate');


$gametime=mysql_result($result,$i,'gametime');


$teams=mysql_result($result,$i,'teams');



$tickets=mysql_result($result,$i,'tickets');

echo "<center> Welcome to the Admin main page.";

echo "<center>
<table border=3>


echo "

<tr>

<td>$gamedate

<td>$gametime

<td>$teams

<td>$tickets
<td><a href=buy.php?id=$data[id]>Buy Tickets</a>

</tr>

</table>";

$i++;
}

echo"<a href=admin.php>Admin Page</a>
";

?>

 

 

Next, I need to get to the point where a script called buy.php will let me 1:Record a ticket sale, and 2:Send the user to a register page so I can keep their information so they can log in to buy some more tickets. Any ideas?

[valiantofficer]

bump