Cant figure out why this works the way it does?

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?

ahundiak

I think your loops are messed up a bit.
The way you have it written now, only the first record is checked.

You just need one while loop to cycle through.

Something like

$cnt = 0;
while($row= mysql_fetch_array($result))
{
  $cnt++;
  if (stristr ...)
  {
  }
  else
  {
  }
}
if (!$cnt) echo 'No records found';

murph7185

Thanks man that helps alot, by the way is there a way to make to if statements work together like this

if (something=something) and (anotherthing=anotherthing)

would that be what i use? and?

Thanks,
Murphy

ahundiak

if (($something == $whatever) && ($joy != $luck))
{
}

Use && for AND
Use || for OR

Might want to skim through the manual.

murph7185

Ya sorry for all the questions I'm pretty new at this stuff. I have been lookin at the manual during the course of today i did a search for "and", and nothing came up, thats why asked. Thanks alot the man its much appreciated. 🙂

Teen0724

Also watch your semicolons. That was the reason for the script failing.