get value from table

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dmakris
Forum Newbie
Posts: 11
Joined: Tue Jun 03, 2003 7:58 am
Location: Greece

get value from table

Post by dmakris »

Hello.
I have created a table in mysql in which I keep information about courses that people can study.
Some of the fields I use are course_name, category, key, etc.
There are many courses with different info for each one.
I also use a field as a key (pass) for the user to be able to join a specific course.
Is there any way to select a specific key of a specific course from the table and print it on screen?

Thanks in advance...
MrKnight
Forum Newbie
Posts: 22
Joined: Fri Jan 28, 2005 8:54 am
Location: Another Planet

Post by MrKnight »

Code: Select all

SELECT key FROM table WHERE course_name  = 'php_mysql_education';
Post Reply