Looking for an Expert

Anon

Listen guys I know this is kinda long but it is the only way I can explain what I am trying to do. So please be patient with me. I would really appreciate any help on this

How do I get the results from a query to display in a table from left to right instead of up and down. I want to be able to specify 4 columns and after the 4 columns have been filled from left to right a new row should be created with also 4 columns and load the records from left to right and so on.

Also could someone please explain to me how the focus thing in javascript works. I've been trying to get it to work all night no luck though. What I am doing is I wrote a script that has 2 listboxes one for Category and one for subcategory. These listboxes are populated by a mysql database. When I pick a category from the first listbox i am using onchange to submit my form the action attribute that my form is set to is $php_self the reason i do this is because I need the HTTP_GET_VARS to update once they are updated i run a query against the value of that field and populate my second listbox accordingly. This all works flawlessly the problem i have is that I have a bunch of other fields that need to come before my 2 listboxes which will pretty much put my 2 listboxes to the bottom of the page where you would have to scroll down to get to them. This is fine as long as you are filling out the form. As soon as you get to the listbox you select your category it submits the page to itself and you are at the top of the page. This is something that I don't really want anyone to have to worry about so I was wondering if there is a way that after i submit using onchange and php_self that I can set a focus on that field so when the page reloads it will be at the field where the user left off.

Anon

you should use something (i forgot its name) that brings the page to a selected place. You put #a in the url and it goes there. I use them in my website and they are in many places, I have only just now forgotten the name. I cannot log onto my site as my server is updating its php to 4 from 3.

I don't know how much of a help this is :/

Bye,
fahhem

Anon

I don't quite follow what you want with the table, but it seems like you could nest tables to get the desired effect. The outermost table would have as many columns across as needed; inside each cell is a table with one column and as many rows as needed.

As far as the focus, here is a snippet copied from the source of Google's homepage, it sets focus to to input element. They define a function "sf()", then call the function from the "body" tag's onload event:

...
<script>

</script>
</head><body bgcolor=#ffffff text=#000000 link=#0000cc vlink=#551a8b alink=#ff0000 onLoad=sf()>
...

Anon

The PHP portion of the question could be solved something like the code below. The key is the modulus operator "%".

(note! I did not have time to test this prior to posting so it might not be perfect):

// assuming you already have a vlid query result stored in $result

$fields = mysql_num_fields($result);

$fieldindex = 0;

while($row = mysql_fetch_row($result))

$fieldvalue = $row[$fieldindex];

for($rowindex = 1; $rowindex <= $fields; $rowindex++) {

	echo "<tr>\n";

	echo "<td>$fieldvalue</td>";

	if(($rowindex % 4) == 0) {
		echo "</tr>";	
	}

}

}

jakyl

This is something i threw together awhile back. it's not perfect, but it works. sorry for the poor style, it was one of my first.

$result = mysql_query("SELECT FROM tbl_name"); // Where tbl_name is the name of your table.
$count = mysql_fetch_row(mysql_query("SELECT COUNT() FROM tbl_name"));
$count = $count[0]; // Get the number of records.
$numcols = 4;
echo "<TABLE>";
echo "<TR><TD>";
for($i=0; $i<ceil($count/$numcols); $i++) {
echo "<TR>";
for($j=0; $j<$numcols; $j++) {
$record = mysql_fetch_assoc($result);
echo "<TD>";
if($record) // Probably a while loop would be better, but this works.
echo "STUFF";
echo "</TD>";
}
echo "</TR>";
}
echo "</TR></TABLE>";