php and urls

[Anon]

How can u directly load a url from a table on a mysql table ?

By load i mean read the row find the url (column url) and open that url

I have tried everything but i have failed ...apperciate ur assistance ?

Jess

[terje-s]

Uhm.. How about;

$result = mysql_query('db', "SELECT url FROM table WHERE id=something");
Header("Location: ". mysql_result($result, 0, 0));

Assuming you don't need any sanity-checks etc.. :> you could ofcourse do $var = mysql_result($result, 0, 0); and do whatever you want to that variable,. and then Header("Location: $var"); .. 🙂

[Anon]

hi jessica,

here is an example for your problem

$sql = mysql_query("select url from website where id = '$urlcode'");
if (mysql_num_rows($sql) != 0)
{ $url = mysql_result($sql,0,"url");
if (!($fp = fopen("$url", "r")))
{ print "cannot find url"
}
header("location:$url");
}

hope this helps.

cheers,

jojit