[RESOLVED] syntax error

182x

hey guys,

just wondering where I went wrong with this syntax?

Thanks

$get= "SELECT * FROM use WHERE Id = $Id AND acc= $acc";
$query= mysql_query($get, $link_id) or die(mysql_error());


$temp=mysql_fetch_array($query)
$del="DELETE FROM tech WHERE techId= $temp['Id']";
$mysql_query($del, $link_id)or die(mysql_error());

NogDog

What error message to you get?

182x

Parse error: syntax error, unexpected T_VARIABLE

NogDog

The parser cannot deal with array elements with quoted indexes within a double-quoted string. You can use "complex variable notation" to fix it:

$del="DELETE FROM tech WHERE techId= {$temp['Id']}";

NogDog

However, upon further review, you probably didn't even get to that line yet, since you left out the terminating semi-colon on the preceding line.

182x

Thanks, I keep getting the following error now, any suggestions as Im sure the query is correct (works when directly input in mysql).

Unknown column 'temp' in 'where clause'

NogDog

Did you copy my code before I corrected the missing "$" in it?

182x

Yeah the "$" is included in the code.

NogDog

Try using this pattern to see what exactly what the query looks like:

$query = "blah blah blah";
$result = mysql_query($query) or die("Query failed ($query): " . mysql_error());

Also, we'll probably need to see the revised code along with the error details.

182x

The new error is:

Query failed (Resource id #6): Unknown column 'temp' in 'where clause'

My code is the same as before with your syntax added.

NogDog

In this expression...

die("Query failed ($query): " . mysql_error());

...make sure that $query is replaced with whatever variable holds the SQL query string, not the one that holds the result of the mysql_query() command. (The purpose is to be able to see the query exactly as it was sent to MySQL.)

182x

I think it may be a bad query, I will try another approach this is the basic idea.

I have a page which displays a tables of users from a database and I on this page the user can select someone to remove from the database in order to do this they select the username from a listbox which only contains the userIds.

When this userId is sent for processing I would also like to be able to send the related username without the user having to select it.

How can I do this? Thanks

EDIT: That may not have been clear I mean how do I send the extra piece of information, I have already got the rest setup.