[56K WARN] Find a row

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
ykarmi
Forum Commoner
Posts: 35
Joined: Mon Oct 30, 2006 4:45 pm

[56K WARN] Find a row

Post by ykarmi »

Hey guys,
I have a simple question. I have a database set up like this:

Image

In theory, lets say I'm connected to the MYSQL database using PHP,
Now, say I want to read from the user "kayla" row "three" and retrieve its value to a PHP variable.
How is it done using PHP?
Thank you very much,
Yuval Karmi
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

:google:
There are lots of tutorials on PHP and MySQL. Not to mention the manual on mysql_query()
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Re: Find a row

Post by volka »

ykarmi wrote:Now, say I want to read from the user "kayla" row "three" and retrieve its value to a PHP variable.
You want to read the column/field three of the record where the field user equals kayla.
see http://www.w3schools.com/sql/sql_where.asp
ykarmi
Forum Commoner
Posts: 35
Joined: Mon Oct 30, 2006 4:45 pm

Thank you!

Post by ykarmi »

Thanks for the advice Ole, I'm learning MySQL right now, and thank you very much to Volka, although by the time you replied I already had it figured out, If I wouldn't, your advice would obviously put me in the right direction! :D :D :D
Post Reply