<?php
$command = "SELECT ptype, descriptionpl, descriptionen, active, datetime, userid, id_zm
FROM fund_assets_class";
echo 'insert into fund_portf values('; if ($row[1]=='' || $row[1]== 'null'){echo 'null';}else {echo '''; echo $row[1]; echo ''';} if ($row[2]=='' || $row[2]== 'null'){echo 'null';}else {echo '''; echo $row[2]; echo ''';} if ($row[3]=='' || $row[3]== 'null'){echo 'null';}else {echo '''; echo $row[3]; echo ''';} if ($row[4]=='' || $row[4]=='null' || $row[4]=='0000-00-00'){echo 'null';} else {echo 'to_date(''; echo $row[4]; echo '''; echo ','; echo '''; echo 'yyyy
-mm
-dd hh24
:mi
:ss
'; echo '')';} if ($row[5]=='' || $row[5]=='null') {echo 'null';}else{echo $row[5
];} if ($row[6]=='' || $row[6]=='null') {echo 'null';}else{echo $row[6
];}
}
?>
w ten sposob, to robie , a gdzie mam umiescic ta linijke?
plik funkcje.inc, ktory dolanczam do tego skryptu
<?php
///////////////////////////////////////////
$prefiks = "Location: <a href="http://localhost/";" target="_blank">http://localhost/";</a>
////////////////////////////////////////////
function mysql_die($error = "")
{
global $strError,$strMySQLSaid, $strBack; echo "<b> $strError </b><p>"; else
echo $strMySQLSaid.$error; echo "<br><a href="java script
:history
.go
(-1)">$strBack</a>"; }
function execute($command)
{
Global $dbserver, $dbuser, $dbpass, $dbname;
// or mysql_die();
}
function sql_get_one($comm)
{
Global $dbserver, $dbuser, $dbpass, $dbname;
return $row[0];
return 0;
}
function sql_get_row($comm)
{
Global $dbserver, $dbuser, $dbpass, $dbname;
return $row;
return 0;
}
?>