Okay hello I am trying to create a project for my advanced database course. I am trying to run like a online supplement store and I am having trouble with getting PHP admin to show my database. This is the table that I created and it wont show the data that I have entered in my insert value code.
{<?php
$host=“localhost”;
$username=“root”;
$password=“mysql”;
$db_name=“firstdb”;
mysql_connect("$host","$username","$password") or die(“Cannot connect”);
mysql_select_db("$db_name") or die(“Cannot select DB”);
mysql_query(“CREATE TABLE tstudents(id INT NOT NULL, PRIMARY KEY(id),fname VARCHAR(50),lname VARCHAR(50),credits DECIMAL(10,2))”);
?>
thanks for any help