I'm stuck, please help me (php and mysql)

[freak-me-baby]

Hi all,
could some please help me?
I've made a page in php calles test.php
It's connected 2 a database.
I've wrote a script that looks like this;

<table border="1"> <tr> <th>links</th> <th>links</th> </tr>

<?php
include("connect.php");
$result = mysql_query ("SELECT id, microscope FROM information"); while (list
($id, $microscope) = mysql_fetch_row ($result))
{ print (" <tr>\n". " <td><a href=\"test2.php?id=$id&amp;microscope=$microscope\">$microscope</a></td>\n"); }

?>
</tr>
</td>
</table>

I really want 2 know how the php script in my test2.php should look like!

The microscope (only text) that has been choosen should apear on the test2.php

I hope You poeple understand want I mean
Otherwise ask me please cuz i'm stuck at this point
thnx

[cschotch]

so do you just want it to list the values of $id and $microscope?

[freak-me-baby]

yeah that's right....
I just want the values 2 be shown

[cschotch]

try this

<table border="1"><tr><td>Link</td></tr>
<?php
mysql_connect('localhost','username','password');
mysql_select_db('table');

//Put whatever in your query
$query = 'SELECT ID, microscope FROM information';

$result = mysql_query ($query);
while($row = mysql_fetch_object($result))
{

echo '<tr>';
echo '<td>';
echo $row->ID;
echo '</td';
//echo '</tr><tr>';
echo '<td>';
echo $row->microscope;
echo '</td>';
echo '</tr>';
}

?></table>

tell me if it works and if not ill try it on mine

[freak-me-baby]

It worked, but it didn't turn out the way i wanted!
I shall try 2 be a little clearer!
I've got 4 microscopes with 4 id's

If I click on microscope 2 with #id=2 then I only want to see on the next page:

Id=2 microscope=Microscope2

Now I'm getting al the microscopes and al the id's
So please help me again
🙂

[cschotch]

ok so you have 2 pages here.
A form that controls which one you want to see and then the final output???

[freak-me-baby]

Yes there are 2 pages, or one by using php_self i don't mind, but lets keep it by 2 pages test.php and test2.php! test.php shows the 4 id's with the 4 microscopes from the mysql database!
By clicking on one of the microscopes you should see the micrsocope with it's id on the next page (test2.php)!

I hope I'm a little bit clearer right now 🙂

(eventually when al the data is put in the database you'll have to get the information about the microscope when clicken on the microscope, so that's why I already need the script)

[ahundiak]

test2.php

<?php
  echo 'ID = ',$_GET['id'],'<br />';
  echo 'MICROSCOPE = ',$_GET['microscope'],'<br />';
?>

[freak-me-baby]

Thank you so much
That was what I needed 🙂