INSERT Fails

Anon

Hello,

The following code is failing on the INSERT for some reason, and I can't figure out why...especially since I've gotten this code to work before (on a different server). This server is a Win2000 machine running Apache, PHP4, and W32 mySQL. Any help would be greatly appreciated. Thanks!

<?php
if ($submit) {
$db = mysql_connect("localhost", "root", "root") or die ("Could not connect");
print ("Connected OK");
mysql_select_db("slt") or die ("Could not select database");
print ("Database selected OK");
$sql = "INSERT INTO drivers (ID,Host,OS,Adapter,BIOS,Driver,Date) VALUES ('$id',´$host´,´$os´,´$adapter´,´$bios´,´$driver´,´$date´)";
$result = mysql_query ($sql) or die ("Insert Failed");
print ("Insert OK");
} else {
?>

<HEAD>
<TITLE>SLT Driver Maintenance Database</TITLE>
</HEAD>

<TABLE BORDER=0 CELLPADDING=1 CELLSPACING=5 WIDTH=610>
<TR>
<TD ColSpan=2 RowSpan=1 Align=Center>
<TABLE BORDER=0 CELLSPACING=2 CELLPADDING=2>
<FORM METHOD="post" ACTION="<?php echo $PHP_SELF?>">
<TR>
<TD ColSpan=1 RowSpan=1 Align=Left>
<INPUT TYPE="hidden" NAME="id" Value="1">
</TD>
</TR>
<TR>
<TD ColSpan=1 RowSpan=1 Align=Left>
Host Name:
</TD>
<TD ColSpan=1 RowSpan=1 Align=Left>
<INPUT TYPE="text" NAME="host" SIZE=30>
</TD>
</TR>
<TR>
<TD ColSpan=1 RowSpan=1 Align=Left>
OS Version:
</TD>
<TD ColSpan=1 RowSpan=1 Align=Left>
<INPUT TYPE="text" NAME="os" SIZE=30>
</TD>
</TR>
<TR>
<TD ColSpan=1 RowSpan=1 Align=Left>
Adapter:
</TD>
<TD ColSpan=1 RowSpan=1 Align=Left>
<INPUT TYPE="text" NAME="adapter" SIZE=30>
</TD>
</TR>
<TR>
<TD ColSpan=1 RowSpan=1 Align=Left>
Bios Level :
</TD>
<TD ColSpan=1 RowSpan=1 Align=Left>
<INPUT TYPE="text" NAME="bios" SIZE=10>
</TD>
</TR>
<TR>
<TD ColSpan=1 RowSpan=1 Align=Left>
Driver Level:
</TD>
<TD ColSpan=1 RowSpan=1 Align=Left>
<INPUT TYPE="text" NAME="driver" SIZE=10>
</TD>
</TR>
<TR>
<TD ColSpan=1 RowSpan=1 Align=Left>
Date:
</TD>
<TD ColSpan=1 RowSpan=1 Align=Left>
<INPUT TYPE="text" NAME="date" SIZE=40>
</TD>
</TR>
<TR>
<TD ColSpan=2 RowSpan=1 Align=Center>
<INPUT TYPE="submit" NAME="submit" VALUE="Submit"> <INPUT TYPE="reset" VALUE="Reset">
</TD>
</TR>
</FORM>
</TABLE>
</TD>
</TR>
</TABLE>
<?php
} // end if
?>
</CENTER>
</BODY>

Anon

have you tried printing mysql_error() ? it might provide some insight as to why this is failing.. if you have already, what does it say?

[deleted]

Use error-reporting:

$query = "SELECT * FROM bla";

if (!mysql_query($query, $database_connection))
{
echo mysql_error();
echo $query;
};

Anon

Here's the error message I get when using mysql_error() :

You have an error in your SQL syntax near '´,´,´,´,´,´)' at line 1

My SQL query looks good to me...any ideas?

<?php
if ($submit) {
$db = mysql_connect("localhost", "root", "root") or die ("Could not connect");
print ("Connected OK");
mysql_select_db("slt",$db) or die ("Could not select database");
print ("Database selected OK");
$sql = "INSERT INTO drivers (ID,Host,OS,Adapter,BIOS,Driver,Date) VALUES ('$id',´$host´,´$os´,´$adapter´,´$bios´,´$driver´,´$date´)";
$result = mysql_query ($sql);
echo mysql_error();
print ("Insert OK");
} else {
?>

Thanks,

Mark

Anon

The problem was with the single quotes in the query...' vs. `. It works now that I've change them all to '.

Thanks!

Mark