Re: Unable to connect Mysql via PHP from ODBC connector

[Michael De Villa]

Hi Peter,

Thanks for the responds, no but i'll try also your advise. by the way our programmer send me this script and somehow it works.


<?php
$mysqlcon=mysql_connect('172.16.1.105','root','root',false,65536) or die(mysql_error());
mysql_select_db('ssi') or die(mysql_error());
$queryResult=mysql_query("SELECT trans_num FROM cy_201405_header where trans_date=20140501 and register_num=1;");
while($row=mysql_fetch_array($queryResult)){
echo $row['trans_num'] .' '.'</br>';
}

?>


Many Thanks,

Mike