MySQL Forums
Forum List  »  Newbie

Re: problems with updates via php
Posted by: stefan loeffler
Date: September 04, 2004 09:57AM

if($_GET['action']=="invert") {
$sql="UPDATE t_plaetze set t_plaetze.stat=NOT(t_plaetze.stat) WHERE t_plaetze.auffuehrung='$zeit' AND t_plaetze.sektion='$sek' AND t_plaetze.reihe='$r'";
$result = mysql_query($sql);
echo "query reply:"; var_dump($result);
echo "<br>affected:".mysql_affected_rows();
}


// the values sent to this query are correct ones ... so the problem isnt there.
// the same query works perfeclty well - no matter how many after each other and in
// what time - when i use set t_plaetze.stat='0'


ty for the interest

stefan

Options: ReplyQuote


Subject
Written By
Posted
September 04, 2004 06:52AM
September 04, 2004 09:42AM
Re: problems with updates via php
September 04, 2004 09:57AM
September 04, 2004 10:04AM
September 04, 2004 11:48AM
September 06, 2004 09:23AM
September 07, 2004 01:58AM
September 04, 2004 11:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.