Jump to content



Photo

PHP query help


  • Please log in to reply
2 replies to this topic

#1 marklcfc

marklcfc

    Neowinian

  • Joined: 30-March 05

Posted 01 February 2013 - 17:53

Any idea why the following code displays this error? I am quite new to php and I'm struggling to see the error.

$stmt = $db->query('SELECT ti.playerid, ti.buydate, pl.playerid, pl.firstname, pl.lastname, pl.photo FROM transfersin as ti, players as pl WHERE ti.playerid = pl.playerid AND DATE_FORMAT(`ti.buydate`,\'%d.%m\') = DATE_FORMAT(NOW(),\'%d.%m\') ORDER BY ti.buydate ASC ');

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ti.buydate' in 'where clause'' in /home/*/public_html/stats/onthisday.php:182 Stack trace: #0


Basically what I'm trying to do is show the results that happened on todays date, over the past 100 years. This actually worked until I moved some info into a new 'transfersin' column, then tried to alter the query but can't get it working.


#2 palenous

palenous

    Neowinian

  • Joined: 19-January 13
  • Location: Ohio, United States
  • OS: Windows 7 Ultimate
  • Phone: Samsung Galaxy SIII (Verizon)

Posted 01 February 2013 - 22:35

Are you sure you have the column name exactly the same in the table?

You could also try removing the ticks around ti.buydate in the WHERE clause.

It's kind of hard to tell without the db schema.

#3 n_K

n_K

    Neowinian Senior

  • Tech Issues Solved: 3
  • Joined: 19-March 06
  • Location: here.
  • OS: FreeDOS
  • Phone: Nokia 3315

Posted 01 February 2013 - 22:35

Basically it's not a PHP error, it's a MySQL (or other database system) error, you've removed or moved ti.buydate from the table you're trying to reference.
FROM transfersin as ti, players as pl
So you need to add and update that to include where buydate is or move it back to the transfersin table.



Click here to login or here to register to remove this ad, it's free!