[PHP-DB] MySQL database

Hi, Could anybody explain to me how I should make a table with usernames and passwords. I want to make a site, where users can sign up and enter some values, which is stored in a different table. How do I grant the necessary acces to the tables, so users can enter values into them? Please help,

[PHP-DB] MySQL

Hi, Is there an easy way to see the data in a table? I made a table that contains information about people. How do I see/change the contenst of the table? Thanks, Morten -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] DB question

Hi, I am about to make a homepage where people can sign up. It is then possible for the user to enter a lot of different data about them self. Is it normal to make a database for each user or should I make one big one? If I make a big one am I going to get problems if I has 1000+ users and

[PHP-DB] Retreiving data from a table

Hi, I got the following insert statement in my PHP code: $qid = db_query( INSERT INTO table1 ( Name ) VALUES ( '$frm[Name]' )); This is working like I want it to But in the table there is a column, which is AUTO_INCREMENT I would like to retreive this number right after I added the

[PHP-DB] LAST_INSERT_ID()

Hi, In the PHP manual under the function mysql_insert_id() function they have the following line: The value of the MySQL SQL function LAST_INSERT_ID() always contains the most recently generated AUTO_INCREMENT value, and is not reset between queries. How do I get to use the function

[PHP-DB] Multiple SELECT querys

Hi, I make a SELECT in a mySQL database. It returns a variable, which contains 10 values. I then need to make another SELECT in a new database where I have to use the previous 10 values in the WHERE sentence. How can I do this? Regards, Morten -- PHP Database Mailing List

[PHP-DB] Wildcards

Hi, I am trying to make a SELECT command like this: $qid =db_query( SELECT ID, NAME, ADDRESS FROM users WHERE ID=* AND NAME='John' ); Is it somehow possible to have a wildcard, so it returns all records, where the name is john and the ID is not important? Regards, Morten --

[PHP-DB] Re: Wildcards

It is because it is a search function where a user can enter an ID, NAME and ADDRESS to search after. If one of the fields are empty it should use the wildcard. Morten Nielsen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, I am trying to make

[PHP-DB] Zeropadding

Hi, I use MySQL where I have a table. One of the fields is an INT(6), which I zeropad. When I try to get the number to a variable it doesn't contain all the numbers. If I give it a value of 59 I extract 59 and not 59. Is there a way I can get the hole number? Regards, Morten -- PHP