FeralReason

Alright -- never mind. Don't know what happened but it is working now. Perhaps the previous output was from the older browscap.ini. At any rate, this is the output I now get, which looks fine: browser_name_regex - ^mozilla/5\.0 (windows; .*; windows nt 5\.1; .*; rv:1\.9\..*) gecko/.* firefox/3\.5.*$ browser_name_pattern - Mozilla/5.0 (Windows; *; Windows NT 5.1; *; rv:1.9.*) Gecko/* Firefox/3.5* parent - Firefox 3.5 platform - WinXP win32 - 1 browser - Firefox version - 3.5 majorver - 3 minorver - 5 frames - 1 iframes - 1 tables - 1 cookies - 1 javaapplets - 1 javascript - 1 cssversion - 3 supportscss - 1 alpha - beta - win16 - win64 - backgroundsounds - cdf - vbscript - activexcontrols - isbanned - ismobiledevice - issyndicationreader - crawler - aol - aolversion - 0

Ah.. the last time this happened to me was because the new site's DNS settings were pointing to the hosting service's default IP instead of my IP address. Could be you reset the DNS to point to your IP address and it just took a few hours for that to be updated by the hosting service.

Should have included this: The version of browscap I downloaded was php_browscap.ini (http://browsers.garykeith.com/stream.asp?PHP_BrowsCapINI.) Is there a better one ? Thanx, Glenn

Thanks for the quick reply. The output I have posted is already from that browcap.ini. I had already downloaded it this morning. (That was my first guess too.) Is there, by any chance, a newer one than that. Thanx, Glenn

Any help on this would be appreciated ! When I echo $_SERVER['HTTP_USER_AGENT']; I get the following: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.9) Gecko/20100315 Firefox/3.5.9 ( .NET CLR 3.5.30729) I can clearly tell from this that I am using Firefox 3.5.9. HOWEVER, when I use get_browser(), I get back an array that has no reference (that I can understand) to Firefox 3.5.9. How come ?? Here's a dump of my get_browser() output. browser_name_regex - ^mozilla/5\.0 (windows; .; windows nt 5\.1; .*rv:1\.9.*) gecko/.*$ browser_name_pattern - Mozilla/5.0 (Windows; ?; Windows NT 5.1; *rv:1.9*) Gecko/* parent - Mozilla 1.9 platform - WinXP win32 - 1 browser - Mozilla version - 1.9 majorver - 1 minorver - 9 alpha - 1 frames - 1 iframes - 1 tables - 1 cookies - 1 javaapplets - 1 javascript - 1 cssversion - 2 supportscss - 1 beta - win16 - win64 - backgroundsounds - cdf - vbscript - activexcontrols - isbanned - ismobiledevice - issyndicationreader - crawler - aol - aolversion - 0 (I'm testing this from localhost on xampp. Still trying to get my live server to change the php.ini file so that I can see browscap.ini but I'm guessing this should make no difference.) Thanx, Glenn

Thanks much. That clarifies it for me. For the sake of others, here's the final code: $orderid = $_GET ['var']; if($orderid){ $mysqli=getDBconnection(); // START DB activity (my function) $delete_qry = "DELETE FROM orders WHERE orderid = '".$orderid."'"; $result = mysqli_query($mysqli, $delete_qry) // Note using mysqli_query -- not mysql_query or die(mysqli_error($mysqli)); if($result){ $count = mysqli_affected_rows($mysqli); } if($count>0){ echo "ORDER ".$orderid." DELETED.<br>"; } else{ echo "ORDER ".$orderid." not found.<br>"; } $delete_qry = "DELETE FROM order_items WHERE orderid = '".$orderid."'"; $result = mysqli_query($mysqli, $delete_qry) // mysqli_query returns TRUE on success or die(mysqli_error($mysqli)); if($result){ $count = mysqli_affected_rows($mysqli); } if($count>0){ echo $count."ORDER ITEMS(s) for ".$orderid." DELETED.<br>"; } else{ echo "No ORDER ITEMS for order ".$orderid." found.<br>"; } mysqli_close($mysqli); // close connection to MySQL } else{ echo "NO RECORD SELECTED. PLEASE SELECT A RECORD.<br>"; }

