Jump to content

[SOLVED] can only update one record

matthewst

By matthewst
in PHP Coding Help

Recommended Posts

matthewst Member

matthewst

Posted
Posted

I can only update one advertiser. It dosen't matter which one I choose I can then only update that one. I have to go into the database and delete the updated record to be able to update again.

 

Current code for layout_info.php

			<td align="center" valign="top" width="60"><font size="-2"><?
		$query_ads_rec_dates="SELECT ad_copy_rec FROM whiteboard_dates WHERE ad_id=$id"; 
		$result_ads_rec_dates=mysql_query($query_ads_rec_dates); 
		while ($row_ads_rec_dates = mysql_fetch_assoc($result_ads_rec_dates)) 
		{ 
		$ad_copy_rec_old = $row_ads_rec_dates['ad_copy_rec']; 
		}
            echo "$ad_copy_rec_old";?>
		<form method="post" action="table_layout_info_handler.php" enctype="multipart/form-data" name="FormName">
		<input type="hidden" name="table_id" value="<?php echo $table_id; ?>">
		<input type="hidden" name="ad_id" value="<?php echo $id; ?>">
		<input type="text" class="formTextbox" name="ad_copy_rec_new" size="24"/> 
            <input type="submit" class="formTextbox" name="submit" value="Submit Ad Copy Rec Date"> 
            </form></font></td>
		<?php
		$ad_copy_rec_old = "";
		?>

 

Current code for layout_info_handler.php

<?php
include('include/user_check.php'); 
include('include/db_con.php');
error_reporting(0); 
?>

<?php
$query_ads_rec_dates="SELECT ad_copy_rec FROM whiteboard_dates WHERE ad_id=$ad_id"; 
$result_ads_rec_dates=mysql_query($query_ads_rec_dates); 
while ($row_ads_rec_dates = mysql_fetch_assoc($result_ads_rec_dates)) 
{ 
$ad_copy_rec_old = $row_ads_rec_dates['ad_copy_rec']; 
}
    		if($ad_copy_rec_old == ""){ 
        	$sql = "INSERT INTO whiteboard_dates (rest_id, ad_copy_rec, ad_id) VALUES ('$table_id', '$ad_copy_rec_new', '$ad_id')"; 
        	$result = mysql_query($sql); 
    		} 
    		else{ 
        	$new = $ad_copy_rec_old.",".$ad_copy_rec_new; 
        	$sql = "UPDATE whiteboard_dates SET ad_copy_rec = '$new' WHERE ad_id='$ad_id'"; 
        	$result = mysql_query($sql); 
    		}
?> 
<script type="text/javascript">
location="table_layout_info.php?table_id=<?="$table_id"; ?>"
</script>

 

The only problem I have now is I can only update one advertiser.

Example:

 

advertiser 1 (no info)

advertiser 2 (no info)

advertiser 3 (no info)

 

I input info to advertiser 2

 

advertiser 1 (no info)

advertiser 2 blah blah

advertiser 3 (no info)

 

I input info to advertiser 2 again

 

advertiser 1 (no info)

advertiser 2 blah blah, more blah

advertiser 3 (no info)

 

I input info to advertiser 1 or 3

 

advertiser 1 (no info)

advertiser 2 blah blah, more blah

advertiser 3 (no info)

Link to comment
https://forums.phpfreaks.com/topic/59248-solved-can-only-update-one-record/
Share on other sites
matthewst Member

matthewst

Posted
  • Author
Posted

I gave the  script a major overhaul, still no luck.

 

here is the entire thing if that helps

<? 
include('include/user_check.php'); 
include('include/db_con.php'); 
error_reporting(0); 
?> 

<html> 
<head> 
<title>Whiteboard</title> 
<script language="javascript"> 
   function openNewWindow(url) { 
    window.open(url,'newPage','scrollbars=no,resizable=no,width=400,height=250'); 
   } 
  </script> 
