On Database Selections

[Anon]

If I connect to a database, and so something like Select some fields from a table. Could I just use the field names as variables? or do I need to do something else first? Like:

sql_query(select field_one, field_two, field_three from table_name where field_one="001");

echo "<h1>field_one<br>field_two<br>field_three<br></h1>";

and have it display the results?

001
This is field 2
Contents of field 3

please help 🙂 I've looked around for info on displaying database results and haven't found anything.

[Anon]

oops... forgot to put the $ in the variables in the echo function

[[deleted]]

Begin by reading the PHP manual section for your database type, it explains it all.

[Anon]

I've looked and cannot find that info. I also search the PHP Manual for "Data Type" and "varchar" and nothing relevant came up. Can you give me the link?

[[deleted]]

http://www.php.net/manual/en/

look for the sections like "mysql functions" and "postgresql functions"

[Anon]

Cool, that helps a lot 🙂 Thanks!