visualizing columns

mduran

Hi,

Here is my problem: I want to visualize all columns from a table. The contents of the last one are too large, so I though of instead of showing those on the table, just output a link (perhaps a small gif or just the word 'view') so that when you click on it you get a pop-up window with the contents of that last column.

The way i do it now is:

$query = "select * from blah blah...";
$result = mysql_query($query);
$j=0;
while($row=mysql_fetch_array($result))
{
echo "<tr>";
for($i=1;$i<sizeof($columns);$i++)
echo "<td class='small'bgcolor=\"$color\"><center>".$row[$columns[$i]]."</td>";

How can I do this ?

Thanks a lot !

DigitalExpl0it

$query = "select * from blah blah...";
$result = mysql_query($query);
$j=0;
while($row=mysql_fetch_array($result))
{
echo "<tr>";
echo "<td class='small'bgcolor=\"$color\"><center>".$row[columnname]."</td>"; 
echo "</tr>";
}

looked like you had a loop within a loop

mduran

ok, but this does not solve my problem. Any idea ?

harlowhair

you can print out the contents of all f the columns except the last, and then include a hyperlink similar to:

print("<a href=\"popupwin.html?rowid=" . $row["id"] . "\">view</a>");

where the popup window will access the database, and pull out the contents of the last column in the row with the id 'rowid'. I think this makes sense!

basically, the code for the popup win will look like:

$query = "SELECT last_column FROM table_name WHERE id_field = " . $_GET["rowid"];

then print out the results of the query.

mduran

Works... partially. I get my pop-up window with the info of the last column in it, but at that moment my main window changes and I get the line:

[object]

and nothing else.

What am I doing wrong ??

harlowhair

I'm not too sure what the problem is - are you using javascript to open the popup? If you post the code of the popup, and the code which opens it, I might be able to help.

If you are using javascript, try using an html link instead, and setting target="_BLANK" in the anchor tag. Only drawback of this is that you can't specify the width, height etc. of the new window

feldon23

Based on my limited PHP knowledge, I'd do this:

if ($HTTP_POST_VARS['showlast'] == 'true') { 

show last column (this will be the popup)

} else {

current php code which shows all columns except the last one in a table

echo("<a href=\"".$PHP_SELF."?showlast=true\" target="_blank">
Click here to see the last column.</a>");

}

mduran

Sorry, I was in the good way; in my link I used javascript to open the pop-up with certain dimensions, but the line

print("<a href=\"javascript:window.open('popupwin.html?rowid=" . $row["id"] . "')\">view</a>");

does not work properly. I have solved it using a variant:

print("<a href onClick=\"window.open('popupwin.html?rowid=" . $row["id"] . "')\">view</a>");

Anyway, thanks a lot.