larry_boy_44 Posted April 28, 2007 Share Posted April 28, 2007 Hey, I have a page I'm making with PHP and this is my query: "Select Author.`FirstName`, Author.`LastName`, Article.`Date`, Article.`Title`, Article.`Description` From Author Author, Author_Article_Intersect Author_Article_Intersect, Article Article Where ( Article.ArticleID = Author_Article_Intersect.ArticleID And Author_Article_Intersect.AuthorID = Author.AuthorID )" and I have a major problem... I am only getting the first row of results... So I get row 1... If I use a specific AuthorID number (my ultimate goal) I can get 1 different row other than row 1, but still cant' get more than 1 row in the results... Do you guys have any ideas why? Quote Link to comment Share on other sites More sharing options...
larry_boy_44 Posted April 28, 2007 Author Share Posted April 28, 2007 ok... I'm still working on it... and the problem is that my array won't take in more than 1 Row's data in the database... its like PHP is stopping my query after the first correct hit on it... Quote Link to comment Share on other sites More sharing options...
Liquid Fire Posted April 28, 2007 Share Posted April 28, 2007 what is you php code? also this From Author Author, Author_Article_Intersect Author_Article_Intersect, Article Article is not need as it means the same thing as: From Author, Author_Article_Intersect, Article Quote Link to comment Share on other sites More sharing options...
AndyB Posted April 29, 2007 Share Posted April 29, 2007 How do you know you only get one result? Show us some code, including what you're using to either count rows returned or display rows. Quote Link to comment Share on other sites More sharing options...
tauchai83 Posted April 29, 2007 Share Posted April 29, 2007 show us the code, else how ppl going to help you? try use WHILE/FOR loop first to get ALL the data that match your query. Quote Link to comment 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.