Search the Community
Showing results for tags 'sybase'.
Found 1 result
-
I'm trying to connect to Sybase IQ and just display two columns of a table. When I try to view the html page it shows some of the php code (attached). The code is below. I'm still a noob, especially to the sybase iq part . I have also verified that the dll exists in the php/ext directory and that it is uncommented in the php.ini . I have stopped and started Apache as well after I uncommented the dll from php.ini. <html> <body> <?php $con = sybase_connect("X","X","X"); if (!$con) { die('Could not connect: ' . sybase_set_message_handler()); } sybase_select_db("X", $con); $query = sybase_query("SELECT provider_full_name, provider_id FROM crr.provider_dim"); echo '<center>'; echo '<table border="1" cellspacing="0" cellpadding="10">'; echo "\n<tr><td bgcolor='#CCCCCC'>Full Name</td><td>Provider_ID</td></tr>\n"; while($row = sybase_fetch_array($query)) { echo "\n<tr><td bgcolor='#CCCCCC'>".$row['provider_full_name']."</td><td>".$row['provider_id']."</td></tr>\n"; echo "<br />"; } sybase_close($con); ?> </body> </html>
