[Resolved] table to array?

daf_cr

I have a table with links in, columns named link_id, link_desc, link_url, link_visited. how can i extract the data from link_id and link_url into an array called $links in the format of link_id => link_url? ive tried using extract($row) and have come up with nothing. this array shud contain all links in the database.

thanks in advance

Daf.

weekender

//connect to mysql
$connection = mysql_connect($dbhost, $dbuser, $dbpass);
//select table
mysql_select_db($dbname);
//set sql
$sql = "SELECT * FROM tablename WHERE 1";
//do sql
$result = mysql_query($sql);
//get each row as an associative array
//each time you go through this loop it will get another row
//until there are no more
while($links = mysql_fetch_assoc($result)){
    //now you have vars in array, like $links['link_id'], $links['link_desc']
    //extract the array into the symbol table
    extract($links);
    //you now have the vars for this row
    echo $link_id . " - " . $link_desc;
}

geddit?

adam

daf_cr

that just makes me more confused, however i have come up with something, havnt tried it yet cos im trying to extract one value which just aint happenin!

mysql_select_db("dafsplace");
$link_visited = mysql_query("SELECT link_visited FROM dp_links WHERE link_id=$l")
	or die ("its dead jim");
echo $link_visited;

that just echos: Resource id #7
how can i get it to echo the value in the database?

anyway, theory on the array thing, u can set an array using normal variable params:

$NewArray['0'] = "NewValue";

would it work having the loop do:

$NewArray[$links['link_id']] = "$links['link_url'];

Thanks

Daf.

weekender

ok first q

mysql_select_db("dafsplace"); 
$link_visited = mysql_query("SELECT link_visited FROM dp_links WHERE link_id=$l") 
    or die ("its dead jim, but not as we know it"); 
//$link_visited is just a resource - a pointer to a result, so this won't give what you want
echo $link_visited;
//you have to fetch the row as an associative array
//associative just means the keys int the array ($array[key]) will be the field names, not a sequential number
$links = mysql_fetch_assoc($link_visited);
//then you have the array $links, containing keys 'link_id', 'link_desc' etc

nb this will only return one row - to fetch all, use a while loop like in my previous post

q2 - from the above code, you can now create an array

i am not great at creating arrays in one, but step by step you'd do it like this

//remember this follows on from above code
$link_array[$links['link_id']] = $links['desc'];

hope that helps?

daf_cr

mysql_select_db("dafsplace");
$link_visited_ = mysql_query("SELECT link_visited FROM dp_links WHERE link_id=$l")
	or die ("its dead jim");
$links_array = mysql_fetch_assoc($link_visited_);
$count = ++$links_array['link_visited'];
mysql_query("UPDATE dp_links SET link_visited = $count WHERE link_id=$l")
	or die ("its definitly dead jim");

I got that to work 6 times and now it just dies after the first query.. i dnt have a clue why! can u shed some light on the matter? im thinking my mysql server is playing up!

Daf.

daf_cr

aha i got it right now, its just i put no protection in if there wasnt a value for $l.. all done now, cheers!

Daf.