select a column value

[nadeem14375]

Dear all,

 

new to php, so here a very easy thing which, I couldn't do.

 

i want to select a column value from a table. for example: select name from members where member_id = 1; for this in pl/sql the code is look like: select name into v_name from members where member_id =1;

 

the column value will be stored in v_name variable, now please guide me how it can be done in php. I want to display user name on page.

 

Regards:

 

 

[EdwinPaul]

<?php

// $connection should be populated correctly first

 

$sql="select name from members where member_id = 1";

$result=($sql,$connection);

if($result){

  $row=mysql_fetch_array($result);

}else{

  echo "no entry found";

  exit();

}

// now you can show the field 'name' from your table:

echo "Name: ".$row['name'].'<br/>';

?>

[nadeem14375]

 

the following example solved the problem. thanks for you response.

Example #1 mysql_result() example

 

http://php.net/manual/en/function.mysql-result.php

<?php

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');

if (!$link) {

die('Could not connect: ' . mysql_error());

}

if (!mysql_select_db('database_name')) {

die('Could not select database: ' . mysql_error());

}

$result = mysql_query('SELECT name FROM work.employee');

if (!$result) {

die('Could not query:' . mysql_error());

}

echo mysql_result($result, 2); // outputs third employee's name

 

mysql_close($link);

?>

<?php

// $connection should be populated correctly first

 

$sql="select name from members where member_id = 1";

$result=($sql,$connection);

if($result){

  $row=mysql_fetch_array($result);

}else{

  echo "no entry found";

  exit();

}

// now you can show the field 'name' from your table:

echo "Name: ".$row['name'].'<br/>';

?>