[RESOLVED] How to do query using array

otixz

Good day everyone and Merry Christmas!

I have a question and I hope that there's anyone of you can answer me.

here is my code:

for($z=0;$z<=$countdate;$z++)
{
$ha= $newdate[$z];
echo $newdate[$z]."<br>";

					$querySearch = "SELECT * FROM actatek_obtc where date='$newdate[$z]'";
					$qryResult = mysql_query($querySearch);
					$row = mysql_num_rows($qryResult);						
					//echo $emp_id." ".$newdate[$z]."<br>";

					}

Question:
1.) how can I do a query using an array?
2.) if I will echo the $querySearch variable, it will show a return of:
SELECT * FROM actatek_obtc where date=''

why?

Thank you very much!

Grace

bradgrafelman

Try writing it properly:

$querySearch = "SELECT * FROM actatek_obtc where date='" . $newdate[$z] . "'";

otixz

Thank you very much Sir, I've already tried it ... but the result is still the same:

SELECT * FROM actatek_obtc where date=''

Any more idea?

bradgrafelman

Do a print_r($newdate) and paste the output so we can see what the array looks like.

otixz

Thank you Sir for the assistance:

Here is the output:

SELECT * FROM actatek_obtc where date=''Array ( [0] => 2006-12-01 )

bradgrafelman

So the array only has 1 item at index #0. Meaning this for() statement should only run once. If it's running more than once, then $countdate isn't set right (if it's the number returned from count($newdate) then you should be checking if $i is less than this variable, not less than or equal to).

otixz

Thank you very much! that resolved my problem! Thank you very much for your help Sir!!! Merry Christmas!