[vioss]

how to retrieve information from the database to the PHP webpage????

below is a table in MYSQL
-------------------------------------------------------------
Name l Year started l address l id l
-------------------------------------------------------------
john l 2000 l London l J007 l
-------------------------------------------------------------

how can i just select the year started (2000) to show at the PHP web page?

[BradC]

Very basic... but will pull the info..

Code:

<?php
define("SQL_SERVER", "localhost");
define("SQL_UID", "username");
define("SQL_PWD", "password");
define("SQL_DB", "database");

$connection = mysql_pconnect(SQL_SERVER, SQL_UID, SQL_PWD);
mysql_select_db(SQL_DB, $connection);

$idname = "J007"; // if you have more documents you can select a different user.

$sql = "SELECT * FROM <tablename> WHERE id = '$idname'";
$result = mysql_query($sql);

$Name = mysql_result($result,0,"Name");
$Year = mysql_result($result,0,"Year started");
$Address = mysql_result($result,0,"address");
$ID = mysql_result($result,0,"id");

echo" Name = $Name<br>Year = $Year<br>Address = $Address<br>ID = $ID";

?>

[tai fu]

Here our friend BradC has suplied you with the basic PHP functions for accessing a MySql database, all you have to do now is learn the Mysql - PHP queries at www.w3schools.com (free )..

[vioss]

thanks here first,

then is it possible to store and then retrive back the data that i just store into the database by using PHP code?

[jv2222]

Try this:

http://ezresults.jvmultimedia.com