doesnt work with: id int NOT NULL AUTO_INCREMENT,

[clankill3r]

Hi,

 

If i use the following without:

  id int NOT NULL AUTO_INCREMENT,

then it works fine, but with the id line no table gets created.

 

how that?

 

 

	
$sql = "CREATE table IF NOT EXISTS $twitter_id
(
   	id int NOT NULL AUTO_INCREMENT, 		
   		kamerleden_id int,
	tweet_id int(20),
	tweet varchar(200),
	reply_to int,
	date datetime	
)";

[mikosiko]

what error message are you receiving ?  ...

 

if you don't see any error message enable error reporting/display adding this 2 lines after the <?php line

   error_reporting(E_ALL);
   ini_set("display_errors", "1");

[Pikachu2000]

I see you still think creating a new table for each user is a good idea. Well, good luck with all that.

[clankill3r]

even with those 2 lines i get no error message?

 

 

I will try Pikachu2000 way with 1 table for all users.

(won't it matter that it will hold like 100.000 messages?)