alexweber15

thats downright sneaky!

lol i would have gotten that question wrong, needle before haystack seems more intuitive to me

thanks for the reply! I know my stuff but there's certain things like XML and Streams that I'm gonna have to read up on...haven't used XML since I discovered JSON Here in Brazil not many people have it so I figured it'd be a good thing for me to have

I've decided to take the next step and get my ZCE Certification next month. I'm in a position where I have some extra free time so I can afford to study a bit and think it'll be good for me professionally. I got a Study Guide but it just lists every topic you're expected to know but doesn't actually tell you anything about the exam (is it by hand, by computer? multiple choice? code? etc?) Wondering if anyone here is certified and if there's any tips they can give. Thanks! -Alex

im not sure i get what you mean and also there's no UPDATE queries anywhere in there, so the DB never changes... also, just a quick tip change the WHERE id LIKE xxx to WHERE id = xxx

just tried this out, its missing the "http://" if you dont specify the protocol, it assumed its a local path so it will look for a folder called www.yahoo.com

gonna hop on this thread if you don't mind cause i have a very similar question I was wondering if Lighttpd had a similar mod_rewrite, i guess it does

Heard awesome things about it, anyone have any hands-on experience? yii

at the moment all i code is PHP and related web stuff like Javascript, CSS, XML, etc but at uni we have Java and also C# classes and in my free time im trying to learn Flex so I guess Eclipse is pretty solid in that respect as the only language it doesn't support is .NET and frankly i hate it and only use it for uni assignments... I'm just wrapping up a project I have to deliver this week, then I'll have some time to mess around with other IDEs and see which one jells for me

thats a lot to go through, would really help me if you posted a screenshot of the search form so i could understand how all the different options fit in together and just by taking a glance at it this comes up kinda often: WHERE pitchid=pitchid you should change that to: pitchid='$pitchid' might do the trick

man i just took a look at the website and it looks awesome! one thing that always pissed me off about dreamweaver was its piss-poor PHP code completion and this has even got a jQuery plugin... sweet! downloading now, gonna try it on a new project asap! thx!

thanks for the replies, someone on another forum showed me a link that solved my problem someone should sticky this... using mod_rewrite for fake subdomains

dude, actually "regular exasperation" is usually correct and thanks for the suggestions, gonna take a look at the open-source one, i have netbeans installed too for java and i think its the full version so ill give that a shot too

hey all, getting kinda frustrated lately with the amount of extra work im doing debugging a script... i started php using dreamweaver a couple years ago im not sure why and i like it for doing the whole front-end thing, but really its very limited as a PHP development tool. i constantly find myself polluting my scripts with echos and var_dumps and whatnot and its a real pain in the ass debugging. i loved the good ol VB6 days when i could set breakpoints and step through functions and stuff and this is pretty standard stuff. SO, can anyone please suggest me a better IDE? thx!

searched both the forums and google and haven't found anything that works... here's the deal (and i can see this is pretty popular too): URL: one.mydomain.test REDIRECT: mydomain.test/redir.php?sub=one and so on... whatever the subdomain used i want it to be passed as a GET variable to the file redir.php i'm running xampp on windows and i've already set up a virtual host and enabled ServerAlias *.mydomain.test and www.mydomain.test works fine here's my htaccess: RewriteEngine On RewriteCond %{HTTP_HOST} !^www\.mydomain\.test RewriteCond %{HTTP_HOST} ([^.]+)\.mydomain\.test RewriteRule ^(.*)$ /redir.php?sub=%1 [R,L] whenever i try to access any subdomain (or even just mydomain.test - without the www) i get a page not found error... can anyone please help?

oh and if you meant the first option like just get rid of the start and end parts you can probably use string functions to locate the 'http://', 'www' and all occurences of '.' so you probably will just need to identify the limits and extract a substring (not as elegant as using preg_replace)

you want to just store the parts in the middle of the url? www.phpfreaks.com would become phpfreaks ? its perfectly safe to replace special html entities, espace strings and just store the entire thing...either way if you search the forums there's tons of example and PHP also has a set of built in "filter" functions...

I've got one but it only works locally (Brazil) either way, you obviously haven't been looking in the right places

I was pretty sure you could just: unset($_COOKIE['varname']) is there something I'm missing? ps - also, instead of an empty string if I'm not mistaken you can just assign the value NULL to effectively delete the cookie (not sure about this one) Alex

try this: - run the query without the GROUP BY clause and see if it returns the correct info - if yes, try GROUP BY score (using the alias you gave it) - not sure if this has any impact at all but I'd try anyway to see what happens - if not, make sure pictures.gender is storing an integer value because that's what you're comparing it with in your WHERE clause....again, I'm not sure how forgiving MySQL is with treating a string of numbers ("123") with a number (123) but if its not selecting anything try that without a similar db schema to run queries against its kind of hard to test... gl!

again without the code we're limited to guessing, but probably something do with the way your script and MySQL represent dates (MySQL is yyyy-mm-dd) and most people do (dd-mm-yyyy) so maybe its just not recognizing the date you give it as valid and filling in a default value (which happens to be the current date?

Actually the SELECT clause might change too (from the example: stats.time wasn't even selected in the initial query and then as in the new query), in fact, the only thing that remains constant is the table name... Maybe this would be a good scenario to play with prepared statements SELECT ? FROM stats WHERE ? LIMIT ? ???????) (gotta read up on this) but either way corbin thanks for clearing it up about multiple queries, i had a feeling that might be the case but always good to get confirmation!

that was just one example! i'm gonna have to mostly re-order and hide subsets of the resultset (which as far as i know is ok to do with arrays) but for example there's a time column, remember that so far is not used. through the gui the user will be able to select filters and format the data the way he wants. so he might for example decide to filter only the results from the last 7 days for example. in that case (assuming 800 results), as far as i know its definitely more efficient to perform another query than to filter the entire array (also because you might have to sort it first to avoid iterating through all results) know what I mean? I've been adopting some practices recently and I'm kinda curious as to how they compare to proven methods of achieving the same thing.

true, i had no idea what MoveLast was so i did some quick research and for some reason assumed it just returned the last item in the result set (my solution) and not the entire result set with the internal pointer at the end (yours)

I've never heard of that. If you're starting again fresh, you can use TRUNCATE to empty the table properly, instead of DELETE. that's the point: delete only the id column, not the entire table!! then re-create it as auto-inc (and possibly reset the counter by using ALTER TABLE) and it will assign new numbers. and about "SET insert_id" look it up its in the manual