hyperlink in results page

timinator

Hi, in my results page I have set up a table to receive data. How do I get one of the fields apperar as a hyperlink? These are the field names:
MLA_NO, NAME, STREET, CITY, STATE, ZIP, PHONE, FAX, IP_ADDR
I would like IP_ADDR to appear as a hyperlink

thanks

Here is the code just below the table setup:

while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td nowrap bgcolor=#669966>&nbsp$field</td>\n";
print "</tr>\n";
}
print "</table>\n";

Pig

hyperlink to what? That would be pretty critical.

timinator

The data returned in the IP_ADDR field are urls. I need them to active hyperlinks when clicked by the user.

Thanks

Pig

you need to manually go through the vars instead of just doing a foreach on the row (or put an if statement in your loop to catch it when it comes by).

Then you can just echo:
<a href=\"$var\">$var</a>

timinator

Can you give me an example from the code I've posted?

Thanks

Pig

//you used mysql_fetch_row, so I assume you have only one row 
//expected.  Assuming that is correct, here is the code.

$row = mysql_fetch_assoc($result);
echo("<tr><td>$row[MLA_NO]</td></tr>");
echo("<tr><td>$row[NAME]</td></tr>");
echo("<tr><td>$row[STREET]</td></tr>");
echo("<tr><td>$row[CITY]</td></tr>");
echo("<tr><td>$row[STATE]</td></tr>");
echo("<tr><td>$row[ZIP]</td></tr>");
echo("<tr><td>$row[PHONE]</td></tr>");
echo("<tr><td>$row[FAX]</td></tr>");
echo("<tr><td><a href=\"$row[IP_ADDR]\">$row[IP_ADDR]</a></td></tr>");

timinator

That worked! but the data is is all going into the first column.

Thanks

Pig

Sorry, misread your code. Just take out the <tr></tr>'s

timinator

Much better - thanks

In the hyperlink to get it to use an absolute path I added "http://"
to the a href=

it now looks like this:
echo("<td><a href=http:/\'$row[IP_ADDR]\'>$row[IP_ADDR]</a></td>");

But when you mouse over the hyperlink in the results it looks like this:

[url]http://[/url]'WWW.KINGFOODSERV.COM/'

how do I remove the single quotes to make the link work?

Pig

Just delete them.

timinator

If I delete them the link looks like this:

http://jmg.com/$row[IP_ADDR]/

timinator

I changed it to this:

and it is fine.

thanks

timinator

Using the following code, my result are returning every other record!

while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
//foreach ($get_info as $field)
$row = mysql_fetch_assoc($result);
echo("<td nowrap>$row[MLA_NO]</td>");
echo("<td nowrap>$row[NAME]</td>");
echo("<td nowrap>$row[STREET]</td>");
echo("<td nowrap>$row[CITY]</td>");
echo("<td nowrap>$row[STATE]</td>");
echo("<td nowrap>$row[ZIP]</td>");
echo("<td nowrap>$row[PHONE]</td>");
echo("<td nowrap>&nbsp$row[FAX]</td>");
echo("<td nowrap>&nbsp<a href=http://$row[IP_ADDR]>$row[IP_ADDR]</a></td>");
}

Pig

you have to use mysql_fetch_array() if you are going through the array. mysql_fetch_row and mysql_fetch_assoc are only for single rows.

If you are going through the array, then you don't want to do a foreach. just go straight to the echo.

timinator

I changed the lines:

while ($get_info = mysql_fetch_row($result)){

$row = mysql_fetch_assoc($result);

to:

while ($get_info = mysql_fetch_array($result)){

$row = mysql_fetch_array($result);

same results - every other record and in reverse order.

Pig

No no no. You don't call it twice - only one time!

while ($row = mysql_fetch_array($result))
{
     echo("<tr>");
     echo("<td nowrap><font face=arial size=1>$row[MLA_NO]</td>"); 
     echo("<td nowrap><font face=arial size=1>$row[NAME]</td>"); 
     echo("<td nowrap><font face=arial size=1>$row[STREET]</td>"); 
     echo("<td nowrap><font face=arial size=1>$row[CITY]</td>"); 
     echo("<td nowrap><font face=arial size=1>$row[STATE]</td>"); 
     echo("<td nowrap><font face=arial size=1>$row[ZIP]</td>"); 
     echo("<td nowrap><font face=arial size=1>$row[PHONE]</td>"); 
     echo("<td nowrap> <font face=arial size=1>$row[FAX]</td>"); 
     echo("<td nowrap> <font face=arial size=1><a href=http://$row[IP_ADDR]>$row[IP_ADDR]</a></td>"); 
     echo("</tr>");
}

timinator

Much better - thanks - I would also like to have one of the fields link to a details page using "MLA_NO" as the unique field.

should I start a new thread?

thanks

Pig

Guess that depends on how well you understand my answer.

when you echo the number, make it a hyper link, and pass the id in the query string.

page.php?id=$row[MLA_NO]

On page.php, you will need to query the database based on that id. Make sure you control for SQL injection when you query with $_GET data. If you are not familiar with that concept, check this out: http://www.phpfreaks.com/phpmanual/page/security.database.html

timinator

I'm trying to query the database based on the mla_no but not getting any records. Here is the end of the sql statement:

FROM company WHERE mla_no='$row[MLA_NO]'");

the url in the browser is correct
http://webserver/details2.php?MLA_NO=158350

thanks

timinator

Changed it to :

FROM company WHERE mla_no='$_GET[MLA_NO]'");

and received data. Need to clean up html