[PHP] error with REPLACE or UPDATE
Hello,
I getting dificulties with an updating records procedure: like I have an
Auto-Increment field I try to use the REPLACE (but without the the
auto-increment I tried also UPDATE). I checked also the variables with
an echo, and also all the usual things I could imagine...
Now I am quite desperate.
Here you are my code. Thanks to evrybody
Marc
$connect = mysql_connect(xx); or die ("dBase not connect.")
$db = mysql_select_db("dBASE", $connect) or die ("dBase not select.");
$total_price = $qty * $price;
$date = date("Y-m-d");
$sql = "REPLACE CLIENT SET ID = \"$id\", ITEM = \"$item\", TITLE
=\"$title\", AUTHOR = \"$author\", PUBLISHER = \"$publisher\", DELIVERY
= \"$delivery\", QTY = qty\", PRICE = \"$price\", TOTAL_PRICE =
\"$total_price\", DATE = \"$date\", RECORD\"$record\" WHERE RECORD =
\"$record\"";
$sql_result = mysql_query($sql,$connect) or die ("Couldn't update!");
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] A lot of records
Hi, After a querry on a dBase I get to much result to insert them in one page, so I have to count them in blocks of, let say 20 records; I used the count() function to get the number of records in result, but I don't figure what to do after... Regards and thanks for your help Marc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Include & Speed
Hi everybody, How much the include() can slow down the execution of the scripts; if I call one file let say for the db connection it's clearly ok but is it a limite of numbers of include in one script from where that slow the process? Marc -- /*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/* /* Marc Fourny /* /* Multimedia Development for the web /* /* & /* /*CD-ROM/* /* Fourny ElectronicEDiting /* /*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
Re: [PHP] php and flash 5 books?
Hi Jay, Julie Melonie participate to the redaction of a book on FLASH 5; see infos on her website at http://www.thickbook.com you can also find there some tutorial on the subject. Marc Jay Paulson wrote: > > Anyone know of any good books that actually deal with php interfacing with > flash 5? I've found one book but just curious if there are others out > there... > > thanks, > jay -- /*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/* /* Marc Fourny /* /* Multimedia Development for the web /* /* & /* /*CD-ROM/* /* Fourny ElectronicEDiting /* /*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
Re: [PHP] Just a thanks
YES, it's true this list is realy cool, every one get help in an effective maner; even beginers in PHP like me. A major THANK YOU for all of you... Marc Josh G wrote: > > Just a thanks to everyone on this list, for being helpful, and for > being tolerant. It seems it's a rare thing these days. > -- /*==*/ /* Fourny ElectronicEDiting (FEED) */ /* */ /*Multimedia development for CD-ROM & the WEB */ /*Marc + Jacqueline Fourny */ /* */ /* http://www.bluekangaroo.ch (your English Bookshop) */ /* */ /*==*/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
