spliting data into two tables

phence

right now i have some code that pulls data from a database and shows it to the user.

I would like to split this data into two columns side-by-side instead of having one long column, to keep it looking nicer and to minimize page length.

Heres the code i'm working with:

// Format Names into a nice table
    $result = mysql_query($query);
    if (($result = @ mysql_query ($query, $connection))){
        while ($row = mysql_fetch_array($result)){
		 	echo " <table width=\"25%\" border=\"1\" bordercolor=\"#FFFFFF\">
    				<tr> 
      				<td width=\"30%\"><font size=\"2\" face=\"Tahoma\">
					<select name=\"$usrVars['members'];\">
					<option>-----------</option>
          			<option name=\"$row['fire']\" >Fire Scene</option>
          			<option name=\"$row['drill']\" >Drill Scene</option>
					<option name=\"$row['station']\" >Station</option>
        		   </select></td>
				   <td width=\"75%\"><font size=\"2\" face=\"Tahoma\">
				   " .$row['lastname'] . ", " . $row['firstname'] . "</td>";   

		}
		echo "</tr></table>";
	}

Could anyone assist me in getting this looking how i want?
hope this was clear..
Thank-you for your help!

jclout

Try this:

// Format Names into a nice table
//Remove the table from inside your query
<table width=\"25%\" border=\"1\" bordercolor=\"#FFFFFF\">

$j = 0;
            $rownum = 0;
	$result = mysql_query($query);
	if (($result = @ mysql_query ($query, $connection))){
    	while ($row = mysql_fetch_array($result)){
         		if($j == $rownum) {
		echo "<TR>";
		$rownum += 2;    //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW
		}
         		echo "<td width=\"30%\"><font size=\"2\" face=\"Tahoma\">
                			<select name=\"$usrVars['members'];\">
                				<option>-----------</option>
                  				<option name=\"$row['fire']\" >Fire Scene</option>
                  				<option name=\"$row['drill']\" >Drill Scene</option>
                				<option name=\"$row['station']\" >Station</option>
               			</select></td>
               		<td width=\"75%\"><font size=\"2\" face=\"Tahoma\">
               	" .$row['lastname'] . ", " . $row['firstname'] . "</td>";   
    }
    	++$j;	// <---- Yes this is right  See below

		if($j == $rownum) {
		echo "</TR>";
		}
}

</table>

// ++$a Pre-increment Increments $a by one, then returns $a.
// $a++ Post-increment Returns $a, then increments $a by one.

phence

wow, that didn't work... but it did place a aqua colored border around the data... 😕 😕

here's the exact changes i made.. still not working

	<? ...
// Format Names into a nice table 
	//Remove the table from inside your query 
	?><table width=\"25%\" border=\"1\" bordercolor=\"#FFFFFF\"><? 

$j = 0; 
$result = mysql_query($query); 
if (($result = @ mysql_query ($query, $connection))){ 
	while ($row = mysql_fetch_array($result)){ 
		if($j == $rownum) { 
			echo "<TR>"; 
			$rownum += 2; //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW 
		} 
		echo " <tr> 
			<td width=\"30%\"><font size=\"2\" face=\"Tahoma\"> 
			<select name=\"$usrVars['members'];\"> 
			<option>-----------</option> 
			<option name=\"$row['fire']\" >Fire Scene</option> 
			<option name=\"$row['drill']\" >Drill Scene</option> 
			<option name=\"$row['station']\" >Station</option> 
			</select></td> 
			<td width=\"75%\"><font size=\"2\" face=\"Tahoma\"> 
			" .$row['lastname'] . ", " . $row['firstname'] . "</td>"; 
	} 
	++$j; // <---- Yes this is right See below 

	if($j == $rownum) { 
		echo "</TR>"; 
	} 
// ++$a Pre-increment Increments $a by one, then returns $a. 
// $a++ Post-increment Returns $a, then increments $a by one.
}
else
     showerror(); 
?>
</table>

phence

well I got rid of the auqa border by taking out the slashes in the table line..
<table width=\"25%\" border=\"1\" bordercolor=\"#FFFFFF\"><?
TO:
<table width="25%" border="1" bordercolor="#FFFFFF">

still only showing up in one column..
any ideas?

diego25

echo " <tr> 
                <td width=\"30%\"><

You have an extra <tr> there that wasn't in jclout's code.

