[Left vs Inner vs Right Join]

They serve different purposes, see the manual entry for left v right joins.

 

-Dan

[PHP Base36 Encoding/Decoding for Text/Data]

Much like you were told earlier today on DevShed, there isn't much reason to use your own encoding scheme, and it will just complicate what you're trying to do if you use a base that's not a power of 2.

 

-Dan

[Simple slideshow for php/mysql ?]

The javascript function you want is called setTimeout().

[Simple slideshow for php/mysql ?]

Doing it the easy way, yes.  You can obviously load the images in the background in javascript, but that's significantly harder. 

 

You could also simply print all the images to the screen and make all but the first one "display: none;"  Every 2 seconds, adjust the display of the items to display the next one. 

 

There's a hundred ways to do this.

 

-Dan

[CC Validation Help]

Do the debug dance.  Scatter alerts() throughout this code to make sure all the variables are what you expect them to be.  It's far easier to ask the computer "what's in this variable" than it is to ask the internet to debug code linked to a form they cannot see.

 

-Dan

[Simple slideshow for php/mysql ?]

Build a list of the pictures in order.

 

Figure out what the current picture is.

 

Figure out what the next picture should be.

 

Set a javascript timeout to visit the next picture's URL after a few seconds.

 

Profit.

[DevShed mod migration]

You're free to check out the discussions I'm a part of over on the main DevShed forums clicky), but basically (as Requinix can attest) I help the noobs, which seem at this point to be "everyone."  That's the way it goes though, you have to say "quote your array indicies" 3,000 times a year.  I also start new discussions on the technology (like this, here, and here) for educational and professional reasons.  I rarely have actual questions that I cannot solve, any time I come up with a real question it gets ignored because nobody knows the answer.  One of my devshed threads ended up as a private call to the MySQL dev team (they didn't fix it).

 

I AM old school, and I DO hang on IRC on occasion (I ran a chan on undernet for a long time) but if I get back into it at work I won't get anything done.

 

My other "duties" on devshed involve banning the morons, moving the threads, and breaking up arguments.  I don't know if it's better or worse to not have those powers over here.  Thus far I wouldn't even get a chance to use them.

 

edit hi maq, thanks!

 

-Dan

[DevShed mod migration]

Thanks Salathe, the custom forum template is taking some getting used to, but so far this place seems really active.  The mods are ridiculous, I think 30% of the main PHP forum was "moved" threads the first time I loaded it.  I don't think I move more than 10 threads a week on DS.

 

-Dan

[Need help decoding]

"\x62\141\x73\145\x36\64\x5f\144\x65\143\x6f\144\x65" is a hex representation of base64_decode.  Do this:

echo base64_decode("JG4xYjEzMGI0MGZlNDYyZWExYWVmYWVhOGNmMTAwZDIyPSJceDYyIjskbmY5Y2Y4ZTgyNGRmM2I0OWU2NjhhM2U
1MGI0NjA3ZTU9Ilx4NjUiOyRjODEzNTE2ZDlkMDExMmU3MjgwODYwZjlkNzkyOTliNj0iXHg2NiI7JG9jOGM1N2Y
5YzNmNmFhYmQxYjI2NjkxYjUyOTU4OGEyPSJceDY3IjskYTQxMzcyYzgyODQ3MDgzMDM1ZjVmYTJjZjMxN
//etc etc etc
");

That gives you raw PHP.  Run it through an auto-formatter (or manually format it) and see what's in there.

 

-Dan

[including url domain.com/search.php?query=test not working!]

As much as I hate to suggest this:

$_GET['r'] = 'test';
include('yourfile.php');

Also, your host's upgrade probably disabled the php.ini param ALLOW_URL_INCLUDES

 

-Dan

[Call to a member function set() on a non-object]

$tpl is not an object.  There's nothing wrong with THAT line, but some EARLIER line failed to set $tpl properly.

 

The error message pretty much says what I just said.

 

-Dan

[DevShed mod migration]

If we were just going to talk to each other, we could have stayed where we were.

 

I fully intend to migrate somewhere else once my post count goes up.  The only worthwhile discussions on DS recently have been started by either me or you, or involve how stupid it is to drive away your userbase with invasive ads.

[DevShed mod migration]

Edit:  Turns out it's SIMSHAUN that's the DevShed guy I know on here.  I should really check my logs before claiming to know people who aren't even members.

 

First impression FTW.

[Query that gets chained records]

If you have a self-referencing table like this, you can actually join to itself:

 

SELECT * 
FROM table AS parent_table 
JOIN table AS child_table ON parent_table.id = child_table.parent_id 
WHERE parent_table.number = 1

-Dan

[help setting password for db created with PHPmyadmin]

Create a new user account using the Create User syntax and then use that user instead of "root" for your website.  "Root" should never be used as the web user, you should always use a more limited account so that if your site is ever compromised, the attacker cannot delete your entire database.

 

-Dan

[DevShed mod migration]

Hello Everyone,

 

I'm Dan, a moderator of the devshed forums.  DevShed has made some advertising and management changes recently that have caused a bit of an exodus.  Given that one of my friends there (Requinix) is also an avid user HERE, I thought I'd give PHPFreaks a try.

 

I'm a professional PHP developer with10+ years of experience in large scale business systems.  I hope I can be an asset to the community here.

 

-Dan