A little help people? Viewing a record....

immerz

Hey Guys 🙂

The code below works great, it displays the records in a nice table based on the sql query...it works just fine. What I want to be able to do is add two links at the end of each row (delete, edit) but I cant seem to get the links to position/replicate next to each record to delete/edit that specific record...

Can anyone help?

Thanks.


<? 
    $usr = ""; 
    $pwd = ""; 
    $db = ""; 
    $host = ""; 

# connect to database 
$cid = mysql_connect($host,$usr,$pwd); 
mysql_select_db($db); 
if (mysql_error()) { print "Database ERROR: " . mysql_error(); } 

?> 
<html> 
<head> 
<title>Your New Entry</title> 
</head> 
<body> 
<?php 

function drawtable($qr) { 
    // $qr = results of a mysql_query 
    $rows = mysql_num_rows($qr); 
    $toreturn = "<table style=\"float: left;\" border=\"1\">\n"; 
    $toreturn .= "<tr>\n"; 
    for ($i=0; $i<mysql_num_fields($qr); $i++) { 
        $toreturn .= "\t<th>".mysql_field_name($qr,$i)."</th>\n"; 
        } 
    $toreturn .= "</tr>\n"; 
    for ($i=0; $i<$rows; $i++) { 
        $row = mysql_fetch_row($qr); 
        $cols = sizeof($row); 
        $toreturn .= "<tr>\n"; 
        for ($x=0; $x < $cols; $x++) { 
            if ($row[$x]==NULL){ 
                $row[$x]='&nbsp;'; 
                } 
            $toreturn .= "\t<td>$row[$x]</td>\n"; 
            } 
        $toreturn .= "</tr>\n"; 
        } 
    $toreturn .= '</table>'; 
    return $toreturn; 
    } 




$q = stripslashes($_POST['q']); 
if (empty($q)) { 
    $q = 'select  C_Title, C_Description, Resource_Name  from Changes order by Change_ID asc limit 100;'; 
    } 
mysql_select_db(""); 
$result = mysql_query($q); 



echo drawtable($result); 
echo '<table> 
</table> 
</body> 
</html>';

dalecosp

Well, what w/this?

echo '<table> 
</table> 
</body> 
</html>';

That seems pretty broken, to me.

Granted, it might not of when I was a newb (if, indeed, I'm not now), because I learned HTML by reading Microsoft application-generated source (it wasn't a good thing).

You might consider attempting to seperate your logic from your presentation, e.g.:

<?php

// foobar.php - my application

function foo($a) {
   return $bigarray;
}

function bar($b) {
   return $someresult;
}

$textline="This is something I want on my page.";

if (1) {
?><html>
   <head>
   <title>My Page</title>
   </head>

   <body>
      <table>
          <tr>
             <td><?php echo $textline; ?></td>
          </tr>
          <tr>
               <td><?php  $t=bar(); echo $t . "is the result."; ?></td>
          </tr>
      </table>
   </body>
</html>

<?php
}
?>

But, who wants to listen to me. I think I'm braindead this a.m.

Good luck,