Simple Query Help

Anon

I am having two problems with the following code.

#1. When I submit my form that executes this php code, I pass through a "varible" from a from field called companyname. The php is picking it up fine. But when it displays the results it is printing the indkey fields instead of the companyname. Nowhere in the script do I indicate that it should look at the indkey field. I have read and read and can't seem to find a solution.

#2. I have commented out the print statements, but it is still displaying results. Whats up with that? Again I have searched books, forums, and websites for solutions. Maybe I have the wrong books who knows.

Anyways thanks for your help in advance. It is very appreciated. P.S. I am a rookie so take it easy on me.

//Connection Variables
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "";

//Connect
$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

//Query
$query = mysql_query("SELECT * FROM members WHERE companyname ='$companyname'");
//list($companyname) = mysql_fetch_row($query);
while(list($companyname) = mysql_fetch_row($query))
{
echo $companyname."<BR>";
$companyname++;
}

//Display Results

//print ("\n Company Name: $companyname
//");

//print ("\n Description: $descr
//");

ghornet

Have you tried echoing out your SQL statement? then running it on the DB?

Also I am not sure why you are running list($companyname) I would probable use mysql_fetch array.

But I am fairly new at this also.

Damian

tupawk

Try this:

//Query
$query = mysql_query("SELECT * FROM members WHERE companyname ='$companyname'");

while ($myrow = mysql_fetch_array($query) {

echo "$myrow[comapnyname]\n";

}

When you are fetching a bunch of rows the mysql_fetch_array() function is alot easier and to deal with.

Anon

Thanks Guys!

I got it working. Now I have to learn how to make it pretty. And figure out how to put my data into tables. So I might be back. Again thanks so much for your help.