Hi There,
I'm a self taught programmer whose been using LAMP for 6-7 years for build simple web applications. More recently I've gotten into developing more complex applications, but I think I've fallen behind the times. My code is linear PHP and I would like to teach myself OOP and start using...
I had this php page running fine, and all of a sudden after months of good service, I get this mysql error, maybe you can help?
Error, query failed. The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is...
I've had numerous problems with the speed of my apps on a shared hosting server. I optimized the living crap out my queries, but still performance gain was minimal. I wanna switch to a better host. Anyone have any recommendations for lightning fast mysql servers?
Hi There,
I implemented a javascript slideshow, it uses the blendTrans method, In Firefox there is no problem but in IE 7 (and 6 I think too) the orange title text disappears when the slideshow loads. Check it out:
http://resales.premiumcondohotels.com/resales-listings/96
Any ideas? I messed...
Hi There,
I'm looking into using a CMS for a new website I'm about to build. I've been designing and programming with PHP/mySQL for a good while now. I've done considerable Wordpress alterations and customizations with PHP code, but for this upcoming project I want to use something a little...
Hi,
I have a php page which is calling a javascript function that checks a hotel reservation database to see if the property is available. The reserved dates are provided as a string (php array imploded with a space between values) to the js function, and the js function create an array out of...
I thought it might not be possible, I have a list of cities in a drop-down form field, but I want to allow them to fill in their own if the city they live in is not in the list. Can you explain this custom dropdown on a regular text input box idea? Or direct me to an example?
Thanks!
Hmm I thought about passing a get variable to the system with the outer frame url, only problem is I would have to track that url value throughout the entire site, which is a bear.
What about if I set URL variable using a cookie, would that work?
Hi,
I've designed a piece of php/mySQL software on one website that I want implement across a number of other websites. I do not want to transfer this software to each site, I just want to use it in a frame on all the other websites. Each individual client wants to have their own banner at the...
Yes! That did it. I used a statement like this:
<?
$queryC = "SELECT IF(blobData IS NULL, 0, 1) as c1, IF(blobData2 IS NULL, 0, 1) as c2, IF(blobData3 IS NULL, 0, 1) as c3, IF(blobData4 IS NULL, 0, 1) as c4 FROM blobs WHERE blobId='$id' LIMIT 1";
$resultC = mysql_query($queryC) or...
If you decide to use mod_rewrite, here's a great tutorial on it: http://corz.org/serv/tricks/htaccess2.php
I use mod_rewrite a lot just for SEO purposes, it seems like I get less repeat results in google as well with php query strings hidden with mod_rewrite. But it can be a major pain...
Hi There,
I have question about pattern matching. What I'm trying to do is replace any characters in a string that are not alphanumerics or spaces and these characters:
,.?!"-[]/'
I have this line going, it only replaces alphanumerics and spaces though:
$string =...
Hi,
I'm wondering how to return the names of the columns that are not null in a mySQL query. Basically I have BLOBs in a database and don't want to return the data yet, just want to know whether there is data present in that column for a particular row, and then return the name of that column...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.