to call up mySql data

Anon

hi all,

i have got a problem calling up my Sql data.I want to create a little search engine where the user could search(via textfield)for a handy. I've created the database with PhpMyAdmin.
I have a site with a textfield to write in the name and php should search in the database(NAME) if the content of the textfield is the same like the field in my sql-database. If it is the same it should be created another site with the result of the query.And else php should echo "no database found". I tried it with -> mysql_fetch_row but it doesn't work.....
Please help me, it is very important
Thanx...

amcgrath

select * from table where field like '%$user_info%'.... is that what you mean?

Anon

is $user_info the variable that describes the content of my textfield?

e.g:
<input type="text" name="user_info" value="<?php echo($user_info);?>">

In my site the user can search for the name of a mobile-phone and in my MYSQL-Database there is a field called NAME. If the user-input contains the same as the field in the database, i want to put out this data in another site. I have the problem that i can't get only one data.I'm always getting all the data from my MYSQL-Database...

thank u very much

amcgrath

Yes, $user_info is the contents of the text filed entered by the user.
Easier to do this <?= $user_info ?> than <?php echo($user_info); ?>
Paste the query and code here so I can better address your last problem.

Anon

thank u very much.. for helping..

NOW IT WORX : )