Kas man ir nepareizi? Neatkarīgi no tā vai rezūltāts ir vai nav, man nerāda neko, bet ja
if ($result2 == 1) {...}
izņem ārā, tad man pie esoša rezūltāta viss ok, to rāda, bet ja dati nav vēl pievienoti datubāzē rāda kļūdu, kā to var izlabot?
mysql_query('set names utf8');
mysql_query('set characters utf8');
$carID = $_GET['rek'];
echo "Privāti Rēķini<br/>";
$qeryjob = "SELECT car.IDcar, car.IDclient, car.carNr, car.engine, car.year, car.chasyNr, car.l, car.notes, car.model, car.marka, job.IDjob, job.IDklients, job.IDcar, job.IDstaffPien, job.dateIn, job.dateOut, job.planDescr, job.realDescr, job.many, job.status, client.IDclient AS KlientaID, client.name, client.surname, client.address, client.phone, client.islegal, client.email, client.bank, client.notes, client.temp1, client.temp2 ".
"FROM car LEFT JOIN job ".
"ON car.IDcar = job.IDcar LEFT JOIN client ON car.IDclient = client.IDclient WHERE car.IDcar = ".$carID." and job.type = 1";
$result2 = mysql_query($qeryjob) or die(mysql_error());
if ($result2 == 1) {
while($row5 = mysql_fetch_array($result2)){
echo "
";
$sql = "SELECT * FROM job WHERE IDcar='$carID' and type='1'";
$result = mysql_query($sql) or die(mysql_error());
} while($row = mysql_fetch_array($result)){
echo "<a href='inc/view_rek.php?id=".$row['IDjob']."' target='_blank'>".$row['dateIn']."</a>| <a href='?edit_rek=".$carID."&job_id=".$row['IDjob']."'>Labot</a> | <a href='?del_rek=".$row['IDjob']."'>Dzēst</a><br/>";
}}