Undefined Offset?

JGross

Heres my problem, ive been working on it for way to long to not get a result from it so hopefully a higher php power can help me out here.

I have a string in a mySQL database that i want to break up so that i can use different parts of it as identifiers to trigger other areas of php. Right now all i want to do is split up the string. Heres what I have as far as code is concered at the moment:

if ($query = mysql_query("SELECT bnetstring, timerec FROM botin ORDER BY timerec LIMIT $start, 28", $link))
{
	while($query_array = mysql_fetch_array($query))
		print "$query_array[bnetstring]<br><br>";
		list($number,$type,$name,$number2,$entry) = split (" ", "$query_array[bnetstring]");
		print "$name said $entry";

}

That should be sufficient

When i upload that with the rest of the code to the server it returns this on the page:

1005 TALK Fear_AS 0010 "!&$%er"

Notice: Undefined offset: 4 in /www/f/fear/htdocs/php/bot/test.php on line 29

Notice: Undefined offset: 3 in /www/f/fear/htdocs/php/bot/test.php on line 29

Notice: Undefined offset: 2 in /www/f/fear/htdocs/php/bot/test.php on line 29

Notice: Undefined offset: 1 in /www/f/fear/htdocs/php/bot/test.php on line 29
said

Now how are those variables undefined and im obviously missing out on something big here. Sorry if this should be on the newb forum this branch of php is new for me. But if anyone is willing please do help, thanks.

sarahk

Right, your problem is in one of two places.

You're not getting your data back from the database. If this is the problem you will see this with your first print.
Your split isn't working.

So, this is how I'd debug it

if ($query = mysql_query("SELECT bnetstring, timerec FROM botin ORDER BY timerec LIMIT $start, 28", $link)) 
{ 
while($query_array = mysql_fetch_array($query)) 
//I don't like having array refs inside the double quotes, unpredicatible.
print "my query result: " . $query_array[bnetstring] . "***<br><br>"; 

//took the quotes off the array here too.
list($number,$type,$name,$number2,$entry) = split (" ", $query_array[bnetstring]); 
print "First Test: $name said $entry<br>"; 

$testStr = "ABCDEF";
list($number,$type,$name,$number2,$entry) = split (" ", $testStr); 
print "Second test: $name said $entry<br>"; 
}

this should help you pick the place where it's falling over.

good luck