dump file and hyperlink

[Anon]

How do I dump a column from a file and have each value as a hyperlink, either fixed or variable?

[[deleted]]

What's the format of your file?

[Anon]

a simple database. I have an order number as the index and a UPS number as a field. I want to lookup the order number and receive the UPS number ready for tracking. For example http://www.ups.com/tracking?number=12345

[[deleted]]

So are we talking about a comma-delimited file or a "real" database?

[Anon]

I am using MySql

[[deleted]]

Ok, now we are getting somewhere.
So you want to run a query on a MySQL database and print
the results on a page asig they were hyperlinks.

Read the manual about how to run queries on a MySQL database,
it is exmplained with examples.
As for the printing, just loop through the results
you get from your query using the mysql_fetch() command (again, read manual)
And print the content of the result like this:

echo "<a href=".$URL_column.">".$URL_column."</a>";

that is assuming you have a column that contains the real URL.

[Anon]

thank you

[Anon]

simply do a select statement ...I think, and with the returned value do this

print "<a href=\"www.$myvariable.com\">$myvariable</a>"

is this what you mean ?