Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: TheGoodVibe
- Order by date
-
PHP Connecting to MSAccess 2010 db.
Ok. So the program now displays everything, which is good. Now my next issue, which hopefully will be easy. I used the following line of code to pull my word from the db: $word = mysql_query("Select * from CurrentWords order by rnd(words) limit 1"); I can tell its not working, but I am...- TheGoodVibe
- Post #9
- Forum: PHP
-
PHP Connecting to MSAccess 2010 db.
Ok. Sorry to have wasted your time, but apparently the issue became that the server Im developing on is a Unix server that does not support MS Access. Ive transfered the data to a MySQL db and it works well for the connect. Now i'm having different issues. Here is the finished program i...- TheGoodVibe
- Post #7
- Forum: PHP
-
PHP Connecting to MSAccess 2010 db.
Ok, I understand what you are doing. The only part that is confusing me me is the last part you showed me. [code] $result = odbc_exec($conn, "Select top 1 * from words order by rnd(id)"); $randomWord = odbc_fetch_into($result, $row) ? $row[0] : 'ERROR'; [code] Where is the variable $row coming...- TheGoodVibe
- Post #5
- Forum: PHP
-
PHP Connecting to MSAccess 2010 db.
This is the advantage of having a different pair of eyes. I can't believe that i missed that. Now, second questions. I have changed the conn file, but For some reason i still cant get the echo command to display the total number of words. Please help. Thanks- TheGoodVibe
- Post #3
- Forum: PHP
-
PHP Connecting to MSAccess 2010 db.
Ok, so I have this connection as a .php file: <?php echo ("Currently connecting to DB"); //Connect to DB $conn=odbc_connect('wordgame.accdb','','') || die ( "Error Connecting to the database"); //List of all words $sql1 = "SELECT * FROM words"; $rs1=...- TheGoodVibe
- Thread
- Replies: 10
- Forum: PHP
