Hi
I'm working now with PHP + Microsoft SQL Server, but it's kind of easy, because the functions are much like the mysql ones.
Anyway, I have now a problem. I have a query like this:
SELECT * FROM client ORDER BY client_name
Everything goes right in the MS SQL Query Analyzer, it returns me ALL rows and fields from that table, but when i do it in php, it seems that the '*' wildcard doesn't work...
PHP Code:
//In mysql I use either mysql_fetch_array , mysql_fetch object or mysql_fetch_row
$query_clients="SELECT id_cli,client FROM client WHERE client LIKE 'g%' ORDER BY client";
$result_clients=@mssql_query($query_clients,$con2);
if(!$result_clients)
echo "<br />Error. ".mssql_get_last_message()."<br />";
while($obj=mssql_fetch_object($result_clients))
{
echo "<option value='".$obj->id_cli."'>".htmlentities($obj->client)."</option>\n";
}
As you see, I'm filling a select item with the query results and everything goes right, but when I do the same with the '*', it returns the select item like this...
Code:
<select name="select_client">
<option value="--">SELECT A CLIENT</option>
<option value=""></option>
<option value=""></option>
<option value=""></option>
.
.
.
<!--It repeats the line 'msssql_rows_affected' times-->
I can do this by only selecting the fields that I need, but my doubt is, why does '*' not work???
Thanks
Before you post, read our: 
