Another stupid newby question

[fuzzy1]

Hey All,
I spent half the day figuring out the following query:

$sql = 'UPDATE contacts, campaign_log'
        . ' SET contacts.invalid_email=1'
        . ' WHERE contacts.id=campaign_log.target_id'
        . ' AND campaign_log.activity_type="invalid email"';

... but, (here comes the stupid newb part) I have NO IDEA
how to execute it onClick from a link/button etc. in an html file.

Does the query need to reside in a seperate.php file (I don't think I dare change the file extension of the html file in question)? What would that look like?

Please :p

[scrypte]

easily

try this

switch ($_GET['update']) {
 case "contacts";
 $sql = 'UPDATE contacts, campaign_log'
        . ' SET contacts.invalid_email=1'
        . ' WHERE contacts.id=campaign_log.target_id'
        . ' AND campaign_log.activity_type="invalid email"'; 
mysql_query($sql);
break;
}

use the link index.php?update=contacts

[fuzzy1]

Thanks Jonathan!

I tried adding the following to ListView.html

<?php
switch ($_GET['update']) { 
case "contacts"; 
$sql = 'UPDATE contacts, campaign_log' 
        . ' SET contacts.invalid_email=1' 
        . ' WHERE contacts.id=campaign_log.target_id' 
        . ' AND campaign_log.activity_type="invalid email"'; 
mysql_query($sql); 
break; 
} 
?>
<!-- BEGIN: main -->
<table cellpadding="0" cellspacing="0" width="100%" border="0" class="listView">
<tr><td colspan="10" align="right"><a href="index.php?update=contacts&module=Contacts&action=index">Update Invalid Email</a>
</td></tr>

... which returns me to the appropriate page without errors, but does not update the reocords in the db. NO JOY.
What have I got wrong?

[scrypte]

How are your tables structured, so I can figure out exactly what you are updating. as well as what are the post variables.

[fuzzy1]

Sorry, I wish I understood what you were asking of me. As you may recall, the title of this post is "Another Stupid Newby Question."

I am working with Sugar CRM which is -- unfortunately -- pretty complicated.
There are 87 tables. I only know that the query in my original post works from phpMyAdmin. I hate being such a newb :mad:

[scrypte]

Ok well in order to post anything you need to figure out where the information thats being posted to the database, if you have that we can work from that, but right now im working blindly

[Houdini]

Ok it is possible that your update script are on the same page and it is also possible that they are two or more different pages. If you were to post the entire page it is possible to see what is happening with your script. So in short show the entire script and someone in these forums will be happy to help you out with your problem.

[fuzzy1]

Thanks Houdini,

Though I doubt the whole file is going to offer much insight, but what the heck?
Why NOT?
Here's ListView.html

<!--
/*********************************************************************************
 * The contents of this file are subject to the SugarCRM Public License Version
*****<snipped>***************************************************************************/
/*********************************************************************************
 * $Id: ListView.html,v 1.49 2005/11/19 00:37:05 clint Exp $
 ********************************************************************************/
-->
<?php
switch ($_GET['update']) { 
case "contacts"; 
$sql = 'UPDATE contacts, campaign_log' 
        . ' SET contacts.invalid_email=1' 
        . ' WHERE contacts.id=campaign_log.target_id' 
        . ' AND campaign_log.activity_type="invalid email"'; 
mysql_query($sql); 
break; 
} 
?>

<!-- BEGIN: main -->
<table cellpadding="0" cellspacing="0" width="100%" border="0" class="listView">
<tr><td colspan="10" align="right">Show 
<a href="index.php?module=Contacts&action=index&user_display_selection_count=10&module=Contacts&action=index">[10]</a>
<a href="index.php?module=Contacts&action=index&user_display_selection_count=20&module=Contacts&action=index">[20]</a>
<a href="index.php?module=Contacts&action=index&user_display_selection_count=50&module=Contacts&action=index">[50]</a>
<a href="index.php?module=Contacts&action=index&user_display_selection_count=100&module=Contacts&action=index">[100]</a>
<a href="index.php?module=Contacts&action=index&user_display_selection_count=200&module=Contacts&action=index">[200]</a>&nbsp;&nbsp;

<a href="index.php?update=contacts&module=Contacts&action=index">Update Invalid Email</a>
</td></tr>



<!-- BEGIN: list_nav_row -->
{PAGINATION}
<!-- END: list_nav_row -->
	<tr height="20">
		<td scope="col" class="listViewThS1" NOWRAP>{CHECKALL}</td>
		<td scope="col" class="listViewThS1"><slot><a href="{ORDER_BY}last_name" class="listViewThLinkS1">{MOD.LBL_LIST_NAME}{arrow_start}{last_name_arrow}{arrow_end}</a></slot></td>
		<td scope="col" class="listViewThS1"><slot><a href="{ORDER_BY}account_name" class="listViewThLinkS1">{MOD.LBL_LIST_ACCOUNT_NAME}{arrow_start}{account_name_arrow}{arrow_end}</a></slot></td>			
		<td scope="col" class="listViewThS1"><slot><a href='{ORDER_BY}contacts_cstm.VIP_c' class='listViewThLinkS1'>{MOD.VIP_c}{arrow_start}{contacts_cstm_VIP_c_arrow}{arrow_end}</a></slot></td>
		<td scope="col" class="listViewThS1" nowrap><slot><a href='{ORDER_BY}contacts_cstm.Cycle_c' class='listViewThLinkS1'>{MOD.Cycle_c}{arrow_start}{contacts_cstm_Cycle_c_arrow}{arrow_end}</a></slot></td>			
		<td scope="col" class="listViewThS1"><slot><a href='{ORDER_BY}contacts_cstm.MAO_c' class='listViewThLinkS1'>{MOD.MAO_c}{arrow_start}{contacts_cstm_MAO_c_arrow}{arrow_end}</a></slot></td>
		<td scope="col" class="listViewThS1"><slot><a href='{ORDER_BY}gag' class='listViewThLinkS1'>{MOD.LBL_GAG}{arrow_start}{gag_arrow}{arrow_end}</a></slot></td>			
		<td scope="col" class="listViewThS1"><slot><a href='{ORDER_BY}contacts_cstm.Referrals_c' class='listViewThLinkS1'>{MOD.Referrals_c}{arrow_start}{contacts_cstm_Referrals_c_arrow}{arrow_end}</a></slot></td>





	<!-- BEGIN: open_source -->
	<!-- END: open_source -->
	<td scope="col" class="listViewThS1"><slot><a href="{ORDER_BY}assigned_user_name" class="listViewThLinkS1">{APP.LBL_LIST_ASSIGNED_USER}{arrow_start}{assigned_user_name_arrow}{arrow_end}</a></slot></td>			
	<td scope="col" class="listViewThS1"><slot><a href='{ORDER_BY}contacts.date_modified' class='listViewThLinkS1'>{MOD.LBL_DATE_MODIFIED}{arrow_start}{contacts_date_modified_arrow}{arrow_end}</a></slot></td>

  </tr>

<!-- BEGIN: row -->
<tr height="20"  onmouseover="setPointer(this, '{CONTACT.ID}', 'over', '{BG_COLOR}', '{BG_HILITE}', '{BG_CLICK}');" onmouseout="setPointer(this, '{CONTACT.ID}', 'out', '{BG_COLOR}', '{BG_HILITE}', '{BG_CLICK}');" onmousedown="setPointer(this, '{CONTACT.ID}', 'click', '{BG_COLOR}', '{BG_HILITE}', '{BG_CLICK}');">
		<td class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}" valign='top'>{PREROW}</td>
   			<td scope='row' valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}"><slot><{TAG.MAIN} href="{URL_PREFIX}index.php?action=DetailView&module=Contacts&record={CONTACT.ID}&offset={CONTACT.OFFSET}&stamp={CONTACT.STAMP}"  class="listViewTdLinkS1">{CONTACT.NAME}</{TAG.MAIN}></slot></td>
   			<td valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}"><slot><{TAG.ACCOUNT} href="{URL_PREFIX}index.php?action=DetailView&module=Accounts&record={CONTACT.ACCOUNT_ID}"  class="listViewTdLinkS1">{CONTACT.ACCOUNT_NAME}</{TAG.ACCOUNT}></slot></td>			<td valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}" nowrap><slot>{CONTACT.VIP_C}</slot></td>
   			<td valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}"><slot>{CONTACT.CYCLE_C}</slot></td>			
   			<td valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}" nowrap><slot>{CONTACT.MAO_C}</slot></td>
   			<td valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}" nowrap><slot>{CONTACT.GAG}</slot></td>			
   			<td valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}" nowrap><slot><input type='checkbox' name='Contact.Referrals_c' id='Contact.Referrals_c'   value='1' disabled {CONTACT.REFERRALS_C_CHECKED}></slot></td>





		<!-- BEGIN: open_source -->
		<!-- END: open_source -->
		<td valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}" nowrap><slot>{CONTACT.ASSIGNED_USER_NAME}</slot></td>			<td valign=TOP class="{ROW_COLOR}S1" bgcolor="{BG_COLOR}" nowrap><slot>{CONTACT.DATE_MODIFIED}</slot></td>
</tr>
<tr><td colspan="20" class="listViewHRS1"></td></tr>
<!-- END: row -->
{PAGINATION}
</table>
<!-- END: main -->

[Weedpacket]

Moving to the Newbies' Forum.