Creating links in tables with SQL field

Question

I have the following code for displaying results in a table. I am in need of a bit of help taking the ID from Tickets table and using it on the end of the hyperlink e.g. ".php?id=7" I have been reading tutorials on this however things dont seem to be happening for me. Thanks in advance.

<table class="table">
    <tbody><tr><th>ID</th><th>Site Name</th><th>Title</th><th>Description</th><th>Quick Description</th><th>Contact</th><th>Status</th></tr>
<?php
$con = mysqli_connect(*credentials*);
if (!$con)
  {
  die('Could not connect: ' . mysqli_error());
  }

$result = mysqli_query($con, "SELECT * FROM Tickets WHERE Status='Open' AND Active='active'");

while($row = mysqli_fetch_array($result))
  {
  echo "<tr>";
  echo "<td><a href='//PHP/displayticket.php?id=$ID'>" . $row['ID'] . "</a></td>";
  echo "<td>" . $row['SiteName'] . "</td>";
  echo "<td>" . $row['Title'] . "</td>";
  echo "<td>" . $row['Description'] . "</td>";
  echo "<td>" . $row['quickdesc'] . "</td>";
  echo "<td>" . $row['Contact'] . "</td>";
  echo "<td>" . $row['Status'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysqli_close($con);
?>

Please, remove your password from here and change it on the server! — blue
– blue, Commented Mar 31, 2014 at 13:10
I edited your post to remove credentials, but it could be safer to change it anyway on your server... — Laurent S.
– Laurent S., Commented Mar 31, 2014 at 13:12
palm slaps face ah... what a stupid mistake... thanks for editing it out! — Jack_McG
– Jack_McG, Commented Mar 31, 2014 at 13:15

Brovoker · Accepted Answer · 2014-03-31 13:19:17Z

2

echo "<td><a href='//PHP/displayticket.php?id={$row['ID']}'>" . $row['ID'] . "</a></td>";

Do you mean like this? Or am I not understanding your question?

edited Mar 31, 2014 at 13:19

Brovoker

8945 silver badges16 bronze badges

answered Mar 31, 2014 at 13:12

Adam

1,9953 gold badges27 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

blue · Accepted Answer · 2014-03-31 13:14:01Z

1

Replace:

while($row = mysqli_fetch_array($result))

With:

$rows = mysqli_fetch_array($result, MYSQLI_ASSOC);
foreach ( $rows AS $row )

answered Mar 31, 2014 at 13:14

blue

1,9471 gold badge11 silver badges8 bronze badges

Collectives™ on Stack Overflow

Creating links in tables with SQL field

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related