Reading a STRING for a CHARACTER

[dcjones]

Hi All,

I am useing the code below with great success but I need now to be able to read the content of a STRING to see if it contain the character "*".

mysql_select_db($database_Chandos, $Chandos); 
$recordID = $_GET['recordID'];     

$query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");  



$row = mysql_fetch_array($query_DetailRS1);   

if (strlen ($row_DetailRS1['content']) == 0)
{
echo "";
}

IF THE STRING CONTAINS A "*" DO THE FOLLOWING IF NOT ECHO STRING AS NORMAL TEXT.

else
{
$broken = explode("*", $row_DetailRS1['content']);   

$countbroken = count($broken);   

echo "<uL>";   

FOR($i = 0; $i < $countbroken; $i++){   

  echo "<LI>".$broken[$i]."</LI>";   

}   

echo "</uL>";
}

Can anyone help, please.

[dcjones]

Hi again,

This is what I have come up with, but it does not work.

$row = mysql_fetch_array($query_DetailRS1);   

if (strlen ($row_DetailRS1['content']) == 0)
{ echo "";
}
elseif (strstr ($row_DetailRS1['content'], "*")
{
$broken = explode("*", $row_DetailRS1['content']);   

$countbroken = count($broken);   

echo "<uL>";   

FOR($i = 0; $i < $countbroken; $i++){   

  echo "<LI>".$broken[$i]."</LI>";   

}   

echo "</uL>";
}
else
{ 
echo $row_DetailRS1['content'];
}

Any comments please

[sidney]

  $row = mysql_fetch_array($query_DetailRS1);    

if (strlen ($row_DetailRS1['content']) == 0) 

should $row not be $row_DetailRS1

ie

  $row_DetailRS1 = mysql_fetch_array($query_DetailRS1);    

if (strlen ($row_DetailRS1['content']) == 0) 

[dcjones]

Hi, all.

$row = mysql_fetch_array($query_DetailRS1);     

if (strlen ($row_DetailRS1['content']) == 0)

works fine and returns the results I require.

$row = mysql_fetch_array($query_DetailRS1);    

if (strlen ($row_DetailRS1['content']) == 0) 
{ echo ""; 
} 
elseif (strstr ($row_DetailRS1['content'], "*") 
{ 
$broken = explode("*", $row_DetailRS1['content']);    

$countbroken = count($broken);    

echo "<uL>";    

FOR($i = 0; $i < $countbroken; $i++){    

  echo "<LI>".$broken[$i]."</LI>";    

}    

echo "</uL>"; 
} 
else 
{  

echo $row_DetailRS1['content']; 
}

If "row_detailsrs1" contains a zero length it does not show the bullet points.

If "row_detailrs1" does contain data that has a "" in it, the script makes a break when it finds a "".

What I want it to do is if the "row_detailrs1" does contain data and there are no "*" echo as a normal string.

Any ideas.

[dcjones]

Hi all again,

I am getting very close with this code to getting it working. This is what I have now:

				mysql_select_db($database_Chandos, $Chandos); 
				$recordID = $_GET['recordID'];     

				$query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");  

			$row = mysql_fetch_array($query_DetailRS1);   
			if (strlen ($row_DetailRS1['content']) == 0)
			{ echo "";
			}
			elseif (strstr ($row_DetailRS1['content'], "*")) 
			{
			$broken = explode("*", $row_DetailRS1['content']);   
			$countbroken = count($broken);   
			echo "<uL>";   
			FOR($i = 0; $i < $countbroken; $i++){   
			 echo "<LI>".$broken[$i]."</LI>";   
			}   
			echo "</uL>";
			}
			else
			{ 
			echo $row_DetailRS1['content'];
			}

What it is doing now is if "$row_detailRS1" contains data, it is bullet pointing, even when the data has no "*" in it.

Any ideas.

[ccgorman]

As stated above I really think you need to change

$row=mysql_fetch_array($query_DetailRS1);

to

$row_DetailRS1=mysql_fetch_array($query_DetailRS1);

Also

$broken=explode("*",_$row_DetailRS1['content']);

Will always return at least one result, you may want to try an ereg first, then an explode.

if (ereg("",$row_DetailRS1['content'],$nothing)) {
$broken=explode("",_$row_DetailRS1['content']);
...
}

[sidney]

did you even try my sugestion as what you still have will always return false

Originally posted by dcjones
Hi, all.

$row = mysql_fetch_array($query_DetailRS1);     

if (strlen ($row_DetailRS1['content']) == 0)

works fine and returns the results I require.

$row = mysql_fetch_array($query_DetailRS1);    

if (strlen ($row_DetailRS1['content']) == 0) 
{ echo ""; 
} 
elseif (strstr ($row_DetailRS1['content'], "*") 
{ 
$broken = explode("*", $row_DetailRS1['content']);    

$countbroken = count($broken);    

echo "<uL>";    

FOR($i = 0; $i < $countbroken; $i++){    

  echo "<LI>".$broken[$i]."</LI>";    

}    

echo "</uL>"; 
} 
else 
{  

echo $row_DetailRS1['content']; 
}

[/B]

[dcjones]

Hi Sid,

Yes I did try your sugestion but when the script was run useing

$row_DetailRS1 = mysql_fetch_array($query_DetailRS1);     

if (strlen ($row_DetailRS1['content']) == 0)

it returned empty feilds. I will give it another try, just in case I did it incorrectly. I will let you know.

Thanks.

[dcjones]

Hi Sid,

I have tried the following code and the contents feild returns empty. I have had a look at the page source code in the browser and the feild does not even show. The code I used is as follows:

mysql_select_db($database_Chandos, $Chandos); 
				$recordID = $_GET['recordID'];     

				$query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");  

			$row_DetailRS1 = mysql_fetch_array($query_DetailRS1);   
			if (strlen ($row_DetailRS1['content']) == 0)
			{ echo "";
			}
			elseif (strstr ($row_DetailRS1['content'], "*")) 
			{
			$broken = explode("*", $row_DetailRS1['content']);   
			$countbroken = count($broken);   
			echo "<uL>";   
			FOR($i = 0; $i < $countbroken; $i++){   
			 echo "<LI>".$broken[$i]."</LI>";   
			}   
			echo "</uL>";
			}
			else
			{ 
			echo $row_DetailRS1['content'];
			}

If I revert back to useing:

mysql_select_db($database_Chandos, $Chandos); 
				$recordID = $_GET['recordID'];     

				$query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");  

			$row = mysql_fetch_array($query_DetailRS1);   
			if (strlen ($row_DetailRS1['content']) == 0)
			{ echo "";
			}
			elseif (strstr ($row_DetailRS1['content'], "*")) 
			{
			$broken = explode("*", $row_DetailRS1['content']);   
			$countbroken = count($broken);   
			echo "<uL>";   
			FOR($i = 0; $i < $countbroken; $i++){   
			 echo "<LI>".$broken[$i]."</LI>";   
			}   
			echo "</uL>";
			}
			else
			{ 
			echo $row_DetailRS1['content'];
			}

the feild is displayed but irrespective of the data it is bullet pointed. As you can see from the code it should only be bullet pointed if the data has a "*" in it.

Any more ideas.

Thanks

[sidney]

this works fine ive test

 mysql_select_db($database_Chandos, $Chandos);  

                $recordID = $_GET['recordID'];      

                $query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");   

            $row_DetailRS1 = mysql_fetch_array($query_DetailRS1);    
            if (strlen ($row_DetailRS1['content']) == 0) 
            { echo ""; 
            } 
            elseif (strstr ($row_DetailRS1['content'], "*"))  
            { 
            $broken = explode("*", $row_DetailRS1['content']);    
            $countbroken = count($broken);    
            echo "<uL>";    
            FOR($i = 0; $i < $countbroken; $i++){    
             echo "<LI>".$broken[$i]."</LI>";    
            }    
            echo "</uL>"; 
            } 
            else 
            {  
            echo $row_DetailRS1['content']; 
            }
 

check the spelling of you table and field names

if no data in content field pulled from database then page will be blank also blank if no booktitle matching record id

also check for white space in your database

[dcjones]

Hi Sid,

Sorry to be a pain.

I have tested and test your suggestion and it does not return any data.

If I use "$row" it does.

Can you take a look at the page its self;

http://www.chandospublishing.com/catalogue/booklist.php

If you click on a title you will see the results. The default page will load titles that have a content, the data in this feild does not have any "*" in it.

I know you have spent some time looking at this for me and I owe you one.

Thanks

[sidney]

  $row = mysql_fetch_array($query_DetailRS1); 

this line sets a fetch array ie $row['content']

but with the line below you are using $row_DetailRS1['content']

  if (strlen ($row_DetailRS1['content']) == 0) 
 

theres no way that can work

are there more sql querys and is there some confusion to which one your using

[dcjones]

Hi Sid,

I have created 2 scripts.

http://www.chandospublishing.com/catalogue/test.php

test.php uses

$maxRows_DetailRS1 = 1;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
  $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

$colname_DetailRS1 = "1";
if (isset($_GET['category'])) {
  $colname_DetailRS1 = (get_magic_quotes_gpc()) ? $_GET['category'] : addslashes($_GET['category']);
}
mysql_select_db($database_Chandos, $Chandos);
$recordID = $_GET['recordID'];
$query_DetailRS1 = sprintf("SELECT * FROM chandos_books  WHERE ID = 4", $colname_record_filter);
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Chandos) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
  $totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
  $all_DetailRS1 = mysql_query($query_DetailRS1);
  $totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>

				mysql_select_db($database_Chandos, $Chandos);   

                $recordID = $_GET['recordID'];       

                $query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");    

            $row= mysql_fetch_array($query_DetailRS1);     
            if (strlen ($row['content']) == 0)  
            { echo "";
			}  
            elseif (strstr ($row['content'], "*"))   
            {  
            $broken = explode("*", $row['content']);     
            $countbroken = count($broken);     
            echo "<uL>";     
            FOR($i = 0; $i < $countbroken; $i++){     
             echo "<LI>".$broken[$i]."</LI>";     
            }     
            echo "</uL>";  
            }  
            else  
            {   
            echo $row['content'];  
            }

?>

</body>
</html>

And http://www.chandospublishing.com/catalogue/test1.php

uses:

$maxRows_DetailRS1 = 1;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
  $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

$colname_DetailRS1 = "1";
if (isset($_GET['category'])) {
  $colname_DetailRS1 = (get_magic_quotes_gpc()) ? $_GET['category'] : addslashes($_GET['category']);
}
mysql_select_db($database_Chandos, $Chandos);
$recordID = $_GET['recordID'];
$query_DetailRS1 = sprintf("SELECT * FROM chandos_books  WHERE ID = 4", $colname_record_filter);
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Chandos) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
  $totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
  $all_DetailRS1 = mysql_query($query_DetailRS1);
  $totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>

				mysql_select_db($database_Chandos, $Chandos);   

                $recordID = $_GET['recordID'];       

                $query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");    

            $row = mysql_fetch_array($query_DetailRS1);     
            if (strlen ($row_DetailRS1['content']) == 0)  
            { echo "";
			}  
            elseif (strstr ($row_DetailRS1['content'], "*"))   
            {  
            $broken = explode("*", $row_DetailRS1['content']);     
            $countbroken = count($broken);     
            echo "<uL>";     
            FOR($i = 0; $i < $countbroken; $i++){     
             echo "<LI>".$broken[$i]."</LI>";     
            }     
            echo "</uL>";  
            }  
            else  
            {   
            echo $row_DetailRS1['content'];  
            }

</body>
</html>

Can you try them out and see what you think.

I now have this working as it should useing the test1.php script.

If $row_DetailRS1" is empty, its does not show a bullet point.
If $row_DetailRS1" has a "" in it, it displays the data in bullet points.
If $row_DetailRS1 does not have any "" in it, it displays a normal string.

Thanks for all your help and advice.

Thanks.

[sidney]

yep i was confused about what $row query you were using

glad to see you sorted the problem