[Resolved] Textbox query then display

fredbloggs

Dear all,
I am trying to figure out the code needed to search the DB for a name (textbox input) and then display the record with that name.
This is the form so far:

<?php if ( isset($name) ): ?>

<P>Your name: <?php echo($name); ?></P>
<P>This paragraph contains a
<A HREF="newpage.php?name=<?php echo(urlencode($name)); ?>">
link</A> that passes the name variable on to the next document.</P>

<?php else: ?>

<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD="GET">
Name : <INPUT TYPE="TEXT" NAME="name">
<INPUT TYPE="SUBMIT" VALUE="GO">

</FORM>
<?php endif; ?>

I guess it should be something like this with an if / else:

$stmt = mysql_query("SELECT * FROM teilnehmer WHERE $name LIKE '%$search%' ");

can anyone help?

thoand

check your SQL, it should be, you are here passing the variable to
the SQL var,

SELECT * FROM teilnehmer WHERE $name LIKE '%$search%'

correct:
SELECT * FROM teilnehmer WHERE name LIKE '%$search%'

thomas a

thoand

I guess you have to do the usual loop to 🙂, inside

<?php if ( isset($name) ): ?>
<?
// Do looping ...
?>

fredbloggs

Thanks for the tips 🙂