Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Can you please adjust this SQL statement so it will work? I have 3 tables joined and I modified the filter ie WHERE and I broke it.

Can you please adjust this SQL statement so it will work? I have 3 tables joined and I modified the filter ie WHERE and I broke it.

Thread begun 6/21/2022 9:39 am by jo271221 | Last modified 6/22/2022 1:23 pm by Ray Borduin | 293 views | 3 replies |

6/21/2022 9:39 am | #1 jo271221

Can you please adjust this SQL statement so it will work? I have 3 tables joined and I modified the filter ie WHERE and I broke it.

Statement in PM

6/21/2022 9:46 am | #2 Ray BorduinWebAssist

You have this in your qeury:
" . $where . "

but $where is never defined. I think you need to remove that part.

Did this help? Tips are appreciated...

6/21/2022 1:40 pm | #3 jo271221

Thank you.

I tried that and my page still will not load. I pasted the revised query in the PM and also FTp info.

6/22/2022 1:23 pm | #4 Ray BorduinWebAssist

I think your recordset is returning too many results... instead of:

FROM tbl_posts p, horses h, tbl_directorylistings d

IT should probably be something like:

FROM tbl_posts p INNER JOIN horses h ON h.horseID= p.horseID INNER JOIN tbl_directorylistings d ON d.horseID = p.horseID

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.