PHP & MySQL result processing: what am I doing wrong?

[bugmuncher]

Hello, all. I believe I am a newbie.

In the following example, I'm trying to get 2 text fields out of my database, just to see what they are (and hopefully to use them!

I figured I would use mysql_fetch_assoc to make an array of pairs of orgName and orgSuggestedCopy.

But when I run the script, instead of getting whole records, I get "m" for both echos.

I think I am approaching this the wrong way.

--------------------

$query="SELECT orgName, orgSuggestedCopy FROM organizations WHERE oid='$firstSub'";
$result=mysql_query($query)
or die ("Error");

$debug="mysql_fetch_assoc($result)";
echo $debug['orgName'];
echo $debug['orgSuggestedCopy'];

[wildteen88]

Change this:
[code]$debug="mysql_fetch_assoc($result)";[/code]to:
[code]$debug= mysql_fetch_assoc($result);[/code]

[roland]

[quote name='bugmuncher' date='Apr 7 2006, 04:10 AM' post='362463']
Hello, all. I believe I am a newbie.

In the following example, I'm trying to get 2 text fields out of my database, just to see what they are (and hopefully to use them!

I figured I would use mysql_fetch_assoc to make an array of pairs of orgName and orgSuggestedCopy.

But when I run the script, instead of getting whole records, I get "m" for both echos.

I think I am approaching this the wrong way.

--------------------

$query="SELECT orgName, orgSuggestedCopy FROM organizations WHERE oid='$firstSub'";
$result=mysql_query($query)
or die ("Error");

$debug="mysql_fetch_assoc($result)";
echo $debug['orgName'];
echo $debug['orgSuggestedCopy'];
[/quote]

Try this...
$query="SELECT orgName, orgSuggestedCopy FROM organizations WHERE oid='$firstSub'";
$result=mysql_query($query, $link)
or die ("Error");

while($debug="mysql_fetch_assoc($result)){
echo $debug['orgName'];
echo $debug['orgSuggestedCopy'];
}
[/quote]