Advertisement
Advertisement
| 08.05.2008 at 09:35AM PDT, ID: 23622849 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: |
Why won't db update with new data in PHP code
i am using the attached code. it just spits out 4 form fields that pull data from db and will update the info if the data is changed in the input boxes. The first three boxes work just fine. The fourth box will not update at all unless I go to the db and change the value there. the value will be pulled into the input box, but if i change the value and click the "change", nothing happens, it will not update the value in that field.
<fieldset>
<legend>Update From Emails</legend>
<table class="intake" border="0">
<?
$prjSubmittedTo=getSelectValues('Q_125');
?>
<tr>
<td width="25%"><b>Project Submitted to</b> </td>
<td width="75%"><b>From Email</b></td>
</tr>
<?php
$prjSubmittedTo;
foreach ($prjSubmittedTo as $key=>$value)
{?>
<tr>
<td><?=$value?></td>
<td><input type="text" maxlength="50" size="50" name="<?=Field($value)?>" value="<?=getcurrentfromemails(Field($value))?>"></td>
</tr>
<?
}
?>
<tr>
<td> </td>
<td>
<input type="button" onclick="goTo('OPTIONS','emails');" value="Change">
</td>
</tr>
</table>
</fieldset>
=======================================
function updatefromemails($fromemails)
{
global $db;
$prjSubmittedTo = array();
$SubmittedTo=getSelectValues('Q_125');
foreach($SubmittedTo as $key=>$values)
{
array_push($prjSubmittedTo,Field($values));
}
foreach($fromemails as $key=>$values)
{
if(in_array($key,$prjSubmittedTo))
{
$query="select * from email where PROJECT_SUBMITTED_TO='$key'";
$result=mysql_query($query);
$numrows=@mysql_num_rows($result);
if($numrows>0)
{
$sql = "UPDATE email SET email='$values' where PROJECT_SUBMITTED_TO='$key'";
}
else
{
$sql ="INSERT INTO email (PROJECT_SUBMITTED_TO,email) VALUES ('$key','$values')";
}
mysql_query($sql,$db) or die("ERROR: " . mysql_error());
}
}
}
|