mysql help Table '*****.categories' doesn't exist

[spleblem]

hey all thanks for reading

i have purchased this game website script and im having a bit of trouble setting it up

i receive this error

 

Table 'spleblem_games3.categories' doesn't exist

 

im not sure why the .categories is there as the tables name is just spleblem_games3

 

 

thanks in advance for any help.

 

[Oldiesmann]

"spleblem_games3.categories" means it's trying to look for a "categories" table in the "spleblem_games3" database. Can you post the code you're using?

[spleblem]

oh right then

 

ive tried posting the script but it seems to big to work.

maybe you could have a look at the site

http://spleblem.5gbfree.com/games3/admin/index.php

 

the username and password are both admin.

[Illusion]

atleast you need to post ur new.php code

 

and make sure that database names and table names are matched.

 

these are the couple of statements ,can help u

// to ge the databases list, check whether spleblem_games3 exist or not

>show databases;

if it is there then

>use spleblem_games3;

to ge the lst of tables in the database

>show tables;

 

[spleblem]

right here is the new.php script

<?php
include "../conn.php";
session_start(); 
if(!isset($_SESSION['username'])  &&    !isset($_SESSION['password'])){
header("Refresh: 5;url=index.php");  
echo "You are not logon password is required to access this file...";
exit;
}


$sql = "select * from categories order by cName";
$rec=mysql_query($sql,$db) or die(mysql_error());
$datas = mysql_fetch_array($rec);

do{
$cats .= "<option value='$datas[cId]'>$datas[cName]</option>";
}while($datas = mysql_fetch_array($rec));

$displaytxt = "<form method ='post' action='savenewgame.php' enctype='multipart/form-data'>
Category List :
<select name='category'>$cats</select><br>
Game Title : <input type = 'text' name='gametitle' size='30'><br>
Game Description <br>
<textarea name='description' rows='12' cols='60'></textarea><br>
Thumbnail : <input type='file'  name='gamepic' size='20'> <br>
Game            : 
<input type='file'  name='gamefile' size='20'>
<p> 
<input type='submit' value='Add this game' name ='submit'>

<br>
</p>
</form>";

include "template.php";
?>

 

hope this can help you help me.

[Illusion]

did u tried the above statements I have given to check the database and table availability.

[spleblem]

yes but im not to sure on how to do that.

[Illusion]

do that using mysql prompt.

[spleblem]

alright and sorry

but what is that and where can i find it/use it

sorry about having no clue, ive been making/design websites for years

but now im getting in to sql databases.

[fenway]

Sounds like you're not connected to the db.