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` = "")"; 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. 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!! 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
Archived
This topic is now archived and is closed to further replies.