Search problem?

Pinkmischief

Hi guys i am having problems with this script ???

it is for a search facility

<?php require_once("Connections\connect.php");?>
<form id="form1" name="form1" method="post" action="">
<label></label>
<div align="center">
<label>
<input name="keyword" type="text" id="keyword" />
</label>
<label>
<input type="submit" name="Submit" value="Search" />
</label>
</div>
</form>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="118"><?
$sql = "select * from drivers where id=" . $POST['keyword'] . " and manufacturer='" . $POST['keyword'] . "'";

$query = mysql_query($sql);

while ($row = mysql_fetch_array($query)) { echo "<p>",$row['os'],": ",$row['manu']; }
?>
</td>
</tr>
</table>

Would anyone please be kind enough to help me with this script?

Kind Regards Pinky

planetsim

Firstly please wrap your code in [php][/php] tags. Secondly why not explain what the problem is, such as an error not doing something correctly.

Pinkmischief

Thanks for the reply

ok here is the closed php tags using the

<?php require_once("Connections\connect.php");?>

<?
$sql = "select * from drivers where id=" . $_POST['keyword'] . " and manufacturer='" . $_POST['keyword'] . "'"; 


$query = mysql_query($sql); 


while ($row = mysql_fetch_array($query)) {  echo "<p>",$row['os'],": ",$row['manu']; }

?>
</td>
</tr>
</table>

OK what i wanted this to do is search driver database for the existence of a required keyword in the fields os and manu there is other fields but if this could work i could just add the other fields later on.
When processing the search page i get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wamp\www\search.php on line 22

Line 22 = while ($row = mysql_fetch_array($query)) { echo "<p>",$row['os'],": ",$row['manu']; }

Many Thanks Pinky

rincewind456

$sql = "select * from drivers where id=" . $_POST['keyword'] . " and manufacturer='" . $_POST['keyword'] . "'";

Is not going to work, your searching for keyword as ID and as manufacturer, id has to be a number or else you need single quotes around it.

Pinkmischief

Please explain a little :S

rincewind456

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wamp\www\search.php on line 22[/code]
You get that when no result is returned from the database

Pinkmischief

i get it 🙂

Pinkmischief

If i change it to this it should work then

$sql = "select * from drivers where os=" . $POST['keyword'] . " and manufacturer='" . $POST['keyword'] . "'";

I realised what you meant by id lol how come i didnt work that out :S

rincewind456

Pinkmischief wrote:
If i change it to this it should work then

$sql = "select * from drivers where os=" . $POST['keyword'] . " and manufacturer='" . $POST['keyword'] . "'";

I realised what you meant by id lol how come i didnt work that out :S

No but this might

$sql = "SELECT * FROM drivers 
WHERE os= '". $_POST['keyword']."' 
AND manufacturer='" . $_POST['keyword'] . "'";

But that will only work if os AND manufacturer are the same

Pinkmischief

$sql = "SELECT * FROM drivers 
WHERE os= '". $_POST['keyword']."' 
OR manufacturer='" . $_POST['keyword'] . "'";

And i guess this will search for either manufacturer or os which matches the keyword.

Pinkmischief

Ok i changed the code to this so it gives me either a message saying cannot search

<?
	if (isset($Submit)){
$sql = "SELECT * FROM drivers 
WHERE os= '". $_POST['keyword']."' 
OR manufacturer='" . $_POST['keyword'] . "'"; 
$query = mysql_query($sql); 
while ($row = mysql_fetch_array($query)) {  echo "<p>",$row['os'],": ",$row['manu']; }}else{ echo " could not search!";}
?>

I just get could not search i am thinking do you think it could be it cannot access the database even though all the variables are declared in connections/connect.php?

If so would i have to place a connection script into the search page which incidentally is going to display the results under the search facility?

Pinkmischief

I put that theory to the test using a variable for require_once

<?php $require = require_once("Connections\connect.php");
if (!$require){echo "could not find db or connection";}else{echo "connection established and db found!";}?>

The result came out that it found db and connection. so i guess db connection is not a problem :S

rincewind456

It depends what's in your connection page, but you should have something like this

$user = 'xxxx';
$pass ='xxxx';
$db = 'xxxx';

$conn = mysql_connect( "localhost", $user, $pass );
if ( ! $conn )die( "Couldn't connect to MySQL" );

mysql_select_db( $db ) or die ( "Couldn't open $db: ".mysql_error() );

Have you tried the query through phpMyadmin or the command line to see if it works

Pinkmischief

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connect = "localhost";
$database_connect = "xxxx";
$username_connect = "xxxx";
$password_connect = "xxxx";
$connect = mysql_pconnect($hostname_connect, $username_connect, $password_connect) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

That is connect.php and i havent tried using phpmyadmin sorry i have very vague idea of how to run querys through phpmyadmin. I will have a go at doing that.

rincewind456

Pinkmischief wrote:
I put that theory to the test using a variable for require_once
<?php $require = require_once("Connections\connect.php");
if (!$require){echo "could not find db or connection";}else{echo "connection established and db found!";}?>
The result came out that it found db and connection. so i guess db connection is not a problem :S

All that proves is that you have a $require with a value set

Pinkmischief

lol omg i thought it wouldbe like a test so if the variable $require failed it would say there was no connection lol