[SOLVED] help show values from db

[maxbox]

Hello  , i need show in a html page all telephone nummber from tables can you help me

db suecia

tables  user:

tel

code

 

And my code to conn to db

 

<?php
$mysql_host="xxxxxxxxxxx";
$mysql_user="xxxxxx";
$mysql_password="xxxxx";
$mysql_db = "suecia"; 
$mysql_tables = "user";

$conn = mysql_connect("$mysql_host","$mysql_user","$mysql_password","$mysql_tables");
if (!$conn) {
    die('Could not connect: ' . mysql_error());
}

mysql_select_db($mysql_db,$conn);


$result = @mysql_query(SELECT * FROM user);

 

 

......................

 

[premiso]

<?php
$mysql_host="xxxxxxxxxxx";
$mysql_user="xxxxxx";
$mysql_password="xxxxx";
$mysql_db = "suecia"; 
$mysql_tables = "user";

$conn = mysql_connect("$mysql_host","$mysql_user","$mysql_password","$mysql_tables");
if (!$conn) {
    die('Could not connect: ' . mysql_error());
}

mysql_select_db($mysql_db,$conn);


$result = mysql_query("SELECT * FROM user");

while ($row = mysql_fetch_assoc($result)) {
      echo "User Tel: " . $row['tel'] . "   User Code: " . $row['code'] . "<br />";
}

?>

[Maq]

This is one of the most basic extractions from a MySQL database.  Please read up on the basics.

 

while($row = mysql_fetch_array($result)) {
   echo "Tel: " . $row['tel'] . "
code: " . $row['code'] . "

";
}

[maxbox]

Thank you very much 

 

How i can make a link for each telephone nummber  something like this :

 

0853191844  to  this adress

 

http://privatpersoner.eniro.se/query?searchword=0853191844&what=wphone

 

 

[ngreenwood6]

you would just do this:

 

while($row = mysql_fetch_array($result))
{
echo "<a href='http://privatpersoner.eniro.se/query?searchword=" . $row['code'] . "&what=wphone'>" . $row['tel'] . "</a>";
}

[maxbox]

Thank you this work fine