possible

rizzah00

is it possible to resinsert data into a new table(s) and then delete the data that it was inserted from?

I have this table

TABLE results (
id int(25) NOT NULL auto_increment,
week int(10) NOT NULL default '0',
email varchar(32) NOT NULL default '',
hometeam int(25) NOT NULL default '0',
awayteam int(25) NOT NULL default '0',
homescore int(25) NOT NULL default '0',
awayscore int(25) NOT NULL default '0',
qb1name varchar(32) NOT NULL default '',
qb1yards int(25) NOT NULL default '0',
hteamname varchar(25) default NULL,
ateamname varchar(25) default NULL,

And i want to insert the qb1name and qb1yards into a statistics table and then i want to insert a win or loss into my teams win/loss section on a different table depending on the scores, is this possible and how do i go about doing it?

ScubaKing22

Your question is quite unclear to me...could explain in more detail?

rizzah00

i have a page that has queried the data once it pulled all that data from the table and is displaying it on the page, i want like a button or something where i press it and some of the data goes off to one table and other data goes off to another, and then it deletes the data from the first table...

rizzah00

Here's what i have so far, but even that doesnt work...

<?
function team_array() {
   $r = mysql_query("SELECT * FROM `teams`");
   $o = array();
   while ($row = mysql_fetch_assoc($r)) {
      $id = $row['team_id'];
      $o[$id] = $row;
   }
   return $o;
}
?>



<html>
<head>
<title>content</title>
<link rel="stylesheet" href="madden.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<style type="text/css">
<!--

BODY {
scrollbar-base-color:#396193;
scrollbar-face-color:#396193;
background:#396193;
}

-->
</style>
<div class="storycontent">
<p>on this page we will be able to validate results</p>
<table class="storycontent">

<?php
mysql_connect("localhost", "user", "pass");
mysql_select_db("database");
 if (isset($_GET['id']) && $_GET['id'] != '') {
 $query = "select * from results where `id`={$_GET['id']}";
 $result = mysql_query($query);

$teams = team_array();
$echoed = array();
while ($row = mysql_fetch_assoc($result)) {
   if (!in_array($row['id'], $echoed)) {
      $echoed[] = $row['id'];
      $aid = $row['awayteam'];
      $hid = $row['hometeam'];
	  $weekid = $row['id'];
      echo <<<EOF
<tr>

   <td><a href='game.php?id=$weekid'>ID: {$row['id']}</a></td>
   <tr>
   <td>week: {$row['week']}</td></tr>
   <tr>
   <td>Email Of Reporter: {$row['week']}</td></tr>
   <tr>
   <td>Hometeam:{$teams[$aid]['name']}</td></tr>
   <tr>
   <td>Home Team Score: {$row['homescore']}</td></tr>
   <tr>
   <td>Away team: {$teams[$hid]['name']} </td></tr>
   <tr>
   <td>Away Team Score: {$row['awayscore']}</td></tr>
   <tr>
   <td>Starting Quarterback: {$row['qb1name']}</td></tr>
   <tr>
   <td>- {$row['qb1yards']} yds</td></tr>
   <tr>
   <td class="storycontent">
   <input type="submit" name="submit" value="submit">
   </td>
   </tr>


EOF;

   }
}
}





?>



<?php

   if (isset($_GET['submit'])) { 
	$insert = "INSERT INTO QB (
	qb_name
	qb_yards)
	VALUES (
	'".$GET['qb1name']."',
	'".$GET['qb1yards']."')";
	$add_result = $db_object->query($insert);
	if (DB::isError($add_result)) {
			die($add_result->getMessage());
		}

	$db_object->disconnect();
?>
<p>Thank you, your results have been added to the database, and we will review them within a day.</p>

<?php

} else {	// if form hasn't been submitted
}
?>

drawmack

see the mysql manual on inserting selects. You can do the select and the instert in a single sql statment and then do the delete.

rizzah00

Originally posted by drawmack
see the mysql manual on inserting selects. You can do the select and the instert in a single sql statment and then do the delete.

ive been there and couldnt find what i was looking for