Jump to content

clydeshire

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

clydeshire's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I have a client who needs a portal web page built so their clients can access limited information from their database. The unfortunate part is the program they are using (and don't/won't replace), uses ACCESS as it's database. My ODBC connection works great. My problem comes when I try to retrieve information from a field name that has a space in it, i.e. Patient Number. I can't change the field names and no matter what I use to enclose it (`,', or "), it doesn't seem to work. I get the "no tuples..." error message. Is there anything else I can try to solve this situation? Thanks for your help. <?php $conn=odbc_connect('patton','','','SQL_CUR_USE_ODBC'); if (!$conn) {exit("Connection Failed: " . $conn);} print('<html> <head> <title>PHP and MS ACCESS</title> </head>'); print('<body>'); print('<table align="center" width=90%>'); print('<tr><th>CardID</th><th>CardName</th><th>Type</th> <th>Expire</th><th>Number</th><th>Credit</th><th>Phone</th> <th>Address</th><th>City</th><th>State</th><th>Zip</th></tr>'); if($conn) { $sql="select * from Patient where `Patient Number`='1'"; $row=odbc_exec($conn, $sql); while(odbc_fetch_row($row)) { $cardid=odbc_result($row,1); $name=odbc_result($row,2); $type=odbc_result($row,3); $expired=odbc_result($row,4); $card_num =odbc_result($row,5); $credit =odbc_result($row,6); $phone =odbc_result($row,7); $address =odbc_result($row,; $city =odbc_result($row,9); $state =odbc_result($row,10); $zip =odbc_result($row,11); print('<tr><td>'.$cardid.'</td><td>'. $name.'</td><td>'.$type.'</td><td>'.$expired.'</td><td>'.$card_num.'</td><td>'.$credit.'</td><td>'. $phone.'</td><td>'.$address.'</td><td>'.$city.'</td><td>'.$state.'</td><td>'.$zip.'</td></tr>'); } } print('</table>'); print('</body>'); print('</html>'); ?>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.