pull specific table row column data to output in html using php

Question

how do i pull data from my database table and put that data into a readonly textinput in a form for a user to see.

<input readonly type="text" name="em1" id="em1"/>

for this specific field i want to pull the data from a column called wmyt000 in the row of the currently logged in user using a $username variable with session that i created to get the current logged in users username in a table called cash_flow_plan

im using mysql and php

i havnt attempted to try anything yet. i was looking into mysql_fetch_array but that wants to display all of the users information for their row.

Try adding a WHERE clause to your query.

andrewsi
– andrewsi

2012-08-13 13:39:24 +00:00
Commented Aug 13, 2012 at 13:39 — andrewsi
– andrewsi, Commented Aug 13, 2012 at 13:39

Kristian · Accepted Answer · 2012-08-13 17:06:28Z

1

i havnt attempted to try anything yet.

ya. well, if you had, you'd know that you can do more with it than you think.

if you write a query limiting your results, then you're going to get what you want.

$query = "SELECT wmyt000 FROM cash_flow_plan WHERE username = '$username'"

$row = mysql_fetch_row($query);

print_r($row); // now you can see the structure of your array. access it accordingly.

edited Aug 13, 2012 at 17:06

answered Aug 13, 2012 at 13:40

Kristian

22k19 gold badges108 silver badges184 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

NodeDad Over a year ago

sometimes i can be a little afraid of php thank you for your answer

NodeDad Over a year ago

so wait, now how do i tell the readonly input field to give me that value?

Kristian Over a year ago

updated my answer so you can see how to print the array out and see the exact structure of the result.... at this point, start googling, i just did. :)

Collectives™ on Stack Overflow

pull specific table row column data to output in html using php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related