Is this querry OK...

registered · Worker Joined: Jul 07, 2004 Posts: 192

It's a querry from a OSC Shop port for PHP-Nuke... I don't know what's wrong with this querry but it generates an error... About something beeing wrong next to "

Code:




$customers_query_raw = "select p.customers_id, p.allow_vendors_id, c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from privacy p left join " . TABLE_CUSTOMERS . " c on p.customers_id = c.customers_id left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname";

Maybe someone will be able to help... I don't know what maybe wrong...

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Add this line right after it, run it, report back what it says, then remove the line.

die('query = '.$customers_query_raw);

Also, report back the exact/entire error message that you receive.

Posted: Tue Dec 28, 2004 11:54 am

It doesn't look like privacy is defined in the same way " . TABLE_CUSTOMERS . " and " . TABLE_ADDRESS_BOOK . " are .

Posted: Tue Dec 28, 2004 11:58 am

This is what I get after adding: die('query = '.$customers_query_raw);

Code:




query = select p.customers_id, p.allow_vendors_id, c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from privacy p left join customers c on p.customers_id = c.customers_id left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where p.allow_vendors_id = order by c.customers_lastname, c.customers_firstname

And this is the entire error message...

Code:




Something is wrong in your syntax next to '' in line 1





select count(*) as total from privacy p left join customers c on p.customers_id = c.customers_id left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where p.allow_vendors_id =

When I changed the above code to this:

Code:




$customers_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from " . TABLE_CUSTOMERS . " order by customers_lastname, customers_firstname";

I don't get any errors... but the data is incomplete...

Posted: Tue Dec 28, 2004 12:01 pm

sixonetonoffun wrote:

It doesn't look like privacy is defined in the same way " . TABLE_CUSTOMERS . " and " . TABLE_ADDRESS_BOOK . " are .

Yes but the table name is privacy... and I tried to change the " . TABLE_CUSTOMERS . " and " . TABLE_ADDRESS_BOOK . " to the exact table names... and the error still occured...

Posted: Tue Dec 28, 2004 1:23 pm

This line

Code:

c.customers_default_address_id = a.address_book_id where p.allow_vendors_id = order by c.customers_lastname, c.customers_firstname

has p.allow_vendors_id = order by .... What ever you're expecting p.allow_vendors_id to be, it isn't. That's probably the problem.