# Need a little mySQL help

**URL:** <https://forum.kirupa.com/t/need-a-little-mysql-help/187624>\
**Category:** Uncategorized\
**Created:** [May 1, 2006, 2:07am UTC](https://forum.kirupa.com/t/need-a-little-mysql-help/187624 "2006-05-01T02:07:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zicemaster](https://avatars.discourse-cdn.com/v4/letter/z/b77776/32.png) [@zicemaster](https://forum.kirupa.com/u/zicemaster)\
**Post date:** [May 1, 2006, 2:07am UTC](https://forum.kirupa.com/t/need-a-little-mysql-help/187624/1 "2006-05-01T02:07:27Z")

</div>

Okay… First I created the table… I checked it with phpMyAdmin. Heres my setup.php

```php

<?php
@mysql_connect('localhost', 'root', 'password');
@mysql_select_db('testdb') ;
$query="CREATE TABLE shoutBox (
id INT PRIMARY KEY auto_increment,
userName VARCHAR(20),
userShout TEXT (1000)
);";
mysql_query($query);
mysql_close();
?>

```

But now this part isn’t working out quite right… Any help? What am I doing wrong?

```php

@mysql_connect('localhost', 'root', 'password');
@mysql_select_db('testdb') or die( "Unable to select database");
$query="INSERT INTO shoutbox VALUES ('','Michael', 'I'm on top of the worldd!!')";
mysql_query($query);
printf ($query);
mysql_close();

```