Results of Query

[neroag]

Hi All

i have a query that works for pulling all the rows from a table "categories"

 $qry2 = "SELECT * FROM " . $sql_tbl["categories"];

$result2 = db_query($qry2);

$categories = array();

while ($result_row = db_fetch_array($result2)){$categories[] = $result_row;}

I can then pull the data from the category field with

 foreach($categories as &$categorie){
	$categorie['category'] = $str_categories;
}

What im trying to do is pull the data from a different field in the same table field "seo-url" & not the "category" field. making the following change doesnt work

  foreach($categories as &$categorie){
	$categorie['seo-url'] = $str_categories;

}

can anyone help please?

Many thnaks

[NogDog]

I'm a bit confused. This does not "pull data from the category field":

foreach($categories as &$categorie){
   $categorie['category'] = $str_categories;
}

Rather, it assigns the value of $str_categories (whatever that is?) to every $categories[$n]['category'] element of the $categories array (where $n is the result row number).

[thereo]

Why dont you try:
$qry2 = "SELECT * FROM categories

$result2 = db_query($qry2);

$categories = array();

while ($result_row = db_fetch_array($result2)) {
$categories[0] = $result_row["variable name"];

$categories[1] = $result_row["another variable name"];

}

i know this may not be as complete as you like but you seem to be complicating things. Keep it simple and in logical steps

Hope ive helped