pane_id-mediumint(9),
pane_info-test,
pane_name-varchar(20),
pane_location-mediumint(9)
Now i can't access the table with:
Code: Select all
<?php
<?php
$linkID = mysql_connect("localhost","username","password");
if ($linkID != false){print "The connection to the CLAN has been made";}
else{print "No connection dumb @ss";}
$dbID = mysql_select_db("CLAN", $linkID);
if ($dbID != FALSE){print"Connected to DB";}
$resultID = ("SELECT * FROM table, $linkID");
if ($resultID != FALSE){print "okay";}
else{print "doh!";}
?>
?>I've tried searching these forums and looking at all the tutorials but it always seems this part gets left out cause it is so simple.It comes back saying that the query was unsuccessful "doh!"
Finally once i'm finally able to access this file can I use something like this to hold the information:
Code: Select all
for ($tableNum = 0; $tableNum < mysql_num_rows($resultID) ; $tableNum++){
list($pane_id,$pane_info,$pane_name,$pane_location)=mysql_fetch_row($result);
//put in the rest of code here