</head> 
        <body bgcolor="white">
	<!--Timothy Matthews really did write me!! -->
        <script type='text/JavaScript' src='scw.js'></script> 
        <font face="Verdana, Arial, Helvetica, sans-serif"> 
        <div align="center"> 
            <table width="600" border="0" cellspacing="2" cellpadding="1" bgcolor="white"> 
                <tr> 
                    <td colspan="10" width="1343"> 
                         
                    <div id="popup"></div> 
                                <center>Whiteboard for<br> 
                                <?php 
                                $query="SELECT rest_name FROM abc_tables WHERE table_id=$table_id"; 
                                $result=mysql_query($query); 
                                while ($row = mysql_fetch_assoc($result)) 
                                { 
                                $rest_name = $row['rest_name']; 
                                } 
                                echo"$rest_name"; 
                                ?><br> 
                            <img src="thin_horiz_line.png" width="250" height="1"></center> 
                    </td> 
                </tr> 
                <tr> 
                    <td align="center" valign="bottom" width="60"><font size="-2">Advertiser</font></td> 
                    <td align="center" valign="bottom" width="20"><font size="-2">Ad Size</font></td> 
                    <td align="center" valign="bottom" width="75"><font size="-2">Contract Rec</font></td> 
                    <td align="center" valign="bottom" width="35"><font size="-2">Ad Copy Rec</font></td> 
                    <td align="center" valign="bottom" width="30"><font size="-2">Pict</font></td> 
                    <td align="center" valign="bottom" width="30"><font size="-2">Copy Sent Out</font></td> 
                    <td align="center" valign="bottom" width="60"><font size="-2">Approved</font></td> 
                </tr> 
                <tr> 
                    <td colspan="10" width="1343"> 
                        <div align="center"> 
                            <img src="thin_horiz_line.png"></div> 
                    </td> 
                </tr>            
            <tr> 
            <td colspan="10" width="1343"><div align="center"><IMG SRC="thin_horiz_line.png"></div></TD> 
            </TR> 
            <tr> 
            <?
		$query_ads="SELECT id, company, size, date_ordered, date_approved FROM ad_order WHERE cust_id=$table_id"; 
		$result_ads=mysql_query($query_ads); 
		while ($row_ads = mysql_fetch_assoc($result_ads))
		{ 
   			$id = $row_ads['id']; 
   			$company = $row_ads['company']; 
   			$ad_size = $row_ads['size']; 
   			$contract_rec = $row_ads['date_ordered']; 
   			$approve = $row_ads['date_approved']; 
   			$approved_date = date('m/d/y',$approve);

		echo "<td align='center' valign='top' width='80'><font size='-2'>$company</font></td>";
		echo "<td align='center' valign='top' width='60'><font size='-2'>$ad_size</font></td>";
		echo "<td align='center' valign='top' width='60'><font size='-2'>$contract_rec<br></font></td>";
			$query_ads_rec_dates="SELECT ad_copy_rec FROM whiteboard_dates WHERE ad_id='$id'"; 
			$result_ads_rec_dates=mysql_query($query_ads_rec_dates); 
			while ($row_ads_rec_dates = mysql_fetch_assoc($result_ads_rec_dates)) 
			{ 
			$ad_copy_rec_old = $row_ads_rec_dates['ad_copy_rec']; 
			}
		echo "<td align='center' valign='top' width='60'><font size='-2'>$ad_copy_rec_old</font>";
		$ad_copy_rec_old = "";
		echo "<form method='post' action='table_layout_info_handler.php' enctype='multipart/form-data' name='FormName'>
			<input type='hidden' name='table_id' value='$table_id'>
			<input type='hidden' name='ad_id' value='$id'>
			<input type='text' class='formTextbox' name='ad_copy_rec_new' size='24'/> 
            	<input type='submit' class='formTextbox' name='submit' value='Submit Ad Copy Rec Date'> 
            	</form></td>";            
		echo "<td align='center' valign='top' width='60'><font size='-2'><br></font></td>";
			$query_ads_dates="SELECT ad_id, action, time FROM job_log WHERE ad_id=$id"; 
			$result_ads_dates=mysql_query($query_ads_dates); 
			while ($row_ads_dates = mysql_fetch_assoc($result_ads_dates)) 
			{ 
			$action = $row_ads_dates['action']; 
			$upload = $row_ads_dates['time']; 
			$upload_date = date('m/d/y',$upload); 
			} 
            	if ($action == "999" || $action == "208"){ 
            echo "<td align='center' valign='top' width='60'><font size='-2'>$upload_date<br></font></td>"; 
            	} 
            	else 
			{ 
		echo "<td align='center' valign='top' width='60'><font size='-2'><br></font></td>";
			}	
			$query_ads_rec_dates="SELECT ad_copy_rec FROM whiteboard_dates WHERE ad_id='$id'"; 
			$result_ads_rec_dates=mysql_query($query_ads_rec_dates); 
			while ($row_ads_rec_dates = mysql_fetch_assoc($result_ads_rec_dates)) 
			{ 
			$approve = $row_ads['date_approved'];
			} 
            echo "<td align='center' valign='top' width='60'><font size='-2'>$approve<br></font></td></tr>";
			} 
            ?>             
              
<TR> 
<td colspan="10" width="1343"><div align="center"><IMG SRC="thin_horiz_line.png"></div></TD> 
</TR> 
</TABLE> 
</body> 
</html>

 

and here is the handler

<?php
include('include/user_check.php'); 
include('include/db_con.php');
error_reporting(0); 
?>

<?php
$query_ads_rec_dates="SELECT ad_copy_rec FROM whiteboard_dates WHERE ad_id=$ad_id"; 
$result_ads_rec_dates=mysql_query($query_ads_rec_dates); 
while ($row_ads_rec_dates = mysql_fetch_assoc($result_ads_rec_dates)) 
{ 
$ad_copy_rec_old = $row_ads_rec_dates['ad_copy_rec'];
} 

    		if($ad_copy_rec_old == ""){ 
        	$sql = "INSERT INTO whiteboard_dates (rest_id, ad_copy_rec, ad_id) VALUES ('$table_id', '$ad_copy_rec_new', '$ad_id')"; 
        	$result = mysql_query($sql); 
    		} 
    		else{ 
        	$new = $ad_copy_rec_old.",".$ad_copy_rec_new; 
        	$sql = "UPDATE whiteboard_dates SET ad_copy_rec = '$new' WHERE ad_id='$ad_id'"; 
        	$result = mysql_query($sql); 
    		}

?> 
<script type="text/javascript">
location="table_layout_info.php?table_id=<?="$table_id"; ?>"
</script>

matthewst Member

matthewst

Posted
  • Author
Posted

I tried echoing everything and it was all coming out fine. I was about to past the query into phpmyadmin, just for s and g's when obyno (phpbuilder) told me the main problem was the primary key in my table, rest_id. It was only allowing unique entries. Once I changed it to allow duplicates everything worked.

 

thanks everyone for your help

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.