I'm in OS X 10.2 (Jaguar) Apache/PHP/MySQL are all playing happily
together, so it's time to get some work done. From the MySQL client,
this query does what I expect it to:
update endpage set productname='Berenice lamp', bgcolor='eec472',
imgsrc='bereniceep.jpg', img_orientation='horizontal', cartlink='I
don\'t know yet', categorylink='lighting.html', catlinkimg='sex',
copy=' Since it was designed in 1985, the Berenice lamp has become a
classic, acquired by museums everywhere. Paolo Rizzatto and Alberto
Meda gave it a fully articulated and adjustable arm on a weighted
base either wall-mounted, clip-on or free standing. Finish colors may
be matte black or silver with green, blue, black, or silver diffuser
shade. Its 35-watt halogen bulb provides excellent task lighting in a
355-degree arc. The transformer is separated from the base, making
Berenice perfect for tight spaces. ', price='320',
titleimg='berenicetitle.gif' where id='5'
Now, I got that query by doing an <? echo $query ?> into an html page
and copying and pasting into the MySQL client, where the query
returns the expected result...
from the php page however, it does not work, even though it appears
to be generating a perfectly good querry... Here's the PHP
$connection = mysql_connect("server", "user", "pass") or
die("Couldn't connect.");
$db = mysql_select_db($db_name, $connection) or die("Couldn't select
database.");
$query = "update endpage set productname='$productname',
bgcolor='$bgcolor', imgsrc='$imgsrc',
img_orientation='$img_orientation', cartlink='$cartlink',
categorylink='$categorylink', catlinkimg='$catlinkimg', copy='$copy',
price='$price', titleimg='$titleimg' where id='$id'";
$result = mysql_query($query);
Can anybody explain that?
Michael
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
