Re: Contributor Database
Thanks Again Bob it's working fine with total amount and Name.
Now I want to have the Person Details - ID, Name, City and Also to have Account Details - PID, Total Amount, Both on the Same page, I get only Person Details - ID,Name,City and I got a Error Msg( see below):
I HAVE PUT THIS CODE:
<?php
include 'config.php';
include 'connect.php';
$query = "SELECT Pledge_ID,Amount_Pledged FROM pledges";
$query = "SELECT Contributor_ID, Donor_Name, country FROM contributors";
$result = mysql_query($query);
$result = mysql_query($query)
or die("Query failed: " . mysql_error() .
"<br>Actual query: " . $query);
while($row = mysql_fetch_row($result))
{
$Contributor_ID = $row[0];
$Donor_Name = $row[1];
$Country = $row[2];
$Pledge_ID = $row[3];
$Amount_Pledged = $row[4];
echo "ID :$Contributor_ID <br>" .
"Name : $Donor_Name<br>" .
"City : $Country<br>".
"PID : $Pledge_ID <br>" .
"Amount : $Amount_Pledged <br><br>";
}
include 'closedb.php';
?>
I GOT THIS ERROR MSG:
Notice: Undefined offset: 3 in c:\Inetpub\wwwroot\datas.php on line 20
Notice: Undefined offset: 4 in c:\Inetpub\wwwroot\datas.php on line 21
ID :19
Name : Mama Loga
City : Chimala(Mbeya)
PID :
Amount :
Subject
Written By
Posted
Re: Contributor Database
July 21, 2006 11:17AM
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.