Debugging Php Code

[divadiva]

Experts

 

I am going to ask the same question I asked yesterdat but this time I will be more precise.I did tried some debugging on myside,but I would appreciate your expert advice.

 

My system has on of the field named "Word"(basically a textbox).In this textbox you can enter a number or word and hit search.If there is any data present in database it will return the data.But the problem is that when I hit search I get an empty table.

 

I was debugging and found that somehow the system is duplicating the values I enter.Supposingly I enter 'a' in word column I get 'aa' in return.

 

Below is the code:

 

<% if ($swords){
										//print_r($_POST);
										//print_r($_GET);
								                 print $swords;   								print $swords;
									$fstring .= " AND ( `description` REGEXP '$swords' 
									OR `configuration` REGEXP '$swords' 
									OR `software` REGEXP '$swords' 
									OR `hardware` REGEXP '$swords' 
									OR `model` REGEXP '$swords' 
									OR `manufacturers` REGEXP '$swords' 
									OR `process` REGEXP '$swords' 
									OR `inventory_id` REGEXP '$swords' 
									OR `serial_number` REGEXP '$swords'
									OR `tool_id` REGEXP '$swords' )";
} else {									print 'N/A';

[conker87]

Try replacing all '$sword' with '%$sword%'

 

Wait, you are printing it twice you know...

[divadiva]

$print sword  at the top is for check .I tried what you have sugegsted but didnt work.

 

I have another file "edit inventory" It uses same piece of code and works there.

 

Please help me on this.I will appreciate your suggestions.

 

[Buddski]

conker is right if you have

print $swords; print $swords;

and 'a' is stored in $swords you are going to get 'aa' as output..

[divadiva]

Thanks for replying.

 

I commented  "print $swords;" .But still it is not showing any result.

 

Regards

Diva

[conker87]

Try doing what I said anyway:

 

Replace all '$sword' with '%$sword%'

 

Also, I've never heard of the REGEXP function in SQL.

[divadiva]

Thanks once againfor replying.

 

I will try that.

[divadiva]

I tried that doesnt do any good .

 

Actuallt I have one more file "Edit Inventory" which uses same logic "WORD" works fine.But somehow this doesnt works.

 

Interestingly ,in the other file if I type print$swords it returns one alphabet whereas the file I am trying to debug returns duplicate values.Thats why I mentioned this point in one of my previous posts.

 

Cheers!

 

 

[GingerRobot]

Also, I've never heard of the REGEXP function in SQL.

 

http://dev.mysql.com/doc/refman/5.0/en/regexp.html

[conker87]

Also, I've never heard of the REGEXP function in SQL.

 

http://dev.mysql.com/doc/refman/5.0/en/regexp.html

Convenient!

[divadiva]

I have fixed .Issue was SQL was not right.Parenthesis ")" were missing.Thanks all for the suggestions.

 

Cheers