Recent content by pushyr

you have totally helped me out on this one... can't thank you enough!!!!

Hi jpadie, I used your exact pattern, but didn't work as i'm still getting the same results.. preg_match_all('/\-{58}(.*?)\-{58}|$/s', $content, $content0);

I'm trying to do a preg_match_all, but it's not matching everything. about 30% gets missed, here's a sample of the full text that i'm using preg_match_all on... I'm trying to match everything that's in-between these lines here's my code...

cheers jpadie... i knew it were something simple like that!

is there a simple way to convert a friendly date and time to a mysql format my date and time looks like this... Tue, 31 Jul 2012 13:17:23 GMT and i'd like to both split and convert into this... 1. 2012-07-31 2. 13:17:23

cheers feherke!

thanks for your help feherke... i solved it with this... $url0 = explode("\r\n", $content00); $url = $url0[1]; since the text will always be 20 to 30 lines, i think this is ok?

ahh.. ok, i think i know were i went wrong with my initial question. i'm really trying to get the second line... so the first line is: ---------------------------------------------------------- and the second line i'm after is: http://www.bbc.co.uk/news/

this is perhaps one of the simplest things to do, but after googling i just can't find anything that works. Here's my own concoction, which doesn't work. ...so, how would i regex the first line from a block of text preg_match("#^(.*?)\r\n#is", $content00);

actually guys... just realized I can seemlessly import using a sql client cheers for everything!

Hi jpadie, I made the changes like you said to my php.ini but got the following error when trying to upload a 144mb table via phpmyadmin where you browse to select the file, I also noticed that it says (Max: 512 kKiB) do I need to make further changes elsewhere like in phpmyadmin to...

if using phpmyadmin there's a file size restriction (Max: 2,048 KiB)... how do i get rid of or override the restriction

i have a single mysqldump file with quite a few large tables. the file totals about 4.5gb i would like to load the file (all these tables and their contents) into a mysql database using php after searching i couldn't really find anything that put me on the right path. how would go about...

that did the job... perfect!

hey jpadie.. i cant update the query... as i need the last two rows in the result (in addition to all the rows in the result) both 6 and 5... my intention is to do an equation with these two numbers i can currently get the 6, but now i need to get the 5