I'm sorry but I'm a newbie.

Can anyone tell me how can I run the following PHP Script sent by
Florian ? and which db setting do I have to select ?

Thanks

==========================================
 $abfrage = "SELECT ticket_id from article where
      a_subject = 'Re: Re: My details'
     OR a_subject = 'Re: Details'
     OR a_subject = 'Re: Approved'
     OR a_subject = 'Re: Wicked screensaver'
     OR a_subject = 'Re: That movie'
     OR a_body = 'See the attached file for details'
   ";

 $ergebnis  = mysql_query($abfrage);
 if(!$ergebnis)
  echo "Abfrage nicht korrekt: $abfrage<br>\n";

 while
 (
  list
  (
   $db_id
  )
  = mysql_fetch_row($ergebnis)
 )
 {
  $abfrage2 = "update ticket set ticket_state_id = '2' where id =
'$db_id'";
  $abfrage2 = mysql_query($abfrage2);
 }

==========================================

Luis Vazquez


_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Reply via email to