Re: mixing and matching mysql & mssql whileloop within an if case

Thu, 03 May 2012 22:41:21 -0700

I suppose an easier way is to have a getrow function, Something like

while ($row = getrow($RS) {
.
.
.
}

function getrow($RS)

{
 if ($current_server_is_mysql)
 {
  return mysql_fetch_assoc($RS);
  }
 else
 { 
  return sqlsrv_fetch_array( $RS, SQLSRV_FETCH_ASSOC);
 }
}


On 2012/05/03 19:20, Haluk Karamete wrote: 
Please take a look at the following code and tell me if there is a way
around it.

if ($current_server_is_mysql):
    while ($row = mysql_fetch_assoc($RS)) {
else:
    while( $row = sqlsrv_fetch_array( $RS, SQLSRV_FETCH_ASSOC)){
endif:
Depending on the server I'm working with, I'd like to compile my
records into the $RS recordset the proper/native way. If I can get
pass this part, the rest should be all right cause both mysql and
mssql $row can be tapped into the same way. For example,
$row['fieldname'] will give me the field value whether the row was a
mysql or mssql resource. So it all boils down to the above snippet
failing.

The error I get points to the else: part in the above snippet.

Parse error: syntax error, unexpected T_ELSE in
D:\Hosting\5291100\html\blueprint\pages\populate_migration_table.php
on line 415
I can understand why I am getting this error.

But, I'm hoping you guys can offer a work-around it without me
resorting to duplicate the entire while loop she-bang.


--

Reply via email to