Search found 9 matches

by alimadzi
Mon Jun 18, 2007 6:20 pm
Forum: PHP - Code
Topic: Selecting from two tables
Replies: 13
Views: 881

You can open the MySQL and read something about LEFT JOIN or INNER JOIN. And... ... // This is the query that is not displaying any values any idea how i should fix this if($BusinessName=$_SESSION['BusinessName']) { $sql= "SELECT * FROM messages WHERE $BusinessName='".$_SESSION['BusinessN...
by alimadzi
Fri Jun 15, 2007 9:45 am
Forum: General Discussion
Topic: I've decided... I'm going to learn Ruby
Replies: 17
Views: 3774

What turns me off about Rails is that it's an all or nothing framework. It's the Rails way or the highway so to speak. Before you jump off the PHP ship, you should take a look at the Zend Framework: http://framework.zend.com It's a very robust MVC framework (similar to Rails) but it allows you to us...
by alimadzi
Fri Jun 15, 2007 9:40 am
Forum: PHP - Code
Topic: INSERTING VALUES
Replies: 7
Views: 526

JayBird wrote:Both are, infact, correct
Very interesting. I sit corrected.
by alimadzi
Fri Jun 15, 2007 8:55 am
Forum: PHP - Code
Topic: INSERTING VALUES
Replies: 7
Views: 526

INSERT INTO `myTable` SET `myDate` = NOW(); This is a MySQL syntax. I don't think that would work. You seem to be mixing INSERT and UPDATE syntax. Here's INSERT: INSERT INTO MyTable (column1, column2) VALUES ('foo', 'bar') And here's UPDATE: UPDATE MyTable SET column1 = 'foo', column2 = 'bar' WHERE...
by alimadzi
Thu Jun 14, 2007 12:47 pm
Forum: General Discussion
Topic: Recommend some WordPress Plugins!
Replies: 22
Views: 2079

The Ninja Space Goat wrote:check this thing out... it's awesome.

http://dean.edwards.name/packer/
Nice. It's now saved in my del.icio.us bookmarks...

http://del.icio.us/alimadzi/javascript
by alimadzi
Thu Jun 14, 2007 12:40 pm
Forum: General Discussion
Topic: Recommend some WordPress Plugins!
Replies: 22
Views: 2079

yea tinyMCE can be hefty. Is it compressed? Compressed? I'm not sure. What it is right now is gone . ;) I need to be more careful in my plugin selection. Firebug says I'm also using Prototype and I'm not even sure where. Would be nice to dump that or at least convert the relevant JS to jQuery...
by alimadzi
Thu Jun 14, 2007 12:25 pm
Forum: General Discussion
Topic: Recommend some WordPress Plugins!
Replies: 22
Views: 2079

That is a tight plugin. I may go fetch that myself. And I like your theme Patrick. It loads in just under three hours, but when it does, it looks very nice. :wink: Yikes! Is it really that slow? The theme itself is very lightweight, but I'm using three separate third-party stats packages: Google An...
by alimadzi
Thu Jun 14, 2007 9:32 am
Forum: PHP - Code
Topic: Database Dictionary
Replies: 6
Views: 854

Here's a simple example of the use of IN in SQL:

Code: Select all

SELECT * FROM dictionary WHERE word IN ('hello', 'world')
Documentation from MySQL:

http://dev.mysql.com/doc/refman/5.0/en/ ... unction_in

Hope this helps!
by alimadzi
Thu Jun 14, 2007 9:23 am
Forum: General Discussion
Topic: Recommend some WordPress Plugins!
Replies: 22
Views: 2079

I recommend ShareThis:

http://wordpress.org/extend/plugins/share-this/

It adds a simple icon to click that opens up a menu with all the major social networking/bookmarking options, so it's relatively unobtrusive. See it in action on my blog:

http://www.alimadzi.com