Search found 4 matches
- Sat Apr 05, 2003 11:52 pm
- Forum: Databases
- Topic: how to copy a data from a table to anotehr table?
- Replies: 3
- Views: 567
how to copy a data from a table to anotehr table?
well this is if im not mistaken to copy the whole data in a table to another table INSERT into destination_table SELECT * from source_table; but how about if i want to copy a data from table a to table b? let say that we know the username and we want to copy his real name to another table..... well ...
- Sat Apr 05, 2003 11:01 pm
- Forum: Databases
- Topic: blocking re-registration using id that are already in the DB
- Replies: 5
- Views: 623
for the user to register. his idnum must be in the database. so, when he want's to register, php first will check either his id is in the database or not (im ok with this codes) and if his id is there.. the php will check whether the user id is already registered. commonly poeple will check for user...
- Sat Apr 05, 2003 9:59 pm
- Forum: Databases
- Topic: blocking re-registration using id that are already in the DB
- Replies: 5
- Views: 623
hmm...
$query="SELECT idnum, password FROM detail WHERE idnum='$idnum' and password='$password'"; // Run query: $result=mysql_query($query, $link) or die("MySQL query $query failed. Error if any: ".mysql_error()); // If that idnum already have the password, issue an error message: if( (...
- Sat Apr 05, 2003 9:17 pm
- Forum: Databases
- Topic: blocking re-registration using id that are already in the DB
- Replies: 5
- Views: 623
blocking re-registration using id that are already in the DB
he there..
just want to know how to make a query from php to mysql to check whether the user is already registered or not
.. as the registration requires that only those who have their id's in the database can register...
any suggestions?
just want to know how to make a query from php to mysql to check whether the user is already registered or not
.. as the registration requires that only those who have their id's in the database can register...
any suggestions?