PHP/MySQL

[Kipkip]

Ok, I'm making a tagboard for my first PHP/MySQL script and I think I have something wrong with the input query since nothing shows up in the table. Can anyone help? Here's the code:

<?php
include("dbinfo.php");

$name=$_POST['name'];
$website=$_POST['website']; 
$email=$_POST['email'];
$message=$_POST['message'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO tagboard VALUES ('','$name,'$website','$email','$message')"; 
mysql_query($query);

mysql_close(); 

?>

I don't see any error in it or my dbinfo page. Can someone please help? And if you know how to use a file for the database instead of a MySQL database, can you please help me on that too? Thanks.
Also, if you need it, here's what's in the table:
Name Type Length Extra
id INT 6 PRIMARY auto_increment
website VARCHAR 15
email VARCHAR 15
message VARCHAR 50

 

[aRedMoon]

Err... I don't know all that much about php/mySQL yet... but...

$name=$_POST['name'];
$website=$_POST['website'];
$email=$_POST['email'];
$message=$_POST['message'];

Should be...

$name = $_POST['name'];
$website = $_POST['website'];
$email = $_POST['email'];
$message = $_POST['message'];

Right? O-o

 

[PokeVillage]

well this HelloPichu i know alot about PHP

 

[aRedMoon]

well this HelloPichu i know alot about PHP

Please... only post if you can help him...

 

[Master Kwesi Nkromah]

I don't really think the way you're going about it is correct. Then again there are probably more than one way to retrieve data from your database. this is how I do it.

first connect

//Connecting to the database
  	ConnectToDatabase($user, $pass, $db);

then the query

$result = GetPokemonInfo(8);
  	while($a_row = mysql_fetch_object($result))
  {

now i left the curly bracket open because what you'll have within it is the array. it'll end up being somthing like this

print "$a_row->EnglishName"

if the feild you're trying to access is called "EnglishName".
then you just close the while function, database and connection

I took this code from one of my projects, so it'll look alil diffrent than yours. for example, in your script $result may equal:

			$result = mysql_query("SELECT * FROM tblPokemonJokes WHERE tblPokemonJoke.ID = "Pikachu");

 

[Kipkip]

I don't really think the way you're going about it is correct. Then again there are probably more than one way to retrieve data from your database. this is how I do it.

first connect

//Connecting to the database
  	ConnectToDatabase($user, $pass, $db);

then the query

$result = GetPokemonInfo(8);
  	while($a_row = mysql_fetch_object($result))
  {

now i left the curly bracket open because what you'll have within it is the array. it'll end up being somthing like this

print "$a_row->EnglishName"

if the feild you're trying to access is called "EnglishName".
then you just close the while function, database and connection

I took this code from one of my projects, so it'll look alil diffrent than yours. for example, in your script $result may equal:

			$result = mysql_query("SELECT * FROM tblPokemonJokes WHERE tblPokemonJoke.ID = "Pikachu");

Yeah, that's retriving. The problem is inserting the infomation I guess because phpMYAdmin is telling me that there's nothing in the table. But I like your way, it's better than the one in the tutorial I followed.

 

[Master Kwesi Nkromah]

Uhh, yeah.. you would have to insert data into the table before you could retrieve it.. hehe. if you'd like I can post a full tutorial of how i accessed and retrived data from a database.