Re: variable interpolation in mysql queries
| From: | Bogdan Stancescu | Date: | Tue, 26 Feb 2002 22:32:00 +0000 |
| Subject: | Re: variable interpolation in mysql queries | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17316@lists.php.net to get a copy of this message | ||
PS. You should consider using mysql_fetch_row() or at least mysql_fetch_array() for perforance reasons.
B
Bogdan Stancescu wrote:
$query="query"; $result=mysql_query($query); $pd=mysql_result($result); Notice the zig-zag - $query is first on the left side, then on the right side, then $result is first on the left side, then on the right side. Bogdan Ryan Snow 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?