Need to add url to php from mysql

bbsmfg3

Can someone either point me to some sample code or post some.

I have a database named "customer" with a table named "config"
In config row 3 is "url". In url is the website address "http://mysite.com"

I need to add a button to the php code that says "GoTo Mysite" and have that button pull the url from the mysql database and send the user to the mysite.com website.

I have searched the php site as well as others, and come up empty

Much appreciated.

djjjozsi

here is a simple code, which list the rows from customer table, and change the id field name in this code, if your primary key is not id

<?php

include_once("connect.php");
$sql="SELECT * FROM customer";
$result=mysql_query($sql);
while($rows=mysql_fetch_assoc($result))
{
	print "<a href=\"customer_details.php?id={$rows["id"]}\"> ".$rows["field1"]."</a><br>\r";
}
?>

And create a customer_details.php where you print the customer's details and make a link with the field pulled from the database:
(change the id field's name)

<?php
	if(!empty($_GET["id"]))
	{
		include_once("connect.php");
		$sql="SELECT * FROM customer WHERE id=".(int)$_GET["id"];
		$result=mysql_query($sql);
		if(mysql_num_rows($result)>0)
		{
			$rows=mysql_fetch_assoc($result);

		print " <a href=\"".stripslashes($rows["url"])."\" target=\"_blank\"> Visit my site</a><br>\r";
		print "field2:".stripslashes($rows["field2"])."<br>\r";
		print "field1:".stripslashes($rows["field1"])."<br>\r";

	}
	else
		print "No data found";
}
?>