[RESOLVED] Making a hyperlink

tjbarr

I want to make the first run through on the for loop a hyperlinked field.

do
{
$myrow = pg_fetch_row($result_set,$rows);
printf("<tr>");
for ($i=0; $i < $count_ch; $i++)
{
printf("<td>");
if($myrow[$i]=='')
{
$myrow[$i]='-';
}
printf($myrow[$i]);
printf("</td>");
}
printf("</tr>");

$rows++;
  }
 while($rows < $rowsnum);

}

printf("</table>");

tjbarr

I actually want the first field to be a hyperlink not the first row.

zzz

I can't see any link tags...

Also, I'm not sure why you use printf instead of just print or echo

tjbarr

Edit by Inv. Number Church Name
11111 Joes Church
22222 Jims Church
33333 Bills Church

I want the Edit by Inv. Number Column to be a hyperlink to another page

tjbarr

Using this and it creates a hyperlink but I want to send over inv_no in the url.

if ('column' ==0)
{
echo "<a href='/page2.php' target='_blank'>$myrow[$i];</a>";
}
else
{
echo $myrow[$i];
}

So I tried this

if ('column' ==0)
{
echo "<a href='/page2.php?inv_no=<?php "$inv_no";?>'>$myrow[$i];</a>";
}
else
{
echo $myrow[$i];
}

tjbarr

do
{
$myrow = pg_fetch_row($result_set,$rows);
printf("<tr>");

for ($i=0; $i < $count_ch; $i++)
{
printf("<td>");
if($myrow[$i]=='')
{
$myrow[$i]='-';
}
if ($i==0)
{
$inv_no=$myrow[$i];
echo "<a href=\"../ccdsv2/svedit.php?inv_no=$inv_no\">$myrow[$i]</a>";
}
else
{
echo $myrow[$i];
}

printf("</td>"); 
}
printf("</tr>");

$rows++;
  }
 while($rows < $rowsnum);

}

printf("</table>");