|
|
Posted by Jerry Stuckle on 08/07/06 02:10
mantrid wrote:
> Hello
> Im having problems working out why the following code does not work. I dont
> think its the sql as the error occurs on the first update which ever one is
> put there ($q1 or $q2). Ive swapped then around to test this.
> Help greatly appreciated
>
> The error is Unknown column 'A' in 'field list'
> but there is no field 'A'. im thinking that the 'A' may be first letter of
> the word Array, as if it is using this as a variable, but i dont know how.
>
>
> $commindexarray=$_POST['commindex'];
> $catarray=addslashes($_POST['category']);
> $commarray=addslashes($_POST['comm']);
> $availarray=$_POST['avail'];
> $delarray=$_POST['del'];
>
> if($delarray==''){
> for ($i = 0; $i < count($commindexarray); $i++){
> $currtime=date('YmdHis');
> $q2 ="UPDATE usercomms SET typeid={$catarray[$i]} WHERE userid=
> ".$_SESSION['userid']." AND commindex ={$commindexarray[$i]}";//
> $updateusercomm = mysql_query($q2) or die('<br><span
> class=RedWarning>Sorry, there was a problem updating. Try
> again.<br><br>Error - 1 '.count($delarray). mysql_error().'</span>');
> $q="UPDATE comments SET typeid={$catarray[$i]}, comment='{$commarray[$i]}',
> available={$availarray[$i]}, timestp='$currtime', globalavail=0 WHERE
> commindex={$commindexarray[$i]}";//
> $updatecomm = mysql_query($q) or die('<br><span class=RedWarning>Sorry,
> there was a problem updating some records. Try again.<br><br>Error - 2
> '.count($delarray).mysql_error().'</span>');
>
> }
> }
>
>
Non-numeric constants MUST be enclosed in single quotes in your SQL
statements. Otherwise they may be taken as a column name.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|