Blank rows in MYSQL

[Anon]

I am new to PHP and MYSQL so please forgive my ignorance. Can someone tell me why I get a blank row inserted into the database when I insert new values using a form?

My form code is:

<form action="add-data.php" method="post">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td width="42%">
<div align="right">Category:</div>
</td>
<td width="58%">
<input type="text" name="category">
</td>
</tr>
<tr>
<td width="42%">
<div align="right">Name:</div>
</td>
<td width="58%">
<input type="text" name="name">
</td>
</tr>
<tr>
<td width="42%">
<div align="right">Html:</div>
</td>
<td width="58%">
<textarea cols="60" rows="5" name="html" wrap="PHYSICAL"></textarea>
</td>
</tr>
<tr>
<td width="42%">
<div align="right">More info:</div>
</td>
<td width="58%">
<textarea cols="60" rows="5" name="moreinfo" wrap="PHYSICAL"></textarea>
</td>
</tr>
<tr>
<td width="42%">&nbsp;</td>
<td width="58%">
<div align="right">
<input type="Submit" name="Update Database" value="Add new data">
</div>
</td>
</tr>
</table></form>

and my add-data.php code is:

<?
$username="username";
$password="password";
$database="database";

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

$query = "INSERT INTO audio VALUES ('$category','$name','$html','$moreinfo')";
mysql_query($query);

echo "Data added successfully";

mysql_close();
?>

Thanks

Steve.

[sclough]

Form variables are stored in an array named either $HTTP_POST_VARS or $HTTP_GET_VARS. For example, to retrieve $name, you would do:
$name = $HTTP_POST_VARS["name"];
or
$name = $HTTP_POST_VARS['name'];

[Anon]

Small addition to that:

Your original code will probably work fine at most hosting companies. Many of them are on an earlier version of PHP which will still the old style global variable refernecing - sorry, can't remember the exact version that this change came in.

Cheers
Justin

[Anon]

Found some code on this site which has done the trick.

Thanks anyway.

<?php

if ($submit) {
$db = mysql_pconnect("localhost", "username", "password");

mysql_select_db("database");

$sql = "INSERT INTO audio VALUES('$category','$name','$html','$moreinfo')";

$result = mysql_db_query('vs40jh8xstg7', $sql);
mysql_close();
echo "<br><br><br>New data added successfully!<br><br><br><a href=\"index.php\">Go back</a><br><br>\n";
}
else {

echo "<form action=\"$PHP_SELF\" method\"POST\">\n";

?>

<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td width="42%">
<div align="right">Category:</div>
</td>
<td width="58%">
<input type="text" name="category">
</td>
</tr>
<tr>
<td width="42%">
<div align="right">Name:</div>
</td>
<td width="58%">
<input type="text" name="name">
</td>
</tr>
<tr>
<td width="42%">
<div align="right">Html:</div>
</td>
<td width="58%">
<textarea cols="60" rows="5" name="html" wrap="PHYSICAL"></textarea>
</td>
</tr>
<tr>
<td width="42%">
<div align="right">More info:</div>
</td>
<td width="58%">
<textarea cols="60" rows="5" name="moreinfo" wrap="PHYSICAL"></textarea>
</td>
</tr>
<tr>
<td width="42%">&nbsp;</td>
<td width="58%">
<div align="right">
<input type="Submit" name="submit" value="Add new data">
</div>
</td>
</tr>
</table></form>

<?php
}
?>