brain fart

[dmccabe]

Please help me out I am having a complete brain fart here:

 

	$aid = $_GET['aid'];
	$query = "SELECT * FROM `tbl_corpaccount` WHERE `aid` = $aid";
	$result = mysql_query($query);
	if (!mysql_query($query)) {
		die('Error: ' . mysql_error());
	}

	echo $query;

	$accname = $result['accname'];

 

$accname is never containing a value. but why?

 

I have run the query on my db and it works fine.

[atl_andy]

Don't you need to fetch the results first?

 

 

while($row = mysql_fetch_row($result) {
    echo $row['accname'];  // Or whatever you need to do with it.
}

 

Or you could use mysql_fetch_assoc or mysql_fetch_array

[Bladescope]

*tweak*

<?php
// ...

while($row = mysql_fetch_row($result)) {
    echo $row['accname'];  // Or whatever you need to do with it.
}

// ...
?>

[dmccabe]

hmmm... still nothing

 

	$aid = $_GET['aid'];
	$query = "SELECT * FROM `tbl_corpaccount` WHERE `aid` = $aid";
	$result = mysql_query($query);
	while($row = mysql_fetch_row($result)) {
		echo "1.".$row['accname'];

[Bladescope]

using mysql_fetch_row, use

$result[0];

 

as opposed to

 

$result['accname'];

 

Edit: If you're using that script and it's coming up with nothing, then it's your SQL query.

[clown[NOR]]

maybe this'll work?

while($row = mysql_fetch_assoc($result)) {

[dmccabe]

That makes no sense?

 

$result instead of row?

 

and I how do I pull a value from it?  $result[0]['accname'] ?

[dmccabe]

link=topic=190145.msg853500#msg853500 date=1206964366]

maybe this'll work?

while($row = mysql_fetch_assoc($result)) {

 

We have a winner

[clown[NOR]]

wow! what did i win?

[dmccabe]

A big thanks

[clown[NOR]]

woho your welcome