Showing us snippet of your code helps us show you how to specifically do it with your code.
But without that I can give you a few basic examples
In the following examples $rn could be the variable that you are passing from the url.
PHP Code:
$qry = "
SELECT *
FROM Table
WHERE `record_number` = $rn
";
$qry_res = mysql_query($qry);
while ($qry_row = mysql_fetch_array($qry_res)) {
echo $qry_row[0] $qry_row[1]; //ect
}
PHP Code:
$qry = "
SELECT *
FROM Table
WHERE `record_number` = $rn
";
$qry_res = mysql_query($qry);
while ($qry_row = mysql_fetch_array($qry_res)) {
list( $rn, $Col_1, $Col_2 ) = $qry_row;
echo $rn $Col_1 $Col_2;
}
PHP Code:
$qry = "
SELECT *
FROM Table
WHERE `record_number` = $rn
";
$qry_res = mysql_query($qry);
$qry_rows = mysql_num_rows($qry_res);
$qry_row = mysql_fetch_array($qry_res)
for($i = 0; $i < $qry_rows; $i++){
foreach($qry_row[$i] => $key as $value) {
echo $key $value;
}
}
Now that is the nice readable neat simple examples
PHP Code:
$qry_row = mysql_fetch_array(mysql_query(SELECT * FROM Table WHERE `record_number` = $rn));
In the above example $qry_row is the same as all the previous $qry_row and you can append the for or while loops from the previous examples.
There is also a way to do it with a class but that is likely beyond you at this time. So hope that helps.
As a side note do to that high risk of SQL injections with passing variables from a URL I recommend you use mysql_real_escape_string() and htmlentities() as well as other security precautions.
Join the friendly bunch on IRC...
Wishing I had hair to pull out...
)
Linear Mode
