18 replies to this topic

[Unreal]

Yello,
Well i decided illd go ahead with my game releated search thing, and ive came accross my first bug which i have no idea to fix it, ok so lemme explain :
A user types in a games name, into a textbox, he clicks search, and the results pop up.. thats fine right? BUT IT ISNT XD now im getting to the point. If someone types a games name and we dont have stuff for that game, a blank page appears, how do i make it say " sorry no information found" .. i no it must be easy.. but i cant figure it out..
here's the current code :

<?
//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","*****","******"); 
	
//select which database you want to edit
mysql_select_db("cheats"); 

$search=$_POST["search"];

//get the mysql and store them in $result
//change whatevertable to the mysql table you're using
//change whatevercolumn to the column in the table you want to search
$result = mysql_query("SELECT * FROM cheat WHERE title LIKE '%$search%'");

//grab all the content
while($r=mysql_fetch_array($result))
{	
   //the format is $variable = $r["nameofmysqlcolumn"];
   //modify these to match your mysql table columns
  
   $title=$r["title"];
   $message=$r["cheat"];
   $who=$r["website"];
   $date=$r["date"];
   
   //display the row
   echo "$title <br> $message <br> $who <br> $date";

}
?>

[theguid]

I dont know much php, but instead of a while statement can you use an if-else statement? The default case could be to return a 'nothing found' message and the if statement could just have a break at the end of it if the condition was met (it found a match).

[Unreal]

well below the echo of the results, i tried this -
if $result == null then
echo "sorry no results found"

but that didnt work..

[Jaymz]

Here, try this....

<?PHP
//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","*****","******");

//select which database you want to edit
mysql_select_db("cheats");

$search=$_POST["search"];

//get the mysql and store them in $result
//change whatevertable to the mysql table you're using
//change whatevercolumn to the column in the table you want to search
$result = mysql_query("SELECT * FROM cheat WHERE title LIKE '%$search%'");

	//BEGIN JAYMZ'S EDITS

	if($search)
	{

	//END JAYMZ'S EDIT

//grab all the content
while($r=mysql_fetch_array($result))
{
  //the format is $variable = $r["nameofmysqlcolumn"];
  //modify these to match your mysql table columns
 
  $title=$r["title"];
  $message=$r["cheat"];
  $who=$r["website"];
  $date=$r["date"];
 
  //display the row
  echo "$title <br> $message <br> $who <br> $date";

}

//BEGIN JAYMZ'S EDIT2

if(!$result)
{echo "We're sorry, there were no results for that search.";}

}

//END JAYMZ'S EDIT2

?>

Edited by Jaymz, 19 October 2004 - 03:18 PM.

[Dabu]

<?
//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","*****","******");

//select which database you want to edit
mysql_select_db("cheats");

$search=$_POST["search"];

//get the mysql and store them in $result
//change whatevertable to the mysql table you're using
//change whatevercolumn to the column in the table you want to search
$result = mysql_query("SELECT * FROM cheat WHERE title LIKE '%$search%'") or die("Mysql Error: " . mysql_error());

$numresults = mysql_num_rows($result);

if ($numresults < 1) {
echo "Error, no results found!";
exit();
} else {

//grab all the content
while($r=mysql_fetch_array($result))
{
  //the format is $variable = $r["nameofmysqlcolumn"];
  //modify these to match your mysql table columns
 
  $title=$r["title"];
  $message=$r["cheat"];
  $who=$r["website"];
  $date=$r["date"];
 
  //display the row
  echo "$title <br> $message <br> $who <br> $date";

}
}
?>

Give that code a try. Basicly its counting the number of rows affected by the search query, then if the number of rows affected is 0, it returns "Error, No Results Found" and stops loading the page (exit). Otherwise it will resume with the display of the results as normal.

[Jaymz]

Wow more complex than mine

[Dabu]

thats cuz i pwnzor you

[Jaymz]

[Unreal]

Thanks Dabu, your worked great Thanks jaymz for trying

[Jaymz]

No problem

[Dabu]

Hah I win! Score is one Dabu none for Jaymz! Back on subject, no problem here to help anytime (just ask Faken or Jay how much I love to code! )

[Unreal]

Thanks again Ill probly get some more bugs soon.. when i finnish this part..

[Jaymz]

NP again , I can do basic php, but I spent 45mins last night trying to limit the amount of times a loop would loop and select from a database, when all I needed was "LIMIT 5"

[Gio]

Jaymz, Dabu roX0rz, and your still pretty new so of course he will pwn you

[Jaymz]

Maaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

Dabu doesn't pwn me, the sheep does Yeah, that's right, I have the kickass sheep miniavatar

[Dabu]

the cow pwns all, am I am the master of the cows

MOOOOOO

[Gio]

Its funny because no one knows what the little icons are all about!

[Unreal]

New member / profile system or even a chat or something? XD

[Gio]

Just giving more customization to the users really.