Shamrox Posted December 18, 2007 Share Posted December 18, 2007 Is there anything wrong with the way this is written? I can't get any output to the page. "SELECT `spec_registrar`.`registrarid`, `spec_client`.`name`, `spec_contacts`.`lastname`, `spec_registrar`.`startdate`, `spec_registrar`.`orderdate`, `spec_registrar`.`vendorlistprice`, `spec_registrar`.`discount`, `spec_registrar`.`sale_price`, `spec_registrar`.`stb_discount`, `spec_registrar`.`cogs`, `spec_registrar`.`status` FROM `spec_registrar` INNER JOIN `spec_students` ON `spec_registrar`.`studentid` = `spec_students`.`studentid` INNER JOIN `spec_client` ON `spec_registrar`.`clientid` = `spec_client`.`clientid` INNER JOIN `spec_contacts` ON `spec_students`.`contactid` = `spec_contacts`.`contactid` WHERE (`spec_registrar`.`stb_discount` = "0%" OR `spec_registrar`.`stb_discount` = "")"; Quote Link to comment https://forums.phpfreaks.com/topic/82234-solved-is-my-query-correct/ Share on other sites More sharing options...
fenway Posted December 18, 2007 Share Posted December 18, 2007 Yes, you have double-quotes nested inside double-quotes... and waaaay too many backticks. Quote Link to comment https://forums.phpfreaks.com/topic/82234-solved-is-my-query-correct/#findComment-417928 Share on other sites More sharing options...
Shamrox Posted December 18, 2007 Author Share Posted December 18, 2007 Fenway, as always, you are the man!! Quote Link to comment https://forums.phpfreaks.com/topic/82234-solved-is-my-query-correct/#findComment-417934 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.