Query Help

[Ahren]

Hey havnt posted here in a while I quit php for a while and now i can't seem to get my groove back.

I have this insert query:

$sql = "INSERT INTO file (id, name, desc, views, pname) VALUES(' ','$filename','temp','0','$logged')";
mysql_query($sql) or die(mysql_error()); 

I can't figure out why it won't work 🙁

The error I am getting is:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, views, pname) VALUES(' ','df','temp','0','Ahren')' at line

[volant]

hey is ur id auto increment? could that be a null? suggest u put a 0 of that or dun insert for that field. but i never try it out, so dunno if it can solve the prob

[theeper]

'desc' is a reserved word within MySQL and should not be used as a column name.

[Nibinaear]

This is my tester script for php and mysql:

<?
include 'odbc_connection.php';

$query = odbc_exec($odbc, "SELECT * FROM assessments");

while($record = odbc_fetch_array($query))
{
  echo $record['the name of your table column'];
}
?>

odbc_connection script that is referenced in the above code:

<?

$odbc = odbc_connect('practiceDSN', 'root', 'pass') or die( "Could Not Connect to ODBC Database!");

if (function_exists(odbc_fetch_array))
return;

function odbc_fetch_array($result, $rownumber=-1) 
{
	if (PHP_VERSION > "4.1") {
		if ($rownumber < 0) {
			odbc_fetch_into($result, $rs);
		} else {
			odbc_fetch_into($result, $rs, $rownumber);
		}
	} else {
		odbc_fetch_into($result, $rownumber, $rs);
	}

$rs_assoc = Array();

foreach ($rs as $key => $value) {
	$rs_assoc[odbc_field_name($result, $key+1)] = $value;
}
return $rs_assoc;
}
?>

You don't need to learn how to do the odbc connection, as long as you just call it from the other script. To do an update, delete, or insert you would simply change the SELECT keyword bit with your own SQL.

Nib