Harley1979 Posted May 20, 2007 Share Posted May 20, 2007 I have this SQL statement; $confirmDetails = mysql_query("SELECT * FROM orders INNER JOIN reference ON orders.id = reference.box WHERE reference.refNum = $getRefNum"); ...which works, or did work fine. Today I have a strange problem... ... it will only fetch the 6 most recent entries from the database. Does anyone have any idea what this could be? I'm guessing its a wierd MySQL issue but I'm a bit in the dark on these sort of things as I am new to it all really. Any help would be great Regards Harley Quote Link to comment https://forums.phpfreaks.com/topic/52263-sql-inner-join-problem/ Share on other sites More sharing options...
radar Posted May 20, 2007 Share Posted May 20, 2007 With that code there is no issue that I can see.. There isn't a limit on it or anything and so without really inspecting the whole code it would be almost impossible to say what is wrong with it. Quote Link to comment https://forums.phpfreaks.com/topic/52263-sql-inner-join-problem/#findComment-257871 Share on other sites More sharing options...
Harley1979 Posted May 20, 2007 Author Share Posted May 20, 2007 I mean without sounding bold or anything, I think my code is pretty thorough and safe. Do you think that it is likely to be a coding issue or more likely a database one? It is a quandry! Quote Link to comment https://forums.phpfreaks.com/topic/52263-sql-inner-join-problem/#findComment-257873 Share on other sites More sharing options...
radar Posted May 20, 2007 Share Posted May 20, 2007 definately a coding issue -- in all my years of programming ive never had a database issue be the cause of something like this... this type of things is usually a problem with the coding. Even if it ends out to be something with the database, the code is the first place i would look to for an answer.... Quote Link to comment https://forums.phpfreaks.com/topic/52263-sql-inner-join-problem/#findComment-257874 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.