MYSQL!

[Anon]

Query variables:
Echo "Pound $pound: & pussy: $a_cat<br>";

$query = "SELECT pound FROM rspca WHERE a_cat=$a_cat";
$category  = mysql_query($db, $query);

if (!$category) {
    echo "Error1 connecting to the table.<br>\n";
} else {
  //check whether cat  lives in another pound ?!
  if ($row = mysql_fetch_array($category)){
	  while ($row){ ß----------- IS THIS VALID?!
		  $match = $row['a_cat'];
		  if ($a_cat == $match) {
			  $pound = $row['pound'];
			  echo "Also exist in $pound";
		  }
	  }
	  //$error = 1;
	  //$error_array[] = "<i>This cat already exists in the database.</i>";
  } 
}

I am trying to loop through the whole database searching for a match in all table records! IS there an more efficient way… mysql_fetch_field? But that is for a table record. I want to check with all table records in the database… Anyone get me? HELP HELP?

[tasistro]

I think you're doing what mysql already did.

Do

Query variables:
Echo "Pound $pound: & pussy: $a_cat<br>";

$query = "SELECT pound FROM rspca WHERE a_cat=$a_cat";
// ERROR HERE, YOU HAVE db before SQL string, its backwards, do the following >>>>
$category = mysql_query($query,$db) or die("UPS, ERROR HERE UNABLE TO RUN SQL<br>SQL = ".$query);

//check whether cat lives in another pound ?!
while ($row = mysql_fetch_array($category)){
// This past line is ok
// not valid :>> while ($row){ ß----------- IS THIS VALID?!
echo "Also exist in ".$row["pound"];
}

You also have the following problem:
$match = $row['a_cat'];
There is no a_cat column in the result because you said

SELECT pound FROM...

Saludos
Gerardo

[herve]

An example on how to do it :

$result = mysql_query("SELECT * FROM
clients",$db);

$myrow=mysql_fetch_array($result);

if ($myrow)
{
do
{
$name = $myrow["name"];
if ($name == $search)
{
... do what I want when found
somthing
}
}
while ($myrow=mysql_fetch_array($result));
}

[Anon]

Why not:

mysql_connect();
mysql_select_db();

$ok = mysql_num_rows(mysql_query("SELECT pound FROM rspca WHERE a_cat=$a_cat AND pound = $pound"));

if($ok != 0)
echo "Pussy is present";
else
echo "Pussy is absent!";