Problem getting Info from Table(maybe this is easy?)

aktiwers

Hi,

I am having a little problem with getting the info shown from a table I have created called purchaseinfo. When I type in the info, it gets all stored there, but when I want it to get show in my viewpurchaseinfo.php nothing shows up? Can anybody tell me what I am doing wrong?

//taking Purchase Info............................................
$query = "SELECT purchaseinfo.*,members.Name FROM purchaseinfo,members
WHERE purchaseinfo.refer_id = members.ID";
$result = mysql_query($query) or die(mysql_error());
if(mysql_num_rows($result))
{
?>
<tr>

                              <td width="28%" height="20" class="chart"><strong>&nbsp;Name</strong></td>

                              <td width="17%" height="20" class="chart"><strong>Email&nbsp;&nbsp;</strong></td>

                              <td width="17%" height="20" class="chart"><strong>Sitename
                                &nbsp;&nbsp;&nbsp;&nbsp;</strong></td>

                              <td width="18%" height="20" class="chart"><strong>Referer&nbsp;&nbsp;</strong></td>
								</tr>
								<?
									while($row=mysql_fetch_object($result)){
										$buyername	= $row->fullname;
										$buyeremail	= "<a href=mailto:$row->email class=nav_links>$row->email</a>";
										$buyersite	= "<a href=$sitename class=nav_links>$row->sitename</a>";
										$refername	= "<a href='viewmember.php?id=$row->refer_id' class=nav_links>$row->Name</a>";
										?>
										<tr>

                              <td height="20"  class="chart"><? echo $buyername;?></td>

                              <td height="20"  class="chart"><? echo $buyeremail;?></td>

                              <td height="20"  class="chart"><? echo $buyersite;?></td>

                              <td height="20"  class="chart"><? echo $refername;?></td>
										</tr>
										<?
								}
							 }
							//-------------------------------------------------------------------------[/QUOTE]

Sorry if this is a newbe question, but I am pretty new to all this PHP 🙂

bretticus

So are you basically inserting information for a purchase and then trying to show it on another page?

Your query seems to be one that would return multiple records and not just one. Currently your code would just show the first one in the table without iterating through the others that could come through.

Of course I am assuming here. If my assumption is correct, you should use an auto-incrementing id column in your data table and then use something like:

$newid = mysql_insert_id();

To get the value for the id of the record you just inserted. This will enable you to query the record you just inserted (obviously.)

Roger_Ramjet

Have you tried running the query in phpmyadmin, or cpanel, etc?

Without knowing the tables and thier data, we are making assumptions. Assuming that all else is correct then the only SQL reason for that query to fail is because there are no member ids that match the referer ids. Try changing it to an explicit LEFT JOIN, then you will at least get the purchase info. If the member name is NULL then, yes, member id and referer id do not match.

 $query = "SELECT purchaseinfo.*,members.Name FROM purchaseinfo LEFT JOIN members ON purchaseinfo.refer_id = members.ID";

aktiwers

Okay I will try both. And thanks alot for your reply.

The site should work like this; A lot of members are resellers of the product, and when the sale is completed it should be stored in The table 'purchaseinfo'. Then I would like to be able to see this info from my admin area (in the viewpurchaseinfo.php).

But Im afriad I will mess up some of the preemade parts of the script with changes in the code I posted above. But I will try what you guys said, and get back and tell you the result.

Thanks a lot.

Aktiwers!

bretticus

Wow, I looked at your code again and noticed my statement...

Your query seems to be one that would return multiple records and not just one. Currently your code would just show the first one in the table without iterating through the others that could come through.

was wrong, I clearly see your while loop now. If that has confused you in anyway I apologize.

AS for...

But Im afriad I will mess up some of the preemade parts of the script with changes in the code I posted above.

If it's not working like you want it to, what other choice do you have then to dig in and get it done?