How can I SELECT * but only show...

mrhatch

Hi again,

I need to create a kind of timetable for a weekview. That's already done, but I have been asked for a special feature:
SELECT * FROM TBL --> show specific recordsets --> only show a placeholder for the rest.

Is this possible, and if yes, how could I do that?

tomhath

I'm sure the answer is yes. But reread your question, how could anyone offer a solution? It sounds like a "while" loop with an "if" inside would do it, but that's a wild guess.

"SELECT * FROM TBL --> show specific recordsets --> only show a placeholder for the rest. "

Huh? 😕

mrhatch

Oh yes, now, as you're sticking my nose into the dust 😉
What I'm doing is:
- SELECT * FROM tbl WHERE datum BETWEEN $beginofweek and $endofweek;
The result is a complete timetable running from Monday to Friday, 8am-7pm.
Now I have a dropdownbox where I can select eg. meetings, private dates etc.
What I want is: On selection via dropdownbox the timetable has to be created anew, but only the selected "section" (private meetings) should be shown. The rest of the timetable, if there are any meetings, should be filled with placeholders like a stop-sign or whatever so that I can't put any private dates where I should pariticipate in a meeting.

I hope this might clarify things a bit.

Weedpacket

tomhath's solution sounds like it would work. If there's a particular $section and section is a database field, you can do an if(isset()) to see if $section has a value, and if it does, tack a "WHERE section='$section'" on the end of the query.

Next, build the table with "stopsigns" in all of the time slots. Obviously, this is done in an array - you're not outputting this yet!

Loop through the resultset, and for each timeslot in that resultset, replace the stopsign with whatever it's supposed to be replaced by.

Now output this modified table.

As a modification, you can leave the entire timetable array empty, fill in timeslots that are listed in the recordset, and then output the table, displaying a stopsign whenever an empty slot in the timetable array is found.

mrhatch

Oh, I hope, I made myself understood...
I can't use a where-section in this query, because I just need the placeholders, where there really are other assignments in my schedule, and real spare-times have to be shown as free so that I can directly "move" a meeting or schedule a new date or whatever.

Yesterday I tried the following:

$query="SELECT * FROM tblkurs, tblfach, tbldozfach, tbldoz "
		. "WHERE tblkurs.kdatum BETWEEN $lastmonday AND $nextsaturday AND tblkurs.kbeendet=0 AND tblkurs.kdozid=tbldoz.dozid AND tblkurs.kfachid=tblfach.fachid "
		. "AND tblkurs.kbeginnzeit=$t AND tblkurs.datumtagzahl=$day GROUP BY tblkurs.kserienid ORDER BY tblkurs.kraum";
		$result=mysql_query($query);

		while($row=mysql_fetch_array($result))
	{    if ($subject == $row["fachid"])
		{ echo "<a href=kurs.php?action=kursdetail&kursid=".$row["kursid"]."&datum=".$row["kdatum"]."&doznr=".$row["dozid"]." title=\"".$row["kserienid"].": ".$row["ktitel"]."\">".stripslashes($row["ktitel"])."<br>".date("H:i",mktime(0,0,$row["kbeginnzeit"]))." - Raum ".$row["kraum"]."<br>bei: ".stripslashes($row["dozvorname"])." ".stripslashes($row["doznachname"])."</a><hr size=\"1\" noshade=\"noshade\">"; }
	      elseif ($subject == "")
	  { echo "<a href=kurs.php?action=kursdetail&kursid=".$row["kursid"]."&datum=".$row["kdatum"]."&doznr=".$row["dozid"]." title=\"".$row["kserienid"].": ".$row["ktitel"]."\">".stripslashes($row["ktitel"])."<br>".date("H:i",mktime(0,0,$row["kbeginnzeit"]))." - Raum ".$row["kraum"]."<br>bei: ".stripslashes($row["dozvorname"])." ".stripslashes($row["doznachname"])."</a><hr size=\"1\" noshade=\"noshade\">"; }
		elseif ($subject != $row["fachid"])
	  	{ echo "gesperrt"; }

What happens is that either everything but the real spare-times are shown as "gesperrt" (which means "restricted" in English), or everything is shown as the query delivers it.
I know somewhere out there, there is a simple solution, as PHP has so much in store for me, but I simply am too new to this.