Cool, I didn't know  you could embed mysql_query(...) inside 
mysql_fetch_row(...).  That's kinda nice--I hate having a line each for 
1-connecting, 2-selecting, 3-querying, and 4-resulting.  I'll hafta try 
that.  Thanks.

Ryan

On Tue, 26 Feb 2002, Stewart Gateley wrote:

> First of all that should throw an error, correct syntax is mysql_result
> ($query, 0) meaning to grab the 0 index returned.
> 
> I am not sure about performance wise, however I dislike mysql_result
> since if nothing is returned then you get a runtime error. Instead I
> like to use
> 
> list($pd) = mysql_fetch_row (
>   mysql_query (
>     "select password
>     from users
>     where login = '$login'"
>   )
> );
> 
> Then you can test $pd without getting sql errors.
> 
> -- Stewart
> 
> --- Ryan Snow <[EMAIL PROTECTED]> wrote:
> > Hi, Im kinda new to this list.  Can anyone tell me what is the proper
> > way 
> > to interpolate my php variables into my mysql queries?
> > 
> > I've been trying $query = "SELECT password FROM users WHERE
> > login='$login'";
> > 
> > 
> > then:
> >  mysql_query($result);
> >  $pd = mysql_result($result);
> > 
> > but I get a message that says: "Supplied Argument is not a valid 
> > MySQL-Link resource"
> > 
> > any ideas, anyone?
> > 
> > -- 
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Greetings - Send FREE e-cards for every occasion!
> http://greetings.yahoo.com
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to