where is $id set in ("SELECT affiliation FROM club_affiliations WHERE club_id=$id")
Also, change to:
$query = ("SELECT affiliation FROM club_affiliations WHERE club_id=$id"";
$affiliation_result = mysql_query($query) or die(mysql_error());
The above will help identify bad queries.
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
