View Single Post

  #3 (permalink)  
Old 01-28-2004
Tom Thackrey
 
Posts: n/a
Default Re: problem calling by unique id from database in php


On 27-Jan-2004, "Vincent J. Gullotta" <Vin@WiFidirect.com> wrote:

> a href=search.php?ID=",$i[0],"
>
> (I took out the greater than less than cause I don't know how it would
> show
> up in some news readers)
>
> my problem is that lets say ID=5
>
> it will call everything in my database with a 5 in the ID (ie. 5, 15, 25,
> etc.) Can anyone help me get passed this?


You need to show us the code. Assuming your SELECT is coded correctly and
you column is defined correctly, it only return the records with a id column
of 5
$sql = 'select ... where id='.$_GET['ID']; // I know about sql injection,
this is just an example

if you code "where id like '5' " you will have problems, but why would you
do it that way?

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to jamesbutler@willglen.net (it's reserved for spammers)
Reply With Quote