Diego

phence

... still not working, it's showing everything on one row... each result has it's own column.

i have now idea why.. you? 😕

jclout

Try my code again I made some changes that I don't think you have.

Like diego said there were 2 <tr> and you need $rownum = 0 <-- ( This is a biggie ) in the begining. Sorry should have looked at it better.

new code:

$j = 0;
$rownum = 0;
$result = mysql_query($query);
if (($result = @ mysql_query ($query, $connection))){
while ($row = mysql_fetch_array($result)){
if($j == $rownum) {
echo "<TR>";
$rownum += 2; //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW
}
echo "<td width=\"30%\"><font size=\"2\" face=\"Tahoma\">
<select name=\"$usrVars['members'];\">
<option>-----------</option>
<option name=\"$row['fire']\" >Fire Scene</option>
<option name=\"$row['drill']\" >Drill Scene</option>
<option name=\"$row['station']\" >Station</option>
</select></td>
<td width=\"75%\"><font size=\"2\" face=\"Tahoma\">
" .$row['lastname'] . ", " . $row['firstname'] . "</td>";
}
++$j; // <---- Yes this is right See below

if($j == $rownum) {
echo "</TR>";
}
}
</table>

phence

nope.. same deal, it's still a single row, with a column for each result.

thanks for helping

phence

is there another method to do this?
can anyone else help?

diego25

Can you post the code you're using and a link to a sample output page?

Diego

phence

here's the link
http://www.collinsburgvfc.com/log/report.php
and here the code..

// Format Names into a nice tables  

	echo "<table width=\"25%\" border=\"1\" bordercolor=\"#FFFFFF\">"; 
	$j = 0; 
	$rownum = 0; 	
	$result = mysql_query($query); 
	if (($result = @ mysql_query ($query, $connection))){ 
		while ($row = mysql_fetch_array($result)){ 
			if($j == $rownum) { 
				echo "<tr>"; 
				$rownum += 2; //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW 
			} 
			echo "<td width=\"30%\"><font size=\"2\" face=\"Tahoma\"> 
				 <select name=\"" .$row['lastname'] . ", " . $row['firstname'] . "\"> 
				 <option>-----------</option> 
				 <option name=\"$row['fire']\" >Fire Scene</option> 
				 <option name=\"$row['drill']\" >Drill Scene</option> 
				 <option name=\"$row['station']\" >Station</option> 
				 </select></td> 
				 <td width=\"75%\"><font size=\"2\" face=\"Tahoma\"> 
				 " .$row['lastname'] . ", " . $row['firstname'] . "</td>"; 
		} 
		++$j; // <---- Yes this is right See below 

	if($j == $rownum) { 
		echo "</tr>"; 
	} 
} 
echo "</table>";

// ---- ----- Or here is my original code ----- - -- - - -- -
// Format Names into a nice table
    $result = mysql_query($query);
    if (($result = @ mysql_query ($query, $connection))){
        while ($row = mysql_fetch_array($result)){
		 	echo " <table width=\"25%\" border=\"1\" bordercolor=\"#FFFFFF\">
    				<tr> 
      				<td width=\"30%\"><font size=\"2\" face=\"Tahoma\">
					<select name=\"$row['members'];\">
					<option>-----------</option>
          			<option name=\"$row['fire']\" >Fire Scene</option>
          			<option name=\"$row['drill']\" >Drill Scene</option>
					<option name=\"$row['station']\" >Station</option>
        		   </select></td>
				   <td width=\"75%\"><font size=\"2\" face=\"Tahoma\">
				   " .$row['lastname'] . ", " . $row['firstname'] . "</td>";   

		}
		echo "</tr></table>";
	}     

    else
         showerror();

jclout

Now I think I understand what your trying to do try this:

// Format Names into a nice tables

echo "<table width=\"25%\" border=\"1\" bordercolor=\"#FFFFFF\">";
$j = 0;
$rownum = 0;

