[darkcarnival]

hi,

im made a news programs and i wanted to convert the mysql to the regular format. so i found a code that would work and it gives me a parse error. heres that code:

PHP Code:

        while ($row = mysql_fetch_array ($query, MYSQL_ASSOC)) {

list($year,$month,$day)= split('[/.-]', {$row['Date']});

$newdate =date("m-j-Y", mktime(0, 0, 0, $month, $day, $year));

echo "<CENTER>";

echo "<B>{$row['Subject']}</B> -Posted By: <A HREF=\"/MetalPass/Viewprofile.php?user={$row['Username']}\">{$row['Username']}</A> on $newdate<BR><BR>";

echo "{$row['Body']}";

echo "<BR><BR><HR width=\"395\"><BR>";

} 

please help me so i can get this working.thx.

[IWeb]

On what line does the error appear?

perhaps this line should be:

PHP Code:

list($year,$month,$day)= split("\-", $row['Date']); 

[darkcarnival]

actually its on the line you just wrote but acorrding to php.net the way i did it is correct. thats why im upset about this :@

[blaw]

Hello,

PHP Code:

list($year,$month,$day)= split('[/.-]', {$row['Date']}); 

Why are there curly braces around $row['Date']? Take them out and see what happens:

PHP Code:

list($year,$month,$day)= split('[/.-]', $row['Date']); 

Also another tip is that, if you know there is always going to be one and only delimiter (e.g. "/"), you could use explode() instead, which is faster.

HTH.

[darkcarnival]

well i believe they belong on there. the rest of my code has that and it works fine. ill give it a try though also ill give the explode() a try too thx.

[blaw]

Okay, let me try...

PHP Code:

<?php



// For this test, assign a string value of yyyy/mm/dd .

$row['Date'] = '2003/03/22';



// From your code.

list($year,$month,$day)= split('[/.-]', {$row['Date']});

$newdate =date("m-j-Y", mktime(0, 0, 0, $month, $day, $year));



// For this test, echo it.

echo $newdate;



?>

The following gives me this error, which I guess is more or less the same as yours:

Code:

Parse error: parse error, unexpected '{' in e:\web\foo\test.php on line 7

This means that "{" on line 7 is not supposed to be there.

But without "{" and "}", like this:

PHP Code:

<?php



// For this test, assign a string value of yyyy/mm/dd .

$row['Date'] = '2003/03/22';



// From your code, without "{" and "}" around $row['Date']

list($year,$month,$day)= split('[/.-]', $row['Date']);

$newdate =date("m-j-Y", mktime(0, 0, 0, $month, $day, $year));



// For this test, echo it.

echo $newdate;



?>

I get this:

Code:

03-22-2003

I guess this is what you wanted. There shouldn't be any code block there. The rest of your code works with "{" and "}" around variables because you are using it to indicate "this is a variable" to PHP within double-quotations (i.e. string). You could, thus, double-quote it like so:

PHP Code:

list($year,$month,$day)= split('[/.-]', "{$row['Date']}"); 

This would give you the same output as the one before, but unless you have to concatenate something else to your $row['Date'], all it does is add 4 more unnecessary characters to your code - it makes a bit harder to read the code, too.

HTH.

[darkcarnival]

hi,

i forgot to post that i gave your suggestion a test and it works now thx blaw, if you want i got another problem with it now,if you want to help me view the post i added yesterday