Just put together a delete order function (which seems to delete orders appropriately) but I am noticing that, when using the mysqli_query function with a DELETE query, it returns TRUE whether or not records are found to delete. Is this what I should expect ? $orderid = $_GET ['var']; if($orderid){ $mysqli=getDBconnection(); // START DB activity $delete_qry = "DELETE FROM orders WHERE orderid = '".$orderid."'"; $result = mysqli_query($mysqli, $delete_qry) or die(mysqli_error($mysqli)); if($result==TRUE){ echo "ORDER ".$orderid." DELETED.<br>"; } $delete_qry = "DELETE FROM order_items WHERE orderid = '".$orderid."'"; $result = mysqli_query($mysqli, $delete_qry) or die(mysqli_error($mysqli)); if($result==TRUE){ echo " ORDER ITEMS(s) for ".$orderid." DELETED.<br>"; } mysqli_close($mysqli); // close connection to MySQL }

Angel -- I like your logic. Let us know if you are able to acomplish step 3 and get reasonable results !

Thanx much - will do. Don't think I saw this one. Glenn

Trying to find a PHP function to perform a particular task. Where is the appropriate place to post this question ?

I'm assuming the products to be packed vary in size -- possibly in all 3 dimensions. I think the math will be fairly complex. I managed a project (all programming done by a contractor) for a robotic system to build pallets of a certain size from magazine bundles which only varied by height. This required a very complex algorithm which never worked quite right. The advantage you have is you know all product sizes before sizing your box (whereas the system I refer to had to make a real-time decision based on a limited look-ahead of product sizes.) However, if your products vary in size in all 3 dimensions, this may be much more work than you want to do. There may be code you can buy to do this but, for the site I'm working on, I decided this was a bridge too far. I am using USPS -- shipping cost more dependent on weight and distance -- so I decided not to pursue this. Good luck.

Thanks for the response. Had a typo (misspelled username) -- dumb mistake. Thanx for your help.

Alexia - you are correct on both points. I did try this code and although it seems to correctly format the floating point value in the form's textbox I was then unable to edit / save the value -- so I am not sure that the money_format() function was intended to be used inside a form's text box. (If anyone is using this in a form, I would love to see how you are doing it !) I am fairly new to PHP/HTML but in other environments, setting how values are formatted (currency,etc) at the presentation layer (in forms) has always seemed fairly straightforward. I must be missing something...

Thanks much for your quick reply. Unfortunately I am on a WAMP stack and money_format does not seem to be defined on Windows. Looked good tho....

I am making an HTML form to edit an inventory record (retrieved from MySql). Does anyone know how I can format a float in a text field as currency. (Using PHP. Prefer not to use Javascript unless that is the only way.) Thanx !

(HTML Form, using PHP) I have a form that, in the event of a user error, I want displayed again with the values just entered. I have solved this for the text boxes but, no matter what I try I have not been able retain the checked status of the checkboxes. Does anyone know how to do this ?

I am a newbie to mysql, running an XAMPP stack on Windows XP as a test environment and am trying to make my first connection to a mysql database using a connection script in "Sams Teach Yourself PHP, MySQL and Apache" by Julie Meloni. I successfully built the database, created the user and confirmed the user's existance by looking under the "privileges" tab in phpMyAdmin, where I saw this: Users having access to "testDB": User Host Type Privileges Grant Action jouser localhost database-specific ALL PRIVILEGES No root 127.0.0.1 global ALL PRIVILEGES Yes root localhost global ALL PRIVILEGES Yes Next I ran the script below: <?php $mysqli = new mysqli("localhost","jouser","somepass","testDB"); if(mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } else { printf("host information: %s\n", mysqli_get_host_info($mysqli)); } ?> And then got this error: Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'joeuser'@'localhost' (using password: YES) in C:\xampp\htdocs\mysqlconnect.php on line 2 Connect failed: Access denied for user 'joeuser'@'localhost' (using password: YES) Although the author explains that this is the error you get if the connection fails, she provides no clue as to how to troubleshoot this. Can anyone give me some help ?