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...
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...
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...
Hello,
I'm trying to check if a user is logged in. I'm using this
if (isset($_COOKIE['name'])) {
echo 'something';
}
It works fine in the one file. However when I put this another file and include it in the first file, it doesn't work! I can't figure out why. Seems like it should be a simple...
Hi,
I'm wondering if I can sort by multiple categories in different directions. I tried this and it doesn't work:
SELECT * FROM table ORDER BY field1 DESC ORDER BY field2 ASC LIMIT 0,10
And it doesn't work, any advice?
Hi,
I am trying to select a set of similar data in 5 tables and delete rows in another table that do not contain matches to this data. I basically want to clump all 'col1' together (with a join?) in table1,table2,table3,table4,table5, and compare these values to 'col1' in table6. It would be...
Hi There,
I am trying to a database search for something using
LIKE '%$something%'
It works fine for one word like if I search "elephant" it returns the rows with "elephant"
BUT, if I search "blue elephant" it only returns rows with the string "blue elephant" and not just "elephant". What I...
Ok I'm using DW 8, and I have many layers positioned using absolute coordinates. The problem is I would like to have the whole site display centered no matter what browser size or type you have.
Is there a way to convert abs. positioned layers so that they are still in the same positions...
Hi There,
I've been working hard at this for a while, and I've figured a few things out, but I'm having trouble sorting the below query by "mls_condos.date_posted":
"SELECT SQL_CALC_FOUND_ROWS owyw.*,mls_condos.name,MAX(mls_condos.date_posted),COUNT(mls_condos.date_posted)
FROM owyw
LEFT...
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.