Need help with string character function

murph7185

Ok, ive made some leway sense my last post "Manipulating mysql entry fields? " what i'd like to know is, if there is a way to check a string for a certain character in this case a "#" maybe it might look something like this:

if string_has_this_character ('#')

do {this};

so im trying to figure out with the function is for "string_has_this_character"

sarahk

have you looked at

echo $spy = stristr("James Bond 007","007");

http://www.php.net/manual/en/function.stristr.php

then there are regular expressions or just looping through the number of characters to see if there is a match and returning true or false.

murph7185

Ok heres my script right now but its not working like it should

if ($row = mysql_fetch_array($result)) {

if (stristr ('#', $row["name"])) {

print "Check out our new part here";}

else {
print $row["id"];
print (" ");
print $row["name"];
print (" ");
print $row["value"];
print (" ");
print $row["dorder"];
print ("<p>");
} while($row = mysql_fetch_array($result));

}else {print "Sorry, no records were found!";}

what happens when a string contains a # is it not only prints what its supposed to but it prints the other stuff after, but it also prints the stuff below is it because i use two if statements?

xblue

hi, I reformatted you code to make it more readable (please use the [php] [/php] tags when you post code)

if ($row = mysql_fetch_array($result)) {

if (stristr('#', $row["name"])) {

    print "Check out our new part here";
} else {
    print $row["id"];
    print(" ");
    print $row["name"];
    print(" ");
    print $row["value"];
    print(" ");
    print $row["dorder"];
    print("<p>");
}
while ($row = mysql_fetch_array($result)) {
    ;
}

} else {
    print "Sorry, no records were found!";
}

now, I can't see what exactly you want to do. I'd guess processing multiple records, diplaying either "Check out our new part here" or the values from the database, and displaying an error message if no rows where selected. If that's correct, here's another approach:

if (mysql_num_rows($result)==0) {
    print "Sorry, no records were found!";
}

while ($row = mysql_fetch_array($result)) {

if (stristr('#', $row["name"])) {
     print "Check out our new part here";
} else {
    print $row["id"];
    print(" ");
    print $row["name"];
    print(" ");
    print $row["value"];
    print(" ");
    print $row["dorder"];
    print("<p>");
}
}