Page 1 of 1

select a column value

Posted: Thu Jun 23, 2011 4:49 am
by 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:

Re: select a column value

Posted: Thu Jun 23, 2011 7:12 am
by social_experiment
nadeem14375 wrote:for example: select name from members where member_id = 1;
You are almost there :

Code: Select all

<?php 
$query  =  "SELECT name FROM members WHERE member_id = '1' "; 
$sql = mysql_query($query);
?>

Re: select a column value

Posted: Thu Jun 23, 2011 2:06 pm
by nadeem14375
Example #1 mysql_result() example
the following example solved the problem. thanks for you response.

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);
?>