fbachofner:
Don't want to mess with your head...
Code: Select all
ExhibitsQuery = "SELECT website_ID_PK, exhibit_ID_FK, exhibit_ID_PK, Exhibit_Title, Artist_Name, artist_ID_FK, DATE_FORMAT(Exhibit_Date_Start, '%d %M, %Y') as Exhibit_Date_Start, DATE_FORMAT(Exhibit_Date_End, '%d %M, %Y') as Exhibit_Date_End, DATE_FORMAT(Reception_Date, '%W, %d %M, %Y') as Reception_Date, Reception_Time
FROM website_config, exhibit
WHERE website_ID_PK BETWEEN 3 AND 6 AND exhibit_ID_PK = exhibit_ID_FK
ORDER BY website_ID_PK ASC";
$ExhibitsQuery_result = mysql_query($ExhibitsQuery.' LIMIT 0,2')
<<< do what ever you want with firts 2 rows >>>
$ExhibitsQuery_result_2 = mysql_query($ExhibitsQuery.' LIMIT 2,2')
<<< do what ever you want with rows 3 and 4 >>>