Re: revised query problem (sorry)
| From: | Curt Zirzow | Date: | Tue, 28 Oct 2003 20:26:03 +0000 |
| Subject: | Re: revised query problem (sorry) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-167931@lists.php.net to get a copy of this message | ||
* Thus wrote Pablo Gosse (gossep@unbc.ca):
> Yours:
>
> $query="SELECT payment
> FROM payment
> WHERE payment.dln='".$_POST["dln"]."'
> = users.dln='".$_POST["dln"]."'
> and payment.payment='".$_POST["payment"]."'";
>
> Mine:
>
> $query="SELECT payment
> FROM payment
> WHERE payment.dln='".$_POST["dln"]."'
> AND
> users.dln='".$_POST["dln"]."'
> and payment.payment='".$_POST["payment"]."'";
>
> See the difference?
heh.. still wont work :/ the table users still isn't in the FROM
list like what was suggested in the last post:
$query="SELECT payment
FROM payment, users
WHERE payment.dln=users.dln
AND users.dln='".untainted($_POST["dln"])."'
and payment.payment='".untainted($_POST["payment"])."'";
Curt
--
"My PHP key is worn out"
PHP List stats since 1997:
http://zirzow.dyndns.org/html/mlists/