<?php
include'func.php';
$id = $_GETї'ID'];
$query_string = "SELECT * FROM PRJtrack WHERE id='$id'";
$result = mysql_query($query_string,$global_dbh) or die(mysql_error());
// Create the table and the headers to go across the top.
print("<TABLE BORDER=1 WIDTH=100%>\n");
while ($row = mysql_fetch_array($result))
{
print("<tr><th>Project Number</th><td><input type=text name=PrjNum value=$rowї1] Size=20 MAXLENGTH=50></td></tr>
<tr><th>Project Description</th><td>$rowї2]</td></tr>
<tr><th>Cacti Status</th>
<tr><th>Orion Status</th>
<tr><th>Tacacs Status</th>
<tr><th>CW Status</th>
<tr><th>Edit</th>
<tr><th>Delete</th>
<tr><th>Complete</th></tr>");
}
?>
The $row[1] should return the description of the task such as "Enter the new values into the db", only all I get back is "Enter". Why doesn't it return the entire string? The PrjDesc var works fine, and they are the same type in the MySQL db.
...
while ($row = mysql_fetch_array($result))
...
...
<tr><th>Project Description</th><td>".$row['2']."</td></tr>
...
As PanK said, you probably need to surround them in quotes, but do not use double quotes, use single quotes. This is because you have used print with double quotes, and so the script will parse incorrectly.
That worked great. Thank you everyone for your help and input! I've been using Cold Fusion for years, and now I'm moving to a real web programming language. There are a few bumps in the road! Thanks again.