fetch array error

[ProcalX]

When trying to run $t_result and $a_t_result mysql queries I get errors:

$a_result works fine. I get errors at line 17 for $a_t_result and at line 28 for $t_result.

Pretty sure my indents are fine, any help would be greatly appreciated.

	<?php

					$a = $_POST["artist"];
					$t = $_POST["title"];
					$conn = mysql_connect("localhost", "abcde", "abcde");
					mysql_select_db("abcde");

					$a_t_result = mysql_query
					("select * from hits where artist='$a' and where title='$t'");
					$t_result = mysql_query
					("select * from hits where title='$t'");
					$a_result = mysql_query
					("select * from hits where artist='$a'");

					if($a !=""&&$t !="")
					{
						while($row = mysql_fetch_array($a_t_result))
						{
							echo " Song Title: $row[song]  <br/> " ; 
							echo " Artist: $row[artist]  <br/> " ;
							echo " Year: $row[year]  <br/> " ; 
							echo " Chart Position: $row[chart]  <br/> " ; 
							echo " Searching Artist and Title Worked! " ;
						}
					}
					elseif($t !="")
					{
						while($row = mysql_fetch_array($t_result))
						{
							echo " Song Title: $row[song]  <br/> " ; 
							echo " Artist: $row[artist]  <br/> " ;
							echo " Year: $row[year]  <br/> " ; 
							echo " Chart Position: $row[chart]  <br/> " ;
							echo " Searching Title Only Worked! " ;
						}
					}
					elseif($a !="")
					{
						while($row = mysql_fetch_array($a_result))
						{
							echo " Song Title: $row[song]  <br/> " ; 
							echo " Artist: $row[artist]  <br/> " ;
							echo " Year: $row[year]  <br/> " ; 
							echo " Chart Position: $row[chart]  <br/> " ; 
							echo " Searching Artist Only Worked! " ;
						}
					}
					mysql_close($conn);
					?>

[dagon]

what's the exact error message you get?

[NogDog]

I don't believe you can have 2 "wheres" in your query:

"select * from hits where artist='$a' and where title='$t'"

// should be:

"select * from hits where artist='$a' and title='$t'"

In any case, good defensive programming practice is to check the return value of your mysql_query() commands, and if false log an error and execute a different branch of logic (output an error message instead of trying to fetch the result rows, for example).

[ProcalX]

I have changed the SQL query so that it is not running duplicate WHERE statements.

If I search both artist and title with: 'Chemical Brothers' for artist and 'galvanize' as title it runs the $a_t_result mysql query and I recieve this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/though/public_html/searchresults.php on line 17

If I search just artist with: 'Chemical Brothers' for artist it works perfectly bringing the results up.

If I search just artist with: 'galvanize' I get the same error but on line 28.

The items I am searching for are 100% correct as represented in the database.

Again your help is appreciated - also I will implement some "defensive programming" to ensure data integrity once I have mastered the basic foundations of what I am trying to code.

Thanks for your help guys

[johanafm]

NogDog's recommendation is not something to wait and implement in the future, since it is what will help you resolve this issue in the present (and increase your understanding).

mysql_query EITHER returns a result set resource (on success) OR boolean false (on error)

$a_t_result = mysql_query("select * from hits where artist='$a' and where title='$t'");

/* which means $a_t_result is now either something you can pass to
    mysql_fetch_array, or false (which you can't pass to mysql_fetch_array) */

// so, check if something went wrong
if (!$a_t_result) {
	// terminate script and output error number and error text
	// you could also just echo ... and let the script continue. your choice.
	die(mysql_errno() . ': ' . mysql_error())
}
// if you use die() above, this else is obviously not needed and could be removed
else {
	while($row = mysql_fetch_array($a_t_result))

// ...
}

And if you still havn't changed your original SQL query (as per NogDog's input), these changes should point you to the second "WHERE" in that query.