Re: Contributor Database
Posted by: George John
Date: July 21, 2006 11:17AM

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 :

Options: ReplyQuote


Subject
Written By
Posted
July 19, 2006 08:59AM
July 19, 2006 09:22AM
July 19, 2006 11:31PM
July 21, 2006 04:52AM
July 21, 2006 08:30AM
Re: Contributor Database
July 21, 2006 11:17AM
July 21, 2006 11:54AM


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.