I'm pulling my hair out trying to figure this out!

murph7185

Ok i can't figure this out any more I thought I had it but then i used my refresh button everytime i enter a script.php?id=1 or 2 (2 has the # sign in it) it still gives me the else statement. Id like to add a split statement after the the stristr statement but i cant even get up to that part yet. And using strchr instead of stristr doesn't make a difference.

But when i use

list ($oldpart, $newpart) = split ('[#]', $row["name"]);
it seems to split it up fine every time and do what i want but when i enter id=1 (which doesn't have a pound sign) i then get the first statement instead of the else statement... Any help would be great. Sorry i'm new but ive been trying thing after thing to get this goin, hope this makes sense.

<?php

$part = "USE PART";

$db = mysql_connect ("localhost", "root", "root");

mysql_select_db("test",$db);

if ($id == "")
{$id = '%';}

if ($name == "")
{$name = '%';}

$result = mysql_query ("SELECT * FROM ticket_fields
WHERE id LIKE '$id%'
AND name LIKE '$name%'
",$db);

$cnt = 0;
while($row= mysql_fetch_array($result)){
$cnt++;
if (stristr ("#", $row["name"])){
print "Check out our new part here, the part number is";
}

else {
print "i dont know what to do any more";
}

}
if (!$cnt) echo 'No records found';

</body>
</html>

tichick

murph,

Could you show an example of your data?

Sometimes, when I have problems like this and it's not my db, I try to handle the problem in a query. Either append a # to your search term, or search on part of the field.

Try mysql.com

murph7185

ya this is how my data table is set up, this is just using phpmyadmins test database i plain to setup a new database but first i wanna figure out the script.

here is an exaple of 2 data fields that are different

id name value dorder
1 Regular Description fred@email.com Programmer
2 USE PART#4543 george@email.com Webmaster

Now what i want to do is see if the field name has a # in it and if it does split the field between usepart and 4543 and so i can use the 4543 part in the print field below, if the field doesn't have a , then print my statement, which i will later change to all the values in that collumn

But basicly what i need to figure out is how check for #

m_tt

I'm not totally sure what you're trying to do here but maybe this will help.


$connect = mysql_connect(host,user,pass)or die(mysql_error());
mysql_select_db(data)or die(mysql_error());

$id	= ($id == "" ? $id = "%" : $id = $id);
$name	= ($name == "" ? $name = "%" : $name = $name);

$query = mysql_query("SELECT id,name,value,dorder FROM ticket_fields WHERE id LIKE '%$id%' AND name LIKE '%$name%'")or die(mysql_error());

if (mysql_num_rows($query) > 0) {
while(list($o_id,$o_name,$o_value,$o_dorder) = mysql_fetch_row($query)) {
  if (stristr($o_name, "#")) {
   list($p1,$part_num) = explode("#",$o_name);
   $result .= "Check out our new part here, the part number is " . $part_num . "\n";
  } else {
   $result .= "No # sign found.\n";
  }
}
} else {
	$result = "No records found.";
}

mysql_close($connect);

Like I said, i'm not totally sure what you're trying to do here 🙂

m_tt

oh and echo $result at the end :p

murph7185

Wow man thanks that helped alot, i changed around a few things and got it to work now, like the other one i want to be able to print the columns if the search for # returns false, the other one was setup $row["name"]

murph7185

Scratch that, i just figured it out im blind

m_tt

I think you had the stristr vars backwards 🙂