[Resolved] help with odbc mdb

[[deleted]]

I've got a pretty good handle on php but when it comes to databasing with it I’m lost.
I'm using odbc to access my mdb file, which is working fine. I've the connection open/close part down. Now I'm trying to access a DB with several tables, with several rows in each table. The commands to read certain rows or parts of rows and stick them into php variables is confusing the hell out of me. Any basic explanations and/or examples would help me out a lot. Or maybe just a really good basic tutorial on mdb/php 'cause I’m having trouble finding one that’s not about mySQL or just a little over my head.

[TTT]

talking about mdb or mysql??

[[deleted]]

mdb

[TTT]

problem is with queries? can you specifie what kind of samples you need... simple select, inner join, outer join, neested queries ... ?

[[deleted]]

I'm trying to query(?) a table with 5 values in each row: pointer(text), title(text), size(number int), and info(demo). I want to insert the values of each into corresponding php variables. Also how do I specify the row in the table?

I've got to get to sleep. I hope I've provided enough info for now.

[TTT]

$q=mysql_query("SELECT pointer,title,size,info FROM yourTable",$conn_id);
... specify row .... WHERE id = $yourValue

while(odbc_fetch_row($q)) {
odbc_result($q,0); // = pointer ....
}

[TTT]

.

[[deleted]]

bomb thanks a lot!

[[deleted]]

I'm still having some trouble if anyone can help. Heres the code I'm using

//connection to photo data base
$cnx = odbc_connect( 'photo' , ' ', ' ' );
if (!$cnx) { Error_handler( "Error in odbc_connect" , $cnx ); }

$q=mysql_query("SELECT pointer,title,l,w,info FROM milk WHERE ID=$ID",$cnx);

while(odbc_fetch_row($q)) { 
	   $pointer = odbc_result($q,pointer);
	   echo "<a>$pointer</a>";
}

$pointer is still empty. Any ideas?

[[deleted]]

anyone?