> -Original Message-
> From: Matthew Moldvan [mailto:[EMAIL PROTECTED]
> Sent: 10 June 2003 16:50
>
> As for the line breaks, I've used SQL formatted that way before and it
> hasn't cause me any problems.
It's a matter of preference, but I prefer to keep my query strings as lean as possib
uesday, June 10, 2003 11:50 AM
To: 'Hutchins, Richard'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Is this query even possible?
Keep in mind the code I sent is untested ... and I realized some errors
when I pasted it into a PHP page. Corrections are below.
As for the line b
> -Original Message-
> From: Susan Ator [mailto:[EMAIL PROTECTED]
> Sent: 10 June 2003 16:18
>
> > This is what I am trying to do:
> >
> > if ($FUNC==("USERPOST") || $FUNC==("MODU")) {
> > $sql = "UPDATE newdacs
> > SET emailfwd='$emailfwd',
> >
sday, June 10, 2003 11:42 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Is this query even possible?
Yup, Matthew's right. I definitely forgot the other $sql. = that needs to go
in front of the WHERE clause.
Question for Matthew though:
Is this:
> $sql .= "U
code'";
> if($FUNC=='USERPOST')
> $sql .= ", unote='$unote'";
> $sql .= "WHERE user_id='$user_id'";
>
> $result = mysql_query($sql) or die('mysql error
> #'.mysql_errno.'
l_errno.':
'mysql_error());
}
Try that ... also look into www.php.net under string manipulation for other
options.
Regards,
Matthew Moldvan
System Administrator
Trilogy International, Inc.
-----Original Message-
From: Susan Ator [mailto:[EMAIL PROTECTED]
Sent: Tuesday, Ju
If I'm reading things properly, it looks like the parser doesn't know that
you want to append another condition to the query.
Hope this helps.
Rich
> -Original Message-
> From: Susan Ator [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 11:18 AM
> To: '[EM
> This is what I am trying to do:
>
> if ($FUNC==("USERPOST") || $FUNC==("MODU")) {
> $sql = "UPDATE newdacs
> SET emailfwd='$emailfwd',
> mformat='$mformat',
> filter_code='$filter_code'
>