Acquiring a certain value?!

[rIkLuNd]

I want to print out a certain value stored in a MySQL database into a form input, but I don't know how to do. The value I want to acquire is "subject". I've come this far:

<?php

$link = mysql_connect($host,$user,$pass);
if(!$link)
die(mysql_error());

$select = mysql_select_db($db);
if(!$select)
die(mysql_error());

$query = mysql_query("SELECT subject FROM entries WHERE id='$id'");
if(!$query)
die(mysql_error());

// The code to extract the value. Please help me with it!

?>

I'm a total newbie, and I'll be really happy if you'd correct this code, and add the code to extract the "subject" value.

// rIkLuNd

[Tekron-X]

well the code looks good so far 😉

but to extract the values out of the db you nn=eed to use something like this

note this is just an example to get you started don't just insert this into your code you must form and manipulate it to your needs

$link_id = db_connect('your db name');
$result = mysql_query("SELECT * FROM whatever", $link_id);

for($i = mysql_num_rows($result)-1; $i >= 0; $i--)
{
    mysql_data_seek(result, $i);
    $query_data = mysql_fetch_array($result);

echo "<input name=whatever you want  type=whatever you need value='$query_data[the index for the value you want];'>

}

hope that will help you if not let me know 🙂

[rIkLuNd]

YES, it worked! Thank you very much, Tek!

// rIkLuNd

[Tekron-X]

AHHHHH I just needed to move the screen a bit oopppssseee

Np glad I can help. I am relativley new to php also and you are the first person I really got to help and I apriciate doing so and once again I say your welcome.

[philipolson]

Another (more common) method:

One row:

$row = mysql_fetch_assoc($result);
print $row['subject'];

Assuming more then one row exists, use a loop:

while ($row = mysql_fetch_assoc($result)) {
    print $row['subject'];
}

[Tekron-X]

WoW never thought of that way it is alot easier than my way lol 🙂