Qbasicboy
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by Qbasicboy
-
-
I\'m currently creating a system where a user has multiple tables, such as $username_asdfaf, $username_aaaaaa, $username_asdf. I was wondering how to create a SQL statement to select each table based upon the username, and display them. Any ideas? thanks!
selecting tables, with variables
in MySQL Help
Posted
I\'m a bit new to MySQL. I\'ve been trying to do this, but with no luck. I have several tables within a database for each user. For instance, I have username_grade, username_teacher, username_etc for specific information inside those tables. My question however, is how to create a mysql querry to only select tables using the username attribute. for instance, when a user wnats to see all the tables he has, only the tables for his username show up. Any ideas? thanks