Okay i need some more mysql help

I am connecting to the db fine and dandy. but what i need to do is the following

PHP Code:

<?php

/*
Componet Information Page
*/

require_once 'productinfodbonnect.php';

$rowid = $_GET['id']; // this is what i need to retrive from the db

// then display it in a table


?>

is to take $rowid go into the db get row id lets say plbc (stands for plain black case) and then display whats in that row in a table

Thanks in adavance

<?php
$connection = mysql_connect ("locahost", "dbsuername", "dbpassword");
or die ("cannot make connection") (mysql_error));
$db = mysql_select_database ("db_name" $connection");
or die (" cannot select Database") (mysql_error));

$sql = mysql_query("SELECT * FROM table_name WHERE rowid ="$id"
while ($row = mysql_fetch_row($sql)) {
echo "$row[0] $row[1] $row[2] <br />";
}


What next u wanna Do ???

okay i need to set the data from my mysql db in to varibles that can be expressed in a table.

and how does this mesh

PHP Code:

<?php

/*
Componet Information Page
*/

require_once 'productinfodbconnect.php';

$rowid = $_GET['id'];

$sql = mysql_query("SELECT * FROM table_name WHERE rowid ="$id"");
while ($row = mysql_fetch_row($sql) {
echo "$row[0] $row[1] $row[2] <br />";

?>

without seeing how your db conn file does it's work, it's hard to know whether it's doing a complete job. I'll assume it goes as far as pc connect...

array index numbers aren't very human friendly, try mysql_fetch_accoc($sql);

PHP Code:

<?php

require_once 'productinfodbonnect.php';

if(isset($_GET['id'])){

$rID = $_GET['id'];

mysql_select_db($database, $conn);
$sql = 'SELECT * FROM table_name WHERE rowid = '.$rID;
$query = mysql_query($sql, $conn);
$row = mysql_fetch_assoc($query);
$totalRows = mysql_num_rows($query);

}

do{

echo $row['columnName1']; // etc...

}while($row = mysql_fetch_assoc($query));

echo 'Total Records: '.$totalRows;

?>

the db file is completly working. connects to db and selects table to use.

in table what would i use

<?php echo "productimg" ?> (thats would be the first field in the db) and so on? to display it in a table for people?