Webmaster2020.com

I have good results with

mysql_query("INSERT INTO table (product,date_1) values ('item','$today')");
$lastid=mysql_insert_id();

Basically it gets the id generated from the previous insert.

If it doesn't work,
You can try to get it from table status:
$result=mysql_query("SHOW TABLE STATUS LIKE ...

On this site you get a good overview of several patterns,
with there pro's and con's:
http://mathiasbynens.be/demo/url-regex

I find the following pattern works well for me

"@((https?://|ftp://)([-\w\.]+)+(:\d+)?(/([\w/_\.\-\+\~\=\:]*(\?\S+)?)?)?)@"

$pattern=array("@((https?://|ftp://)([-\w\.]+)+(:\d+)?(/([\w/_\.\-\+\~\=\:]*(\?\S+)?)?)?)@");
$replace=array("[Somtehing]\\1");
$str=preg_replace($pattern,$replace,$string ...

strtotime() does its job well, but it need to be in the correct order.
day month year

Use a function to switch the dates:
function switch_date($str)
{
//split string
$arr=explode(' ',$str);
//put in correct order
$new_str=$arr[2].$arr[1].$arr[0].$arr[3];
return date('Y-m-d', strtotime($new ...

There is probably a character in $c_line[1] that breaks your regular expression ($pattern).

You can use preg_quote() to escape special characters.

Your code should look something like this:
$pattern="/\b".preg_quote($c_line[1])."\b/i";
if(preg_match($pattern,$text)) $countries[]=$c_line[0];

Sound like a problem in your regex.

If you post some of you code, we could check it out.

I usually create my own function and use it with usort:

function num_sort($a,$b)
{
return strcmp($a[2],$b[2]);
}

And call it with
usort($multi_array,"num_sort");

The array is in this case the second field named '2' (But you can give it any name you want).
$multi_array['key1'][1]="value 1 ...

You can create your own function: You can call the function with

If you still have problems.
you can also use, in php: It tells php to do everything in UTF-8 character-set.

You can test if your server and browser are "speaking" in UTF-8 with printing the following string.
$test='Iñtërnâtiônàlizætiøn';
echo $test."\n";

If you don't see the string correctly,
try adding the HTML line:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

In PHP you can ...