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

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