Hi,

hte first part after WHERE is the column name of your db.
if you want to search with name as a criteria you write:
selelct name, nickname from table where name=$name;

johannes

"Naga Sean" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I had a question here.
> How to pull up one database, and then view that row
> what I mean here is
>
> NO  NAME   AGE
> 1   JOHN   12
> 2   RYAN   23
> 3   JIM    42
>
> I want to take JOHN out from database using URL
> www.example.com/template.php?name=JOHN
>
> here is my coding so far, and I know it's wrong, But will make you guys
had the idea what I want to do.
> Thanks
>
> -----------------------------------
>
> <?php
> $db = mysql_connect("localhost", "user","pass");
> mysql_select_db("media",$db);
> $result = mysql_query("SELECT nickname,name FROM database WHERE
$myrow[2]=$name",$db);
> $myrow = mysql_fetch_row($result);
> ?>
>
>
> Your name $myrow[name], $myrow[age]
>
> _____________________________________________________________
> www.kaskus.com - FREE EMAIL SERVICE
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to