If you have to comment out "$affiliations[] = $affiliation_row["affiliation"];", tghen
it's not
working, because this is the crux of your algorithm.
What error are you getting?
rick
"People will forget what you said. People will forget what you did.
But people will never forget how you made them feel."
----- Original Message -----
From: "Janyne Kizer" <[EMAIL PROTECTED]>
To: "Rick Emery" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 9:31 AM
Subject: Re: [PHP] Problem creating array from MySql query
Thanks for taking a look at this.
<?php
mysql_connect (wwww, xxxx, yyyy);
mysql_select_db (zzzz);
$result = mysql_query("SELECT * FROM clubs WHERE id=$id");
$row = mysql_fetch_array($result);
print "Reading affiliations...";
$affiliation_result = mysql_query("SELECT affiliation FROM
club_affiliations WHERE club_id=$id");
print "Building array...";
$affiliations = array();
print "Populating array...";
//place affiliation data into an array that we can search later
while($affiliation_row = mysql_fetch_array($affiliation_result)) {
print $affiliation_row["affiliation"];
$affiliations[] = $affiliation_row["affiliation"];
} //while
print "Dumping array...";
$count = count($affiliations);
print "Affiliations:";
for ($i=0;i<$count;$i++) {
print $affiliations[$i];
}
?>
It does print the affiliations in "print
$affiliation_row["affiliation"];" and it works properly (except for
getting the affiliations field) if the line "$affiliations[] =
$affiliation_row["affiliation"];" is commented out.
Rick Emery wrote:
>
> It helps if you show us all your code, not just what you think we might need.
>
> For isntance, what does your mysql_query() statement look like? Does it have an "or
> die(mysql_error()))" clause?
>
> ----- Original Message -----
> From: "Janyne Kizer" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, February 17, 2003 9:04 AM
> Subject: [PHP] Problem creating array from MySql query
>
> What we are trying to do is build an array from a query. I don't
> understand why but this is failing on the line "$affiliations[] =
> $affiliation_row["affiliation"];" Basically there are two tables in the
> database, since clubs can have multiple affiliations and the
> affiliations are not set in stone, there is one table only for
> affiliations. We are trying to pull the data out of the table for
> editing. Any tips would be appreciated. Thanks!
>
> $affiliation_result = mysql_query("SELECT affiliation FROM
> club_affiliations WHERE club_id=$id");
>
> $affiliations = array();
>
> print "Populating array...";
> //place affiliation data into an array that we can search later
> while($affiliation_row = mysql_fetch_array($affiliation_result)) {
> print $affiliation_row["affiliation"];
> $affiliations[] = $affiliation_row["affiliation"];
> } //while
>
> --
> Janyne Kizer
--
Janyne Kizer
CNE-3, CNE-4, CNE-5
Systems Programmer Administrator I
NC State University, College of Agriculture & Life Sciences
Extension and Administrative Technology Services
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
