Page 1 of 1

Pulling specific cell data from mySQL db

Posted: Fri Jan 28, 2005 10:59 pm
by crazyb8ss
If i have a table, UserData, which columns userID username, password, title, email, title 1, title2, ... title 10, text 1, text 2, ... text 10 and the rows use userID as a primary identifier, how would i reteive data from say userID #7, and from the title10 column?

Posted: Fri Jan 28, 2005 11:34 pm
by timvw
time to read yourself an introduction into sql?

Code: Select all

SELECT column10
FROM foo
WHERE userID=7;

Posted: Sat Jan 29, 2005 9:55 am
by crazyb8ss
read? whats that? nobody reads anymore :lol:

Posted: Sat Jan 29, 2005 10:53 am
by crazyb8ss
after reading a section of the book that originally taught me php i solved the problem. I wwas unaware that the sql data could be outputted to an array