Outputting Rows of an Array in diffrent places on the same page

konaman

Hi - I've been racking my brain on this one - have searched the web and read - and still cannot figure it out. Help!

Here's what I'm trying to do:

I want to output all the rows of this query on different places of the same page. There will be 7 or 8 blocks of text - complete with a header, some decriptive comments and a link. I'm trying to load as much as possible into the initial queries when the page is loaded - then output variables from different queries later in the page.

Here's the problem:

I believe the answer is in looping through the result set by row - one row at a time - and outputting the fields from each row. I just can't seem to get the syntax right. The pseudo code would be:

Pseudo Code

Goto Row 1
Print Out the Entity Name for Row 1
Print Out the Entity Description for Row 1
Print Out the Entity URL for Row 1

Goto Row 2
Print Out the Entity Name for Row 2
Print Out the Entity Description for Row 2
Print Out the Entity URL for Row 2

Goto Row X (as long as there are rows in the lookup table)
...Print Out the Entity Name for Row X
...Print Out the Entity Description for Row X
...Print Out the Entity URL for Row X

Here's the query code:

<?
/ Declare DB and User Variables /
$dbhost = "my.server.com";
$dbuser = "leftblank";
$dbpass = "leftblanktoo";
$dbname = "somedatabase";
$dbtable = "sometable";

/ Query - Get All Main Section Variables for Use/

	mysql_connect($dbhost,$dbuser,$dbpass) or die("Unable to connect to database!");
	@mysql_select_db("$dbname") or die("Unable to select database $dbname!"); 
	$sqlentityquery = "SELECT * FROM $dbtable WHERE '1'";
	$result = mysql_query($sqlentityquery) or die("Couldn't execute query!");

/ Prepare Display /
while ($row = mysql_fetch_array($result))
{
$entity_pk = $row['ENTITY_PK'];
$entity_id = $row['ENTITY_ID'];
$entity_name = $row['ENTITY_NAME'];
$entity_url = $row['ENTITY_URL'];
$entity_image = $row['ENTITY_IMAGE'];
$entity_description = $row['ENTITY_DESCRIPTION'];

/ Display Variables with consistent color scheme /

				echo "<A HREF = '$entity_pk'>$entity_pk</a>&nbsp;<p>";
				echo "<A HREF = '$entity_id'>$entity_id</a>&nbsp;<p>";
				echo "<A HREF = '$entity_name'>$entity_name</a>&nbsp;<p>";
				echo "<A HREF = '$entity_url'>$entity_name</a>&nbsp;";
				echo "<A HREF = '$entity_image'>$entity_image</a>&nbsp;<p>";
				echo"<A HREF = '$entity_description'>$entity_description</a>&nbsp;<p>";
			}

Thanks

Konaman

horndog

your sql statement is not completed...

Select * FROM $dbtable WHERE '1'

Where '1' what?

Ask yourself this, what is the one for?

tomhath

Ask yourself this, what is the one for?

The query is okay. Having "where '1' " doesn't do anything, but it doesn't hurt either; it evaluates to true so all rows will be selected.

Back to the original question, what's not working the way you want. It looks like it should emit six lines of HTML for each row.

konaman

Thanks for the reply.

The query does in fact - pull the data from the DB.

The problem is in controlling the output of the variables into the areas of the page I want to go into.

For example - a table with 3 cells across and 3 cells down.

Output $ref_entity, $ref_description and $ref_url *** (For row 1) in the first cell to the top, then do the same for each unique entity in each table cell.

I'm assuming one can open up the PHP tag at the beginning of the table then kick out a block/chunk of code per cell - and close the PHP tag at the end of the table.

So the problem is in contolling the output to show onyl one block per cell and increment the output to the next row in the query results.

Thanks,

Konaman

horndog

Here is an example of formatting That i did for a report, granted it isn't exactly perfect, nor does it work completely, but maybe on its complex query is the problem... dunno

But you can use it for a reference. Let me know if you find errors with it since I am still trying to scope it out why its not displaying all the information for the time frame I selected


$sql = "SELECT ed.ExamID, ed.DoctorID, dc.DoctorID, dc.DoctorFirstName, dc.DoctorLastName, x.ExamDate, x.ExamID, pa.PatientFirstName, pa.PatientLastName, xf.ExamFee, 

pr.ProcedureID, pr.ProcedureName FROM exams AS x, examfees AS xf, procedure_tbl AS pr, patients AS pa, 

 examdoctors  AS ed, doctors AS dc  WHERE x.ExamID = xf.ExamID AND x.ExamID = ed.ExamID AND 

xf.ProcedureID = pr.ProcedureID AND x.PatientID = pa.PatientID AND xf.ExamFee!=0 AND ed.DoctorID = dc.DoctorID  AND

x.ExamDate >= Date_Sub(CURDATE(), INTERVAL 10 YEAR) ORDER BY ExamDate DESC, ProcedureID DESC";

$result = mysql_query($sql, $connect) or die("Could not Execute Query #1");

$num_rows = mysql_num_rows($result);
 echo "<b><u>Exams Performed Today:</u></b> $num_rows";

$ExamTotals = '';

$ExamID = '';

While ($row = mysql_fetch_array($result)) {

$DoctorID = $row['DoctorID'];

$DoctorFirstName = $row['DoctorFirstName'];

$DoctorLastName = $row['DoctorLastName'];

$PrevExamID = $ExamID;

$ExamDate = $row['ExamDate'];

$ExamID = $row['ExamID'];

$ProcedureID = $row['ProcedureID'];

$ProcedureName = $row['ProcedureName'];

$ProcedureFee = $row['ExamFee'];

$PatientFirstName = $row['PatientFirstName'];

$PatientLastName = $row['PatientLastName'];


if ($PrevExamID == $ExamID) {

        if ($ProcedureID == 0) {

        $ExamTotals += $ProcedureFee;

        echo "<br><br><b>$ProcedureName:</b> \$$ProcedureFee";


        }

        else {

        echo "<br><b>$ProcedureName:</b> \$$ProcedureFee";

        }

}

else {



echo '<br><hr><b>Patient Name:</b> ' ."$PatientFirstName $PatientLastName";

echo '<br><b>ExamDate:</b> ' . $ExamDate;

echo '<br><b>Doctor:</b> ' . $DoctorLastName;

echo '<br><b>ExamID:</b> ' . "$ExamID<br>";

echo "<br><b><u>Procedures:</U></b><br>";

echo "<br><b>$ProcedureName:</b> \$$ProcedureFee";

}

}

echo "<BR><hr><b>Exam Totals:</b> <b><font color=\"#FF0000\" face=\"Arial, Helvetica, sans-serif \">\$$ExamTotals.00</font></b>";



?>