Search results

Hi, Im trying to do a query using php and access, Basically, the link to the page will be , index.php?company=COMPANY! So what i want it to do is go into the table for that company and average out ratings which people have inserted. I have tried this but no luck. SELECT...

thanks alot for your help. I realised you can just call a query as if it was a table :D

Hey guys, I am trying to setup a "table creation" script. The line im working on is : $sql = "CREATE TABLE $company (id INT(3), customername TEXT, rating TEXT, customer_email TEXT, comments TEXT, status NUMBER)"; But its returning an Error. What i want to do is have "id" set as primary key and...

Hi thanks for the quick reply. How do i show the value of the query in a web page coded in php?

Hello, Right guys, new to access but have experience with MySQL. Basically, i have one table with a few fields, ID, Customername, Rating, Customer_email, Comments, Removalcompany. I created a query to get all of the ratings from that table, and average them. What i want to do now is put that...