YES, Linux can run on Mac’s! Im currently installing a Linux distro on my little iMac. This is great!

OH MY GO****, &^%%$$#!@$&*(&*^, I just accidentally deleted my JobTracker Database. FU***** thats two weeks of work, and all along I knew I had included it on my daily SQL backup.

I figured when I checked my script. It was not there. :/

However, my life was saved when I remembered that I use to send a daily report every afternoon via Email. But, it will really take time to write all those stuffs again.

Im going to find a way..

I been working with a PHP function on how I can duplicate an entry on sql. My first approach was to use the while() function, but what it does was loop the entire process.

I posted at phpugph.com and ask them what they think, and they suggested the INSERT – SELECT of MySQL.

1
2
3

mysql> INSERT INTO jt_entry (uid,entry_requested_by,entry_status,entry_category,entry_title,entry_description)
select uid, entry_requested_by, entry_status, entry_category, entry_title, entry_description from jt_entry
where entry_id=’3′ limit 1;

Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0

Thanks!