MySql query help

[luckyrye]

Hey,

I am trying to retrive information from a database using the
'Mysql_fetch_assoc' function, but the problem is.. it is just
one row of data from the table, not an array, so it generates an
error. What function do u use/ What do i need to do to just get that
one row?

thankx.

// error
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource in ********* on line 23
//

<!-- my code segment !-->
<?
query = "SELECT * FROM users WHERE user =
'user' LIMIT 1";
result = mysql_query(query);
record = mysql_fetch_assoc(query);
{
fname = record["fname"];
lname = record["lname"];
mname = record["mname"];
position = record["position"];
}
?>
<!-- end my code-->




----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
[url]http://www.phpfreaks.com[/url]
[url]http://www.phpfreaks.com/forums[/url]

[Chris Hope]

luckyrye wrote:

> I am trying to retrive information from a database using the
> 'Mysql_fetch_assoc' function, but the problem is.. it is just
> one row of data from the table, not an array, so it generates an
> error. What function do u use/ What do i need to do to just get that
> one row?

From your example this is wrong:

$result = mysql_query($query);
$record = mysql_fetch_assoc($query);

It should be like this:

$result = mysql_query($query);
$record = mysql_fetch_assoc($result);

--
Chris Hope
The Electric Toolbox - [url]http://www.electrictoolbox.com/[/url]

[luckyrye]

Ooops, i get careless sometimes. sry bout that.



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
[url]http://www.phpfreaks.com[/url]
[url]http://www.phpfreaks.com/forums[/url]