Jump to content


Photo

A simple query problem


  • Please log in to reply
6 replies to this topic

#1 dransiksapoc

dransiksapoc
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 02 June 2006 - 08:58 AM

I tried searching the forums as well as the internet. Needless to say I could't find a solution. What I'm trying to do is setup a form in html to search multiple columns not at once just single in my php results page. Everytime I submit it I get a 404.

The form is setup like this:




<form method="post" action="http://warriorsofhon...le/monster.php" target="_blank">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td bordercolor="#000000">
<p align="center">
<select name="metode" size="1">
<option value="Name">Name</option>
<option value="Level">Level</option>
<option value="Averag HP">Average HP</option>
<option value="Damage Type">Damage Type</option>
<option value="Class">Class</option>

</select> <input type="text" name="search" size="25">  <br>
Search database: <input type="submit" value="Go!!" name="Go"></p>
</td>
</tr>
</table>
</div>
</form>

And the subsequent results page is setup like this:

<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td><b>Name</b></td>
<td><b>Level</b></td>
<td><b>Average HP</b></td>
<td><b>Damage Type</b></td>
<td><b>Resistances</b></td>
<td><b>Vulnerabilities</b></td>
<td><b>Class</b></td>
<td><b>Type</b></td>
<td><b>Edition</b></td>
</tr>
<tr>
<td>
<?php

$hostname = 'localhost';
$username = '';
$password = '';
$dbname = 'warriors_members';


MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection unavailable");
@mysql_select_db( "$dbname") or die( "Unable to select database");
?>
<?
//error message (not found message)begins
$XX = "No Record Found, to search again please close this window";
//query details table begins
$metode = $_POST['metode'];
$search = $_POST['search'];

$query = mysql_query('SELECT * FROM `Montster` $metode LIKE '%$search%'");
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["Name"];
$variable2=$row["Level"];
$variable3=$row["Average HP"];
$variable4=$row["Damage Type"];
$variable5=$row["Resistances"];
$variable6=$row["Vulnerabilities"];
$variable7=$row["Class"];
$variable8=$row["Type"];
$variable9=$row["Edition"];
//table layout for results

print ("<tr>");
print ("<td>$variable1</td>");
print ("<td>$variable2</td>");
print ("<td>$variable3</td>");
print ("<td>$variable4</td>");
print ("<td>$variable5</td>");
print ("<td>$variable6</td>");
print ("<td>$variable7</td>");
print ("<td>$variable8</td>");
print ("<td>$variable9</td>");
print ("</tr>");
}

//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}
//end
?>
</table>
</center>


Anyway, any suggestions would be helpful.

#2 shortj75

shortj75
  • Members
  • PipPipPip
  • Advanced Member
  • 118 posts
  • LocationPort Huron,mi

Posted 02 June 2006 - 10:07 AM

is it displaying the number 404 on the query page or is it saying error 404 if it is saying error 404 that
means the the page you are looking for is missing so check the action part of your form tag make sure
the url is spell correctly and also in your form tag you need to put the method in there and it look like you need to put method="post" because with out that you variables $metode = $_POST['metode']; and $search = $_POST['search']; will not work if it is the
number 404 try removeing the @ symbol
at your @mysql_select_db and your @mysql_fetch_array($query) and see if that helps
The Short One

hopfully this helps if it doesn't sorry
i won't write the code for you!!! you don't learn that way

#3 dransiksapoc

dransiksapoc
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 03 June 2006 - 09:15 AM

The URL was not correct under the action and actually I do have the Method set as post in my form, but what I'm getting now is:

Parse error: parse error, unexpected $ in /home/warriors/public_html/Table/monster.php on line 82

Thing is there is no line 82 actually it ends on 81

#4 kenrbnsn

kenrbnsn
  • Staff Alumni
  • Advanced Member
  • 8,235 posts
  • LocationHillsborough, NJ, USA

Posted 03 June 2006 - 02:35 PM

That error usually means you either have mis-matched curly brackets or quotes.

Ken

#5 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 03 June 2006 - 03:05 PM

$query = mysql_query('SELECT * FROM `Montster` $metode LIKE '%$search%'");
That's likely the cause of the problem. Try:
$query = mysql_query("SELECT * FROM `Montster` $metode LIKE '%$search%' ");

Legend has it that reading the manual never killed anyone.
My site

#6 dransiksapoc

dransiksapoc
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 03 June 2006 - 09:02 PM

[!--quoteo(post=379633:date=Jun 3 2006, 10:05 AM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Jun 3 2006, 10:05 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
$query = mysql_query('SELECT * FROM `Montster` $metode LIKE '%$search%'");
That's likely the cause of the problem. Try:
$query = mysql_query("SELECT * FROM `Montster` $metode LIKE '%$search%' ");
[/quote]

That was the problem, thank you much. I now am getting no record found on my php page, I don't know why as of yet, gonna play around with it a bit, but if anyone has any suggestions why that is I'm more then welcome for the advice

#7 dransiksapoc

dransiksapoc
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 03 June 2006 - 09:41 PM

I take that back I found my problem and fixed it. Thanks for all the help guys, I really am starting to get a handle on some of the basics of this stuff, thank you.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users