MySQL Forums
Forum List  »  PHP

Able to select multiple tables with manually generated (primary) keys, but not auto-numbered ones
Posted by: Kurt Wayne
Date: March 03, 2012 11:51AM

Hello, all:

Long story short...the query below works if the tables in my database were manually numbered (I'm pulling data from two tables done this way in another file) but blows up if I use more than one auto-numbered-key table. That's the only difference I can see so far in the tables. All I get with this is a blank page, whereas I'd get results if I dropped ", state_capital" and just went with the "newspapers" query. This is the last piece (for now) of the puzzle I've been working on the past few weeks. Thanks:

$query = "SELECT * FROM newspapers, state_capital WHERE state='Arkansas' ORDER BY city LIMIT $offset, $rowsPerPage";

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.