Query structure, why would this not work?

[michaelkirby]

Hi all,

 

I have an upload on and at present it uploads fine to the correct destination. As I'm uploading images I want to be able to store the image in a specific table which is users.

 

$query = "insert into users values where userid= $userid (0,'".$filename."')";

 

So I run the above query but I errors saying:

 

Unable to perform query insert into users value where userid= 1 (0,'Lighthouse.jpg')

 

I'm storing the user id from the session variable into $user id as below and also putting the filename into the $filename variable.

 

$userid = $_SESSION['userid'];

$filename = $_FILES["file"]["name"];

 

Not sure if I'm doing anything wrong any one able to help?

[Gamic]

where is a condition. You don't require a condition on an insert, (unless, perhaps, you are inserting from a select query).

 

something likes this should be more than good enough:

 

<?php
$query = "insert into users(<fieldlist>)
  values (0, '".$filename."')";
?>

 

You may also need to think about what you are trying to do. Are you trying to create a new users, or are you trying to update an old user with a new profile picture (or something completely different yet again).

[roopurt18]

You should read the MS SQL manual on the most basic and common database operations, which are:

SELECT

INSERT

UPDATE

DELETE

 

There are examples of how to correctly perform each.