Viewing data from QUERY

[phppup]

I know that I can fairly easily pull my data from the database and view it in a browser.

I can also 'polish' it with some HTML or put it into a table.

Can I get an item from a given VARIABLE to appear inside of an INPUT box, so that it looks the same as when it was initially submitted?

Can it be done with a multiple choice SELECT dropdown, so that the item chosen is viewable again?

[scootstah]

Yes.

$value = 'blah';

echo '<input type="text" name="something" value="' . $value . '" />';

[phppup]

I was gonna try something like that, but i GREATLY appreciate your response.  As a newbie it's VERY reassuring to know that something should work BEFORE attempting it.  Now if I run into trouble, I can at least feel confident that the effort is worthwhile, rather than the concept being impossible.

 

Thanks

[scootstah]

As a newbie it's VERY reassuring to know that something should work BEFORE attempting it

 

Indeed, but as a newbie it is also imperative that you test things out yourself and learn how they work.

[phppup]

Ohhhhhhh, rest assured, I AM!!!!!

 

Just noticed that certain numeric inputs in the database are shown as 3.00 and others as 3.  Then I realized some fields were SMALLINT and others were VARCHAR.

 

I try not to post unless I'm really stumped, or short of time (because of the HOURS LOST chasing wrong solutions... LOL.  Nonetheless, I am enjoying the process.  Even at 3AM!

 

[scootstah]

If you are storing floats then you should use one of the float data types (float, double, real).

[phppup]

Just storing simple numbers, nothing >20 and only some are in intervals of .5

 

(ie: for certain items 1.0, 1.5, 2.0, 2.5 etc., and others just whole numbers: 1,2,3,4,5,etc)

[Pikachu2000]

Then you wouldn't use integer data type. Here are the numeric data types for MySQL.