Search results for query: *

Hi there We're in the process of migrating our Oracle based Library Management System to a newer version which supports Unicode characters. Almost all of our reporting is done through Crystal Reports 10 connecting via ODBC. We have the system running in a test environment and although I...

Hey there I'm wanting to send small segments of HTML to other webpages (in my case IFRAMEs.) Along these lines: http://www.mysite.com/newpage.php?content=HTMLHERE I've been using base64_encode / base64_decode but guessing that this is CPU intensive. Is there any other ways I can encode/decode...

Hi there I am in the process of installing the xdebug module on my Linux server. Unfortunately I'm am very un-experienced with the "make" command (and Linux in general) and having followed the following steps without any problems:1. Unpack the tarball: tar -xzf xdebug-1.x.x.tgz. Note that you...

I'm running a very complex/ mutilated version of PHPNuke/phpBB and have been running into performance issues with my server. After going through the long process of identifying the problem it seems to be resting in the PHP code (not MySQL as originally thought.) There seems to be some code...

Hi there I've recently got all inspired and purchased "High Performance SQL" - an O'Reilly's book. Using a slow query log I'd already identified two tables that were causing problems. Both had an equal number of SELECT and UPDATE/DELETE statements being run against them. This was leading to...

Hi there I'm troubleshooting performance problems with my dynamic website that's run off MySQL. The MySQL variables are default and I'm wondering if I should look at changing any of them. My Server: 2.4Ghz Celeron (400FSB) 512meg RAM (DDR) 40gig H/D (7200rpm) Apache 2.0 Fedora MySQL 4.0.20...

Hi there How do I make a PHP script mimic a FORM sending POST information? I want to make a script that translates a search request and then sends it as $HTTP_POST_VAR to another script I have on my server. Any ideas? Cheers Tama I do my sums on fingers and thumbs.

Hi there I have recently added quite a few megabytes of movies to my website. The movies are all sitting in the same directory. How should I code .htaccess to make sure that people linking to my movies from outside of my domain will get redirected to my website (so I can restrict access if...

I know this should be straight forward but coding dates always mess with my head. All I want to do is have a loop which cycles through today and the next 30 days, generating $Day(2 digits), $Month(2 digits) and $Year(4 digits) for each cycle. Any help would be greatly appreciated. Cheers Tama...

I work in a educational institution (18,000 users) and external network traffic noticeably slows as more people arrive in the morning - and then speeds up again as people leave. This sort of thing is fairly obvious but this year the network congestion during the day has grown to unmanageable...

I've recently moved servers and now a piece of PHP script is no longer working properly. I pulls a bunch of e-mail addresses from a MySQL database and then sends them all a "group" e-mail. Except it only sends the e-mails to some (almost all) of the e-mail address and then comes up with this...

Hi there I want to change an e-mail address like "someone@somewhere.com" into a string of random(ish) looking characters like "a54fdgfd689s6df9sdf" and then be able to change the string of characters back into an e-mail address. The idea is that I'm sending out an e-mail to all the users of a...

I've recently moved this website - http://www.wideopen.co.nz to a new server. To be honest I hadn't looked at it for a couple of weeks and after I moved it I came across this completely bizarre behaviour: When I view the site (Internet Explorer 6.0) the background of the table cells which make...

I've just started using Crystal Enterprise 8.5 for connecting to an 300+ table Oracle DB via ODBC. For the past couple of years I've been using coded SQL queries to extract data from DBs for analyse/ reports. My initial investigation into using SQL in Crystal have hit a wall. I can code and...

I'm running a dynamic MySQL/PHP website. To prevent some ISPs from ignoring the Meta/Pragma fields in the HEAD section of the webpages I have added the following lines just before the document is generated. header("Cache-Control: no-store, no-cache, must-revalidate"); // HTTP/1.1...

Hi, me again I feel a bit guilty posting so many questions up here but you guys have saved me from so many hair-pulling episodes it always seems like the best place to start. I've been gradually trouble-shooting slow queries on the MySQL/PHP website I run - http://www.vorb.org.nz - Basically a...

Hi there I've been taking the advice that vanekl gave me in [url=thread436-765385 thread[/url] and been identifying indexing issues by first indentifying slow queries on my website, and then running them through EXPLAIN. This has been working very well (big props to vanekl) but I've run into...

Hi - I'm running a website on MySQL (PHPNuke/ phpBB/ Coppermine etc. etc.) - one of the queries generated by a modification of phpBB is taking a really long time to execute. I've recorded it taking up to 12 seconds to run - which is slowing down the website no end. Here is an example of the...

Hi there I run a MySQL/PHP website (using the PHPNuke platform) and have been running into performance issues after a recent upgrade (of software and server.) My Sun Cobalt RAQ runs slow when I get more than around 50 users. I've been checking the SQL processes and it seems that sometimes some...

I've got a website which has a table contain 5meg of articles in 500 entries. I want to search and replace two specific text strings inside these entries. Is there anyway to do this that doesn't involve downloading a dump file and changing via Textpad etc. ? Cheers Tama