On Tuesday, October 28, 2003 8:50 AM Frank Tudor wrote: > $query="SELECT payment FROM payment WHERE dln='".$_POST["dln"]."' = payment.dln='".$_POST["dln"]."' and users.password='".$_POST["password"]."'";
Okay, there seem to be a few problems here. The first issue is: "users.password" Using this means you are referencing a table which you've identified as "users", however there is no such table in your query. If the password field is part of the payment table, then you would reference it as payment.password. However if the password field is part of a users table, then you need to perform a join here, as you will be attempting to get the data from two tables. The second issue is here: "WHERE dln='".$_POST["dln"]."' = payment.dln='".$_POST["dln"] You're first comparind dln to $_POST['dln'], and then to payment.dln and then to $_POST['dln'] again. What fields is it you're trying to compare? Each where clause in sql must be joined with an and, or, like, etc. So perhaps you were trying for something like this: "WHERE dln = '".$_POST["dln"]."' and payment.dln = '".$_POST["dln"] However, if this were the case you're essentially asking the same thing twice. So, based on your query, I suspect you're trying for something like this: $query = 'select payment from payment where dln = \''.$_POST['dln'].'\' and password = \''.$_POST['password'].'\''; However, this again assumes that the password and dln fields are in the same table. If they're in separate tables then you'll need to perform a join. Hope this helps. Cheers, Pablo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
