Search Results

Showing results 1 to 19 of 19
Search took 0.01 seconds.
Search: Posts Made By: pritaeas ; Forum: Database Design and child forums
Forum: Database Design Aug 26th, 2009
Replies: 61
Views: 6,162
Posted By pritaeas
Ow damn. it should be:


switch ($type) {
case 'general': {
}
case 'quests': {
}
Forum: Database Design Aug 21st, 2009
Replies: 61
Views: 6,162
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
Yes. That should be all.
Forum: Database Design Jul 31st, 2009
Replies: 61
Views: 6,162
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
http://www.daniweb.com/forums/thread111092.html
Forum: Database Design Jul 2nd, 2009
Replies: 61
Views: 6,162
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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
Posted By pritaeas
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...
Showing results 1 to 19 of 19

 


About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC