Forum: Database Design Aug 26th, 2009 |
| Replies: 61 Views: 6,162 Ow damn. it should be:
switch ($type) {
case 'general': {
}
case 'quests': {
} |
Forum: Database Design Aug 21st, 2009 |
| Replies: 61 Views: 6,162 Try this:
<?php
$db_link = @mysql_connect('localhost', 'username', 'pass') or die(mysql_error());
@mysql_select_db('wowtahc1_achievements') or die(mysql_error());
$type =... |
Forum: Database Design Aug 19th, 2009 |
| Replies: 61 Views: 6,162 basically you get the link on the side to be:
<a href="http://www.wowtah.com/achievements.php?type=general">General</a><br/>
<a... |
Forum: Database Design Jul 31st, 2009 |
| Replies: 61 Views: 6,162 |
Forum: Database Design Jul 31st, 2009 |
| Replies: 61 Views: 6,162 Look back in this thread, there's a link to it.
It's an sql file you need to execute to create the tables you need for the example.
If you've created the tables on your server and you uploaded... |
Forum: Database Design Jul 30th, 2009 |
| Replies: 61 Views: 6,162 These are smarty template files. (smarty.net). Iirc I put smarty in the zipfile.
The one other thing it needs is a database, which I put in test.sql
You will need to change the username and... |
Forum: Database Design Jul 14th, 2009 |
| Replies: 61 Views: 6,162 As promised.
http://www.pritaeas.info/DaniWeb/AdminPanel.rar
http://www.pritaeas.info/DaniWeb/test.sql |
Forum: Database Design Jul 14th, 2009 |
| Replies: 61 Views: 6,162 I have just written code for someone, that implements an account administration panel. It has a search tab, a detail view, a notes tab and a mass e-mail tab. The detail tab is a template which gets... |
Forum: Database Design Jul 13th, 2009 |
| Replies: 61 Views: 6,162 Most common method would be to use mypage?id=X on an item click. The page will use id to retrieve the data from the database and display it in your template. If you have spread your data over... |
Forum: Database Design Jul 10th, 2009 |
| Replies: 61 Views: 6,162 I can help you with php, but as far as i can tell, the hover information and some other stuff is javascript. I don't know much about that, as I always try to avoid using it.
The detail page in the... |
Forum: Database Design Jul 7th, 2009 |
| Replies: 61 Views: 6,162 As far as i can tell wowhead has one large item list on a single page, where at the top they jump down to a specific part (http://ptr.wowhead.com/?new-items=3.2). Everything here is already loaded... |
Forum: Database Design Jul 7th, 2009 |
| Replies: 61 Views: 6,162 Doesnt matter. I can understand your frustration. Create a table containing a blob field (not varbinary, my mistake). Then you can insert data in the table. I made a screenshot so you can see:
... |
Forum: Database Design Jul 6th, 2009 |
| Replies: 61 Views: 6,162 Probably misunderstood, possibly because english is not my native language, but I'm trying. Uploading an image through phpMyAdmin (in cpanel) can be done by using the choose file button, when you... |
Forum: Database Design Jul 5th, 2009 |
| Replies: 61 Views: 6,162 http://www.daniweb.com/forums/thread111092.html |
Forum: Database Design Jul 2nd, 2009 |
| Replies: 61 Views: 6,162 Glad to see you got it to work.
Images can be stored in a varbinary field, or you store the image on the server as file, and put only the filename as string in the db.
I'm not quite sure what... |
Forum: Database Design Jun 30th, 2009 |
| Replies: 61 Views: 6,162 This will print just one column name:
while ($row = mysql_fetch_assoc($result))
{
// use your data
echo $row['column_name'] . '<br/>';
} |
Forum: Database Design Jun 29th, 2009 |
| Replies: 61 Views: 6,162 You'll need a language to connect to them, for example PHP, Python, Ruby.
In PHP the code would look like this:
$db_link = @mysql_connect('localhost', 'youruser', 'yourpass') or... |
Forum: Database Design Oct 14th, 2008 |
| Replies: 7 Views: 1,074 You could use one int ID field and a second type field, which would indicate the type of transaction. |
Forum: Database Design Aug 3rd, 2006 |
| Replies: 5 Views: 24,343 The normalization is okay at this point.
Is this going to be a live system, or just a test ? Because if you want to book rooms, you'll need to know what rooms are available. Suppose a room cannot... |