urgent help...

[vonnero]

I am not sure where the problem is..... but still cant get it to work... Please assist. Thanks

 

 

 

$dbh=mysql_connect("localhost","user","password");

 

if($dbh)

{

echo "Connected to MySql Server<Br>";

}

else

{

echo mysql_error();

}

 

 

 

$select=mysql_select_db("students");

 

 

if($select)

{

echo "database selected<br>";

}

 

$query=mysql_query("CREATE TABLE friendslist (id INT AUTO_INCREMENT PRIMARY KEY, requestorid INT not null,requestedid INT not null,requestedate TIMESTAMP not null, response varchar(10) null");

 

if($query)

{

echo "Tables created";

}

[Mchl]

I am not sure where the problem is.....

 

Neither do I, because you did not write what's going on.

Do you get any error messages?

[.josh]

I keep trying to figure out what's going wrong, but that whole "urgent" thing puts too much pressure on me.  I'm too nervous to think straight.

[gevans]

I keep trying to figure out what's going wrong, but that whole "urgent" thing puts too much pressure on me.  I'm too nervous to think straight.

 

I don't like seeing you nervous, it makes my working day unstable 

[premiso]

Well almost 5 hours later, hope that is urgent enough *rollseyes*

 

CREATE TABLE friendslist (id INT AUTO_INCREMENT, requestorid INT not null,requestedid INT not null,requestedate TIMESTAMP not null, response varchar(10) null, PRIMARY KEY (`id`))

 

Should fix the problem. If you had this:

$query=mysql_query("CREATE TABLE friendslist (id INT AUTO_INCREMENT PRIMARY KEY, requestorid INT not null,requestedid INT not null,requestedate TIMESTAMP not null, response varchar(10) null") or die(mysql_error());

 

You may have been able to solve it on your own. Alternatively thoroughly learning SQL Create Table would have helped you tremendously. I would suggest reading up on that or even buying a "SQL For Dummies" book to learn at least the basics of SQL.

[vonnero]

thanks for all the responses... it gives me a blank page but I copied the SQL part of it to mysql command line monitor and it worked from there..........

 

 

CREATE TABLE friendslist (id INT AUTO_INCREMENT PRIMARY KEY, requestorid INT not null,requestedid INT not null,requestedate

 

TIMESTAMP not null, response varchar(10) null);.........

 

I am not sure why BUT thanks everyone...!!

[cooldude832]

obviously this wasn't "urgent" and the person lied so they shouldn't be helped

 

I also don't see why u are building tables in php instead of using phpmyadmin (unless u doing something stupid like dynamic table generation).