[PHP]Pętla dwa zapytania Opcje

[nikestylex7]

Witam dotychczasowo pobieram dane oddzielnie tzn pojazdy oddzielnie są wyświetlane oraz ładunki oddzielnie. Chciałbym to zmienić i jakoś urozmaicić robiąc przeróbkę aby na jednej stronie pokazywało mi i ładunki i pojazdy czasem do końca w dół.

chodzi mi o taki efekt
(IMG:http://images63.fotosik.pl/583/f8d3759745ea0d85.jpg)

Myślę że wystarczy przerobić zapytania mysql lub użyć jakoś pętli.
Moje oddzielne zapytania

Pojazdy:

[PHP] pobierz, plaintext 
$sql = "select * from vehicleAdd join user on user.id_log=vehicleAdd.userID join vehicleAddInfo on vehicleAddInfo.uniqID=vehicleAdd.id join payment on payment.userID=user.id_log where vehicleActive = 1 AND vehicleDatetime >= NOW() AND leftTime >= NOW() AND ".$where.$whereSecond.$whereThird." ORDER by vehicleDatetime ASC LIMIT 0,50";
[PHP] pobierz, plaintext 

Ładunki:

[PHP] pobierz, plaintext 
$sql = "select * from cargoAdd join user on user.id_log=cargoAdd.userID join cargoAddInfo on cargoAddInfo.uniqID=cargoAdd.id join payment on payment.userID=user.id_log where cargoActive = 1 AND cargoDatetime >= NOW() AND leftTime >= NOW() AND ".$where.$whereSecond.$whereThird." ORDER by cargoDatetime ASC LIMIT 0,50";
[PHP] pobierz, plaintext 

Gdzie jest ten haczyk?

[nikestylex7]

kolejne dwa problemy pierwszy to taki że nawet jeśli w pętli mam if to i tak wszystko wyrzuca w divach kolorowanych pod ładunki , pojazdy powinny być w zielonych a są takie same jak ładunki.

zapytanie

[PHP] pobierz, plaintext 
$sql = "(select cargoActive,cargoAddingTime,cargoCountry,cargoCode,cargoPlace,cargoDatetime,carg
oCountrySecond,cargoCodeSecond,cargoPlaceSecond,cargoDatetimeSecond,
 
id_log,uniqID,cname,cowner,cstreet,cplace,name,surname,direct,phone,direct2,fax,
email,
 
cargoTypeBuild,cargoCargo,cargoLoadCargo,cargoPalette,cargoBid,cargoCurrency,car
goCheckCargo,cargoWidth,cargoHeight,cargoLenght,cargoVolume,cargoLoadType,cargoCa
rgoType,cargoWhat1,cargoWhat2,cargoWhat3,cargoWhat4,cargoWhat5,cargoWhat6,cargoWh
at7,cargoWhat8,cargoText
 
from cargoAdd join user on user.id_log=cargoAdd.userID join cargoAddInfo on cargoAddInfo.uniqID=cargoAdd.id join payment on payment.userID=user.id_log where cargoActive = 1 AND cargoDatetime >= NOW() AND leftTime >= NOW() LIMIT 0,50)
		UNION
		(select vehicleActive,vehicleAddingTime,vehicleCountry,vehicleCode,vehiclePlace,vehicleD
atetime,vehicleCountrySecond,vehicleCodeSecond,vehiclePlaceSecond,vehicleDatetime
Second,
 
id_log,uniqID,cname,cowner,cstreet,cplace,name,surname,direct,phone,direct2,fax,
email,
 
vehicleTypeBuild,vehicleCargo,vehicleLoadCargo,0,vehicleBid,vehicleCurrency,0,ve
hicleWidth,vehicleHeight,vehicleLenght,vehicleVolume,vehicleLoadType,0,vehicleWha
t1,vehicleWhat2,vehicleWhat3,vehicleWhat4,vehicleWhat5,vehicleWhat6,vehicleWhat7,
vehicleWhat8,vehicleText
 
from vehicleAdd join user on user.id_log=vehicleAdd.userID join vehicleAddInfo on vehicleAddInfo.uniqID=vehicleAdd.id join payment on payment.userID=user.id_log where vehicleActive = 1 AND vehicleDatetime >= NOW() AND leftTime >= NOW() ORDER by cargoDatetime, vehicleDatetime ASC)
		";
//potem robie //
$result=mysql_query($sql)or die (mysql_error());
while($row=mysql_fetch_assoc($result))
  {
	if (isset($row['cargoActive'])) {
//jeśli są ładunki//
}else{
//jeśli pojazdy//
}
[PHP] pobierz, plaintext 

Drugi błąd to zliczanie danych w bazie bląd Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /newsearch.php on line 1181

[PHP] pobierz, plaintext 
$sql = "(select COUNT(*) from cargoAdd join user on user.id_log=cargoAdd.userID join cargoAddInfo on cargoAddInfo.uniqID=cargoAdd.id join payment on payment.userID=user.id_log where cargoActive = 1 AND cargoDatetime >= NOW() AND leftTime >= NOW())
UNION
(select COUNT(*) from vehicleAdd join user on user.id_log=vehicleAdd.userID join vehicleAddInfo on vehicleAddInfo.uniqID=vehicleAdd.id join payment on payment.userID=user.id_log where vehicleActive = 1 AND vehicleDatetime >= NOW() AND leftTime >= NOW())
"; 
$count = mysql_fetch_row(mysql_query($sql)or die (mysql_error()));
[PHP] pobierz, plaintext 

?

Ten post edytował nikestylex7 25.01.2014, 17:56:02