Jump to content

novumorganon

New Members
  • Posts

    3
  • Joined

  • Last visited

novumorganon's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I think it was legit, one part of my Ajax script having a space before session_start(); ... seemed to fix everything for the most part. Very odd. Haha. Thanks again everyone.
  2. So I think you are right with there being something wrong with sessions. I'm guessing PHP 7 had some updates to how sessions work too? Le sigh, this may not be as easy as I thought. Lol. Thank you for the fast help everyone! Appreciated.
  3. So I have a site for dealing with proprietary issues for my business. Coded it years ago as a website, due to folks working for me from home. Now my servers are forced into the new PHP update, 7.4 I think, and I'm getting this rather vague error: Fatal error: Error executing query: SELECT ca.customer_id, aa.needs_checking, c.agent_id FROM customer_accounts ca, allowed_accounts aa, customers c WHERE aa.allowed_acct_id = ca.account_type AND c.customer_id = ca.customer_id AND ca.is_active =1 AND ca.mail_interval !=0 AND ca.next_check < UNIX_TIMESTAMP() AND aa.needs_checking=1 AND c.word_balance > 150 AND c.agent_id= - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in /home/customer/www/i-scribes.com/public_html/mysqldb.class.php on line 270 For this line of code: $sql = "SELECT ca.customer_id, aa.needs_checking, c.agent_id FROM customer_accounts ca, allowed_accounts aa, customers c WHERE aa.allowed_acct_id = ca.account_type " . "AND c.customer_id = ca.customer_id AND ca.is_active =1 AND ca.mail_interval !=0 AND ca.next_check < UNIX_TIMESTAMP() AND aa.needs_checking=1 AND c.word_balance > 150 AND " . "c.agent_id={$_SESSION['staff_id']}"; $db->executeQuery($sql); If anyone can help, it would be most appreciated! <3
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.