hello again, here I am attemping to make a search engine for my cms, and the strangest thing happens..
<?php
$sql = $MySQL->Query("SELECT * FROM ".$pre."News_Articles WHERE Article_Story LIKE '%".$_GET['search']."%' OR Article_Full_Story LIKE '%".$_GET['search']."%'");
while($article = mysql_fetch_array($sql)){
echo $article['Article_Title']."<br />";
}
?>
thats the only code in a module file for my testing search engine, now whats strange is no matter what you search for or even if there is no search field filled, the information is outputted through the $MySQL->Query(), AND the while loop, ive never came across anything like this before and I was hoping someone could help me, if your not quite understanding what I mean below is the copy and pasted result of a null search
0. Thank you Hyprkookeez for the new smilies
1. Presenting Skins @ PHPublisher.net
2. Many enhancements
3. Resignation of 22367rh
4. Questions and Answers page is up
5. A new domain and server
6. Server switch next week
7. Development slows, Drastically..
8. PHPublisher testing
9. New Staff Member: Mitch528
10. User profile system redirect fixed.
11. Mod Complete - Tagboard
12. New rule for PHPublisher
13. Just to let you know we are not lying down on the job
14. We are looking for another PHP-Programmer!
15. 3 big releases all at once and a big bounce in percentage!
16. New Wires Template & new refresh feature
17. PHPublisher recruits 3 new staff members!
18. Many overal site enhancements
19. MySQL database mysteriously deleted.
20. Private Messaging System installed!
21. Backend changes lightly
22. Send us messages!
23. First security flaw, fixed
24. Omg, has this ever happened to you?
25. Accepting all types of suggestions!
26. Special Thanks goes out to 22367rh!
27. Site Survey
28. Development slows, and new project titles are released!
29. Sessions now in place
30. Ciritcal backend changes now in place
31. Some further development
32. Getting my own place this Friday!
33. We now have Emoticons!
34. Major changes today
35. Still working...
36. New Template and More functions
37. Members Module for the most part finished.
38. Blue Edge Template, and Block System Done!
39. TimTimTimma.com hosts PHPublisher!
40. Thank you for choosing PHPublisher
Thank you for choosing PHPublisher
TimTimTimma.com hosts PHPublisher!
Blue Edge Template, and Block System Done!
Members Module for the most part finished.
New Template and More functions
Still working...
Major changes today
We now have Emoticons!
Getting my own place this Friday!
Special Thanks goes out to 22367rh!
Some further development
Ciritcal backend changes now in place
Sessions now in place
Development slows, and new project titles are released!
Site Survey
Accepting all types of suggestions!
Omg, has this ever happened to you?
First security flaw, fixed
Send us messages!
Backend changes lightly
Private Messaging System installed!
MySQL database mysteriously deleted.
Many overal site enhancements
PHPublisher recruits 3 new staff members!
New Wires Template & new refresh feature
3 big releases all at once and a big bounce in percentage!
We are looking for another PHP-Programmer!
Just to let you know we are not lying down on the job
New rule for PHPublisher
Mod Complete - Tagboard
User profile system redirect fixed.
New Staff Member: Mitch528
PHPublisher testing
Development slows, Drastically..
Server switch next week
A new domain and server
Questions and Answers page is up
Resignation of 22367rh
Many enhancements
Presenting Skins @ PHPublisher.net
Thank you Hyprkookeez for the new smilies
it outputs it once with the numbered result, and then without, the second time it outputs it is outputing it through the while loop, i know this because ive messed with it alittle and I added the <div align="left"></div> around it, and the while loop part aligns itself to the left...but why is it outputing the data twice??
here is a link to the file: http://phpublisher.net/index.php?find=search
