Re: How do I pull out data from a mySQL DB...

[Peter Brawley]

Lots of ways, here's one. If table tbl has a date column named d, then

$res = mysql_query( "SELECT YEAR(d),MONTH(d),DAYOFMNONTH(d) FROM tbl WHERE id=123" );
$row = mysql_fetch_array( $res );
$url = sprintf( "http://xxx.xxx.xxx/balance.php?r=%s&p=%s&a=%s";, $row[0], $row[1], $row[2] );

PB