kena1921

So then the data would simply be the size of the page as, of course, the all of the data generated by any queries is written into the html (obvuious when you think about it!) So how does it work wuth data going the other way ie data entered onto the page by the user that is then saved to the database??

Hi I have some issues re a number of PHP/mySQL pages I have written and the amount of traffic that they are generating. The pages are on an internal (citrix) network and are assessed via a datacard. However the amount of data that is being moved is huge and I don’t understand why. I am reasonable proficient in PHP and understand the principles of server side code but I could do with some clarification on the traffic issues. Each page has to display data generated by a query. In some instances records are updated or even created. Below is a sample of the code I’m using (to populate a list box). ---------------------------------- <?php // open connection $con = @mysql_connect("localhost","root","") or die("Connection to mySQL failed"); mysql_select_db("myDB",$con) or die("Cannot Connect to db"); //build sql statement $sqlArea = "select * from tab_areas order by AREName"; //execute sql $resArea = mysql_query($sqlArea) or die(mysql_error());; //run loop to get row values and build into option statement while ($row=mysql_fetch_array($resArea)) { $area=$row["AREName"]; $areaID = $row["AREArea_ID"]; $option_area.="<OPTION VALUE=".$areaID.">".$area."</option>\n"; } mysql_close($con) ?> …html <select name="area"> <?php echo $option_area;?> </select> ---------------------------------- So in the above example, if the table size of tab_areas is 16384kb does this mean that the amount of data that will be moved from the server to the browser, after the query is run, will be 16384kb plus the size of the page? All help gratefully received

Thanks again - I am reasonably new to PHP although I do have a fair amount of programming experience, so what level of expertise would you say is required to do this via COM objects.  Is it something you can pick up fairly quickly or is it more in the expert category??

Thanks - I will have a look at this.  Would this also be the same for other document types such as excel and Powerpoint?? The restricting access levels suggestion unfortunately is not practical in the circumstances. Many thanks ken

Hi I need to be able to display a Word Document within the a browser - i.e. I don't want the document to download or Word to open but the contents of the document to be displayed within the browser itself.  Is there any way of doing this with PHP? Many thanks Ken

I have now uninstalled everything (inc IIS) and reinstalled.  When I try to run a PHP file I now get a dialogue box asking me where I wish to save the file.  This is getting very frustrating!!

I have tried using the installer a couple of times with no success - PHP files aren't recognised

Hi I need to develop a PHP web site that will be hosted on IIS. I have been trying to install PHP on an XP machine using the Windows Installer without success - I have concluded the answer may be to install manually.  The 2 things I was wondering were.. What is the best advice for manually installing PHP on IIS - I have looked at the PHP site but found the instructions not the easiest to follow. Secondly, I would prefer to run it locally on Apache as this seems to be a better option.  However am I likely to encounter problems if I devlop the site on Apache and then have it running live on IIS? Many thanks Ken