towards a perfect fedora 8 desktop

yum -y install unrar gnome-applet-netspeed azureus ntfs-config filezilla

wget http://www.mjmwired.net/resources/files/msttcorefonts-2.0-1.noarch.rpm

MySQL 5 Left Joins not working – CodingForums.com

Mysql Upgrade – left joins not working?

If you are getting an error like:

Unknown column ‘i.blah’ in ‘on clause’

using a left join like:

FROM items_table AS items, meta_data_table AS md, categories_table AS cat LEFT JOIN restricted_table AS rst ON items.item_id=rst.item_id WHERE items.title LIKE ‘the%’

switch the order of the from around so that the item MySQL is complaining about is at the end of the from clause. That should fix it in many cases.

How to modify return-path header in php mail function

Normally the return path is set by sendmail (or whatever the server is running, qmail, etc.)

However you can pass a fifth argument to php’s mail function to reset it to what you want. Here’s an example:

$result = mail($to, $subject, $body, “From: $from\n”, “-f$from”);

make sure you do not put a newline in after the fifth argument’s from. php will error out.