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 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. 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! 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.... Link to comment https://forums.phpfreaks.com/topic/52263-sql-inner-join-problem/#findComment-257874 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.