First mySQL Table :: Opps..Problem!

**lynlimz** · Apr 12, 2001 00:50

Hi,

Is there anything wrong with the code i use to create the table? Cause I can't select the table! Produces an error. ( I can connect to database successfully ).

Thank you for your help.

Code:

CREATE TABLE Accounts (
   Username varchar(10) NOT NULL,
   Password varchar(8) NOT NULL,
   Name varchar(15) NOT NULL,
   Country varchar(15) NOT NULL,
   Age int(11) DEFAULT '0' NOT NULL,
   Date date DEFAULT '0000-00-00' NOT NULL,
   PRIMARY KEY (Username)
);

**KMxRetro** · Apr 12, 2001 03:15

Nope, worked OK for me.

Maybe something in your SELECT statement? Post the query and I'll have a look.

Cheers,

**lynlimz** · Apr 12, 2001 03:22

Hi,

Thanks for your Reply.

Here's my SELECT statement.

Code:

$table_user = @mysql_select_db("Accounts");
if (!$table_user) {
    echo "error";
    exit();
}

**MattR** · Apr 12, 2001 03:33

the "mysql_select_db" function is used to move the database context from one DATABASE to another..

A database consisits of many tables, and you can have many databases in MySQL.

What you want is the mysql_query( "SELECT ... FROM Accounts ..." );
function.

**lynlimz** · Apr 12, 2001 04:13

BTW,

Her'e smy updated Database

Code:

#
# Table structure for table 'Accounts'
#

CREATE TABLE Accounts (
   ID int(11) NOT NULL auto_increment,
   Username varchar(10) NOT NULL,
   Password varchar(8) NOT NULL,
   Country varchar(20) NOT NULL,
   Name varchar(20) NOT NULL,
   Age int(11) DEFAULT '0' NOT NULL,
   Email varchar(20) NOT NULL,
   Date date DEFAULT '0000-00-00' NOT NULL,
   PRIMARY KEY (ID)
);

Thanks MattR..I'll take a look when I'm home again. =) Dinner time~!

**freakysid** · Apr 12, 2001 04:19

This is not a reply

I don't know what's going on with vBulletin - I would like to post some code but I cant post

In the post below is there ant reason why I can't put the last snippet of code in php tags?

**freakysid** · Apr 12, 2001 04:25

So for every script that you want to access the database you need a connection to the database. You only need to open the connection once per script. Eg:

PHP Code:


$dbconx = @mysql_pconnect("host:3306", "user", "pword")

   or die( $strError);

@mysql_select_db("database", $dbconx)

   or die( $strError);

Then when you want to perform an sql query on a table or tables in the database you format a query string and use mysql_query() as matt explans. An example would be

PHP Code:


$sql = "SELECT * FROM Accounts";

$result = mysql_query($sql, $dconx);

Now $result is a handle to a result set which is sitting around waiting for you to extract data from. Usually you will want to loop through the result set and extract one row at a time (temporarily storing it into an associative array) and say, for example format it as html. An example where we display each user and their country

echo '<table>';
while ($row = mysql_fetch_array($result) {
echo '<tr><td>' . $row["Username"] . '</td><td>' . $row["Country"] . '</td></tr>';
}
echo '</table>';

**nguip** · Apr 12, 2001 04:42

What wrong with vbulletin ? I can't post code here

**KMxRetro** · Apr 12, 2001 04:58

Seems to be having some problems. I just got the message "The server is too busy, try again later" in a vBulletin fully formatted page.

Sudden boom in subscribers/viewers? Server probs? Who can tell?

Not me

**lynlimz** · Apr 12, 2001 06:46

So is there actually any problem with my code? Casue I still can't select the table.

**lynlimz** · Apr 12, 2001 06:57

BTW..I managed to get an error query, and it says Access Denied? WHY?

I can connect to the database successfully.

**lynlimz** · Apr 12, 2001 07:09

BLEH!!! I'm stupid!!!!

Accounts was the name of the table! I was suppose to specify the database name! ARGH!

LOL
Thanks once agian for ALL your help!

**freakysid** · Apr 12, 2001 07:19

Blah - I was in the middle of typing a long winded post when I saw you got it sorted

**lynlimz** · Apr 17, 2001 01:55

LOL Freaksid....you didn't post in the end?
It would be good experience..

I'm just starting out in this mysql thingy...so I'm really unclear about the whole process...well ( getting through slowly though )

Thanks fro your ingenius help!

**nguip** · Apr 17, 2001 05:15

LoL

You all just so cute ! So, I'll joinn you all loh.. I just finished Kelvin's tutorial.. so, I'm also newbies here.

But, I haven't found the tutorial lynlimz talked about, the jump start of URL.

I guess I may want to go thru that one as well

**lynlimz** · Apr 17, 2001 05:22

Originally posted by nguip
But, I haven't found the tutorial lynlimz talked about, the jump start of URL.

Hmm...While you can read, practising and actually making the effort to do it is another. I read KYank's tutorials ages ago...when it was first released...geez...

LOL

What you mean bu the jump start url? lol...odn't get you on that! =)