Re: Problem retrieving results from database
- From: Jan Pieter Kunst <devnull@xxxxxxxxx>
- Date: Sat, 02 Apr 2005 19:29:39 +0200
evetommy wrote:
Hi all,
I'm trying to retrieve fields from my database with following mysql statement:
$query = SELECT g_games.Title FROM g_collections, g_personal_reviews, g_games WHERE (g_games.ID=g_personal_reviews.G_ID AND g_collections.U_ID = '" . $data1['ID'] . "' AND g_personal_reviews.C_ID = '" . $data2['ID'] . "' ) "; $resultset = mysql_query($query); $data = mysql_fetch_array($resultset);
3 Rows in my database comply with the above statement... though I only get 1 to show up on my php page? How can I show all of them?
This is the php code I'm using to write the results:
while ($data= mysql_fetch_array($resultset)) { echo $data[Title]." "; }
My tables are as followed: g_games g_collections g_personal_reviews > this table connects all others with G_ID ("game ID"), C_ID ("Collection_ID"), U_ID ("User ID)... users
Two things: don't do this
$data = mysql_fetch_array($resultset);
and this
while ($data= mysql_fetch_array($resultset)) {
echo $data[Title]." ";
}both. If you execute both of these statements, the first row never gets echo'd. But this would give you two rows in the while loop if the total is three. So you should also check if the query actually returns the three rows, by doing something like this:
echo $query;die;
.... and then copying and pasting the query into the mysql commandline client and checking what the actual result is.
JP
-- Sorry, <devnull@xxxxxxxxx> is a spam trap. Real e-mail address unavailable. 5000+ spams per month. .
- References:
- Problem retrieving results from database
- From: evetommy
- Problem retrieving results from database
- Prev by Date: Re: Weird incrementing problem
- Next by Date: finding the full path of an image ?
- Previous by thread: Problem retrieving results from database
- Next by thread: finding the full path of an image ?
- Index(es):
Relevant Pages
|
