help with script to loop through records and produce true or false

aron

hi all.

<?
while ($line_category = mysql_fetch_array($result_category, MYSQL_ASSOC)) {

$dlocation = $line_category["location"];

$sql_map = "SELECT * FROM card_details WHERE location = $dlocation and map = Yes";

$result_map = mysql_query($sql_map,$connection);

if ($result_map = TRUE)
{
$picimg = '<img src="admin_images/picimg.gif" />';
}
else
{
$picimg = '<img src="admin_images/spacer.gif" width="10" height="10"/>';
}

i want to loop through a table looking for a recorde. if it finds in then i want to show an image, if it dosent then dont show an image.

can anyone help please.

cheers aron.

rincewind456

That piece of code will always set $picimg to <img src="admin_images/picimg.gif" /> because in your if you are setting $result_map to true, not comparing to see if it is!.

The line should read

if ($result_map == TRUE)

Aslo please put your code in [ php][/code] tags (without the space).

aron

hmm dosetn seem to work. there is 1 recored in the database with the value of "Yes" in the map field ( **** the value Yes is a word)

but it shows a spacer image ( meaning that it returned false)

 <?
while ($line_category = mysql_fetch_array($result_category, MYSQL_ASSOC)) {

$dlocation = $line_category["location"];

echo $dlocation;

$sql_map = "SELECT * FROM card_details WHERE map = Yes AND location = $dlocation ";
$result_map = mysql_query($sql_map,$connection);

if ($result_map == TRUE)
{
$picimg = '<img src="admin_images/picimg.gif" />';
}
else
{
$picimg = '<img src="admin_images/spacer.gif" width="10" height="10"/>';
}

?>

cheers aron.

rincewind456

You want to print out the $result_map to be sure that there is a result being returned, because unless it is empty or set to zero it will work .
Try this

<?php
while ($line_category = mysql_fetch_array($result_category, MYSQL_ASSOC)) {

$dlocation = $line_category["location"];

echo $dlocation;

$sql_map = "SELECT * FROM card_details WHERE map = Yes AND location = $dlocation ";
$result_map = mysql_query($sql_map,$connection);

print_r($result_map);

if ($result_map == TRUE)
{
	$picimg = '<img src="admin_images/picimg.gif" />';
}
else
{
	$picimg = '<img src="admin_images/spacer.gif" width="10" height="10"/>';
}

?>

Weedpacket

Um, $result_map will always be equivalent to true, unless the query fails completely (an empty result set is still a result set). Look at the number of rows in the result set to see if it's empty or not.

Or, unless the thing you're displaying depends on the data itself, use "SELECT COUNT(*) FROM card_details WHERE map = Yes AND location = $dlocation". You'll get back one record with one field that will say how many matching records there are in the table.

In fact, I just took a look at MySQL's documentation and it recognises EXISTS; so if you just want to if there are any matching rows in the table you don't need to go to all the effort of counting them.