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());

[benjaminbeazy]

$mysql_query($del, $link_id)or die(mysql_error()); should be

mysql_query($del, $link_id)or die(mysql_error());

[182x]

Still getting the same syntax error seems to be with this part of the code

 

WHERE techId= $temp['Id']";

 

any ideas?

[vbnullchar]

try this

 

<?php
$del="DELETE FROM tech WHERE techId= '$temp[id]'";
?>

[benjaminbeazy]

Still getting the same syntax error seems to be with this part of the code

 

WHERE techId= $temp['Id']";

 

any ideas?

 

try WHERE techId = {$temp['Id']}";

 

if $query is returning more than 1 result you need to add a limit or use a loop...

[182x]

with both I recieve the following error, anymore syntax suggestions?

 

 

Parse error: syntax error, unexpected T_VARIABLE

[TheFilmGod]

WHERE techId= "$temp['Id']";

 

??? What about that?