Mine

if (isset($_POST['submit'])) {	$sql = "SELECT m.nrint as NrInt, m.nrmatricol as NrMatricol, v.data as Data, p.denumire as Plecare, s.denumire as Sosire, t.tarif AS Tarif, c.denumire AS Client "		."FROM masini m, viaggi v, plecare p, sosire s, tarife t, clienti c "		."WHERE m.id = v.idauto "		."AND p.id = v.idplecare "		."AND s.id = v.idsosire "		//			."AND t.idplecare  = p.id "		//			."AND t.idsosire = s.id "		."AND t.id = v.idtarif "		."AND c.id = t.idclient ";	if (isset($_POST['datefrom']) && $_POST['datefrom'] != '') $sql .= "AND v.data >= '". date2sql($_POST['datefrom']) ."' ";	if (isset($_POST['dateto']) && $_POST['dateto'] != '') $sql .= "AND v.data <= '". date2sql($_POST['dateto']) ."' ";	if (isset($_POST['auto']) && $_POST['auto'] != '') $sql .= "AND v.idauto = '". $_POST['auto'] ."' "; 	$res = mysql_query($sql, $link) or die (mysql_error());	//		echo $sql;	if (mysql_num_rows($res) >= 1 ) {		echo "<table align=center><tr><td>";		echo "<table align=center><tr><td>\n";		$total = 0;		while ($r = mysql_fetch_array($res)) {			echo "<tr>";			echo "<td align=center width=150>". $r['NrInt'] ." - ". $r['NrMatricol'] ."</td>"				."<td align=center width=150>". $r['Client'] ."</td>"				."<td align=center width=100>". sql2date($r['Data']) ."</td>"				."<td align=center width=150>". $r['Plecare'] ."</td>"				."<td align=center width=150>". $r['Sosire']	."</td>"				."<td align=center width=100>". $r['Tarif'] ." &euro;</td>"				."</tr>\n";			$total += $r['Tarif'];		}		@mysql_free_result($res);		echo "<tr><td colspan=5 align=right><b>TOTALE:</b></td><td align=center><b>$total &euro;</b></td></tr>";		echo "</table>";		echo "</td></tr></table>";	}}