Thx for ur quick help.... I will check after a short nap *ggg* > -----Ursprüngliche Nachricht----- > Von: DL Neil [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 4. März 2002 11:03 > An: Andreas Dau > Betreff: Re: syntax Q > > Hello Andreas, > > > > I just encountered the following: let $a be a numeric php > expression, > > a > > > the corresponding integer field in a table. When I say: "UPDATE > table > > > SET a=$a" it denies the update. When I say: "Update table SET > a='$a'" > > it > > > performs the update. Uhm, now I am wondering. Isn't 'something' > > supposed > > > to be a string? > > > > > > Agreed. > > What does the SQL CREATE statement look like? > > What does PHP's assignment of value to $a (and relevant statements > > leading up to it) look like? > > Are you sure (the PC thinks) they are both integers? > > > Created with phpmyadmin, column type integer(10). Value to be inserted > comes from a method=post script at no point treated other as a > numeric... > > =uh-oh, my theory is looking shaky!? > However such conclusion (numeric) may not be the case. Try running the > 'form' and inserting a specific integer value, eg 7. > Put a debug routine like this into the PHP after the POST is processed > and before the MySQL call: > > echo "Value of a appears to be $a~"; > if ( $a == 7 ) { echo " PHP says it is seven"; } > else { echo " PHP says it is not seven"; } > if ( $a === 7 ) { echo " PHP says it is integer seven "; } > else { echo " PHP says it is not integer seven "; } > echo "<BR>"; > > (code not syntax checked) > > Please advise, > =dn
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
