date display

[angelsRock]

while($row2=mysql_fetch_array($exec2,MYSQL_BOTH))

{

echo'<tr>';

 

 

echo"<td width=100 align=center>substr($row2[datePosted],0,10) </td>";

 

}

 

why the display result for the date is    substr(2007-10-13 23:51:48,0,10) instead of 2007-10-13 ??

 

[Rithiur]

Function are not parsed inside strings, of course. You should be using something like this instead:

 

while($row2=mysql_fetch_array($exec2,MYSQL_BOTH))
{               
echo '<tr>';
echo "<td width=100 align=center>", substr($row2['datePosted'],0,10), "   </td>";               
}

[Cagecrawler]

That'll hit errors (you've used commas instead of periods). Try this:

while($row2=mysql_fetch_array($exec2,MYSQL_BOTH))
                        {               
                           echo'<tr>';
      
                  
                           echo"<td width=100 align=center>".substr('$row2[datePosted]',0,10)."</td>";
               
}

 

[redarrow]

why not do it this way?

 

while($row2=mysql_fetch_array($exec2,MYSQL_BOTH))
{

//Date             
$date=substr($row2["datePosted"],0,10); 

echo '<tr>';
echo "<td width=100 align=center>$date</td>";               
}

[Rithiur]

That'll hit errors (you've used commas instead of periods). Try this:

 

No, it doesn't. Language construct "echo" takes any number of arguments, separated by comma. Thus using something like "echo 'foo', 'bar';" will output "foobar". This is in fact better than using the concatenation operator (dot), because the PHP does not have to first combine the string before outputting them.

 

In addition, your code wont work as intended, because you put the variable inside single quotes, and variables are not parsed inside single quotes.