$result = mysql_query($query);
if (($result = @ mysql_query ($query, $connection))){
while ($row = mysql_fetch_array($result)){
if($j == $rownum) {
echo "<tr>";
echo "<td width=\"30%\"><font size=\"2\" face=\"Tahoma\">";
$rownum += 2; //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW
}
echo "<select name=\"" .$row['lastname'] . ", " . $row['firstname'] . "\">
<option>-----------</option>
<option name=\"$row['fire']\" >Fire Scene</option>
<option name=\"$row['drill']\" >Drill Scene</option>
<option name=\"$row['station']\" >Station</option>
</select>
<td width=\"75%\"><font size=\"2\" face=\"Tahoma\">
" .$row['lastname'] . ", " . $row['firstname'] . "</td>";
}
++$j; // <---- Yes this is right See below

    if($j == $rownum) { 
        echo "</td>";
        echo "</tr>"; 
    } 
} 
echo "</table>";

jclout

Hey why doesn't my formating stay the same when pasting

jclout

Also I think it would work better if you remove :

<td width=\"75%\"><font size=\"2\" face=\"Tahoma\">
" .$row['lastname'] . ", " . $row['firstname'] . "</td>";

and change it to just :

echo " .$row['lastname'] . ", " . $row['firstname'] . ";

diego25

jclout,

Surround your code with [ PHP ] and [ /PHP ] tags (without the spaces) and it will keep the formatting and syntax highlight it too.

Diego

phence

hmm.. wow.. it did a lot of wierd stuff look at the page now..

use the [php ] [/php ] tags to format your php code

i don't know what the script is doing now.. 😕 😕

jclout

I think we are working on the same type of code. I see your other post about passing options to another page. But back to your code I have modified it once more try this:

echo "<table width=\"100%\" border=\"1\" bordercolor=\"#FFFFFF\">"; 
    $j = 0; 
    $rownum = 0;     

    $result = mysql_query($query); 
    if (($result = @ mysql_query ($query, $connection))){ 
        while ($row = mysql_fetch_array($result)){ 
            if($j == $rownum) { 
                echo "<tr>"; 
                $rownum += 2; //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW 
            } 
            echo "<td width=\"30%\"><font size=\"2\" face=\"Tahoma\">
            	 <select name=\"" .$row['lastname'] . ", " . $row['firstname'] . "\"> 
                 <option>-----------</option> 
                 <option name=\"$row['fire']\" >Fire Scene</option> 
                 <option name=\"$row['drill']\" >Drill Scene</option> 
                 <option name=\"$row['station']\" >Station</option> 
                 </select>
                 " .$row['lastname'] . ", " . $row['firstname'] . "</td>"; 
        } 
        ++$j; // <---- Yes this is right See below 

    if($j == $rownum) { 
        echo "</tr>"; 
    } 
} 
echo "</table>";

phence

there is a big difference between..

<td width=\"75%\"><font size=\"2\" face=\"Tahoma\"> 
" .$row['lastname'] . ", " . $row['firstname'] . "</td>"; 

// and...

echo " .$row['lastname'] . ", " . $row['firstname'] . ";

// also i changed the above to...   to avoid parce errors 
echo $row['lastname'] . ", " . $row['firstname'] ;

if you look at the sample page now.. the code is

	// Format Names into a nice tables 
	echo "<table width=\"25%\" border=\"1\" bordercolor=\"#FFFFFF\">"; 
	$j = 0; 
	$rownum = 0; 
	$result = mysql_query($query); 
	if (($result = @ mysql_query ($query, $connection))){ 
		while ($row = mysql_fetch_array($result)){ 
			if($j == $rownum) { 
				echo "<tr>"; 
				echo "<td width=\"30%\"><font size=\"2\" face=\"Tahoma\">"; 
				$rownum += 2; //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW 
			} 
			echo "<select name=\"" .$row['lastname'] . ", " . $row['firstname'] . "\"> 
			<option>-----------</option> 
			<option name=\"$row['fire']\" >Fire Scene</option> 
			<option name=\"$row['drill']\" >Drill Scene</option> 
			<option name=\"$row['station']\" >Station</option> 
			</select> ";
			echo $row['lastname'] . ", " . $row['firstname'] ;

	} 
	++$j; // <---- Yes this is right See below 

	if($j == $rownum) { 
		echo "</td>"; 
		echo "</tr>"; 
	} 
} 
echo "</table>";

All a really want is to seperate the one big column into 2 or 3 shorter columns.. to keep page lenght down and so on..

phence

lol, nope.. back to one row with multipul columns...
check the sample page for the change

thanks!

jclout

Damm I see it now

++$j; // <---- Yes this is right See below

Should be inside the while statement move it up 2 rows