[PHP-DB] ODBC

Hi, Could anybody explain to me what ODBC is. Should I install it with mySQL. Thanks, Morten -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTE

[PHP-DB] ODBC

Hi, Could anybody explain to me what ODBC is. Should I install it when I use mySQL? Thanks, Morten -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAI

[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 everybo

[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 LAST_INSERT_

[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 (http://www.php.net

[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]... >

[PHP-DB] Multiple DB's

Hi, I use MySQL and are trying to have 2 open databases. I do like this: $db1=db_connect($CFG->dbhost, "DB1", $CFG->dbuser, $CFG->dbpass); $db2=db_connect($CFG->dbhost, "DB2", $CFG->dbuser, $CFG->dbpass); Then I am trying to run a CREATE TABLE, $qid = db_query(" CREATE TABLE tmp ( Dato INT(2) )

[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 Databa

[PHP-DB] Arrays

Hi, I need to store a lot of vaiables (75+) in a MySQL database. What is the best way to do this? Should I create a field for each variable in the database or is it possible to create an array for a series of variables? Regards, Morten -- PHP Database Mailing List (http://www.php.net/) To uns

[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,