Re: passing variables to a sql statement

On Sunday 19 January 2003 03:50, jennifer wrote: > hi, i'm hoping someone can help me out here - im trying to pass a variable > from a string in the href tag, however my sql breaks when i put a var in > the statment. when i replace $foo with a number, the page works fine. can > someone please tell me what im doing wrong? Do you mean $foo or $foobar? In the URL below it seems as if you really mean $foobar? And please give an example of where $foo (or $foobar) passed in the URL doesn't work. > here is the error i get: > > Warning: Supplied argument is not a valid MySQL result resource in Search the archives to find out the common causes of this error (it's an __extremely__ FAQ). Read up on the uses of mysql_error(). > here is my code: > > <?php > $hostName="localhost"; > $userName="xxxx"; > $password="xxxx"; > $database= "projects"; > $tableName="project_descrip"; > > $descripQuery = "SELECT descrip from project_descrip where rowid=$foo"; > mysql_connect($hostName, $userName, $password); > $descripResult = mysql_db_query($database,$descripQuery); > while($row = mysql_fetch_object($descripResult)){ > > $foo = $row->descrip; > > echo("<font face=verdana size=1>"); > echo("<a href='projects_descrip.php?rowid=$foobar'>" . > "$foo</a>" . " | "); > echo("</font>"); > > } > > > ?> -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* There is something in the pang of change More than the heart can bear, Unhappiness remembering happiness. -- Euripides */