Page 1 of 1

[56K WARN] Find a row

Posted: Wed Jan 10, 2007 5:34 pm
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

Posted: Wed Jan 10, 2007 7:10 pm
by Ollie Saunders
:google:
There are lots of tutorials on PHP and MySQL. Not to mention the manual on mysql_query()

Re: Find a row

Posted: Wed Jan 10, 2007 7:14 pm
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

Thank you!

Posted: Wed Jan 10, 2007 7:40 pm
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