PHP & MySQL Select Error only selecting Numbers correctl

registered · Regular Joined: Dec 24, 2004 Posts: 56

U know those search boxes on alot of sites..

well i put one on mine.. the name of the search term box was... "term"

There are several choices from a drop down.

The page action is a page called search.php (go figure right... Laughing

)

That page has some query...

Select * from tablename where $term = $type

the type is chosen from the dropdown..

Very simple right... well when the query is for a number.. it works fine.. if it is for Alpha Characters it gives me an error.

The mysql table fields are set to Varchar(40) not number... so i dont know...

Anyone have a clue.. ?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Try
Select * from tablename where $term = '$type';

Posted: Wed Feb 22, 2006 11:38 am

Wow that was quick... ok so the lack of ' ' would case an error?

Trying right now.. thanks raven Smile

Posted: Wed Feb 22, 2006 11:41 am

Thank you so much man. Smile

Im going to add your banner or link to my site www.YourCodes.com now.

Not that its a huge site, but just as support. Thanks for the knoledge.

Worked great...

Posted: Wed Feb 22, 2006 11:43 am

Posted: Wed Feb 22, 2006 11:48 am

Heres the code for anyone else that may want to make a php-nuke block supporting the site.. Smile

<?php

if (eregi("block-raven_add.php", $_SERVER['PHP_SELF']))
{
Header("Location: index.php");
die();
}

$content .= "<center>

<a href='http://www.ravenphpscripts.com' title='PHP Web Host - Quality Web Hosting For All PHP Applications'><img src='http://www.ravenphpscripts.com/images/mylinks/RavenWebServices.gif' alt='' border='0' /></a>

</center>";

?>