Foreach question....

The_Chancer

<?php
//duplicate enquiry from reference $ref
include("db.php");
$query=do_query("SELECT * FROM enquiry WHERE ref='".$_GET['ref']."'");
$enq=mssql_fetch_array($query);
foreach ($enq as $key=>$val)
{
	echo $key." and ".$val."<br>";
}
?>

Works and it gives me the keys and values....
But it comes out like

0 and 1942
ref and 1942
1 and C15767
clientref and C15767

Is there any way of getting just the keyname (e.g. ref) and the value (e.g. 1942) ?

[note]
The do_query function deals with all database connection and mysql_query included in db.php...
[/note]

The_Chancer

This does the trick....

$i=0;
foreach ($enq as $key=>$val)
{
	if ($i%2){echo $key." and ".$val."<br>";}
	$i++;
}

But it seems too ugly and clumsy...

Is there a better way ?

keith73

the mssql_fetch_array and mysql_fetch_array functions return both the numerical index and associative value (column name) of the query results.

use mssql_fetch_assoc instead. It's only avialable in php 4.2 or greater.
http://us2.php.net/manual/en/function.mssql-fetch-assoc.php

keith

The_Chancer

Ahhh - 5 letters that changed the world....

Array -> Assoc...

Many Thanks - situation resolved...