There is a working demo in the thread i posted on the previous page.

http://www.daniweb.com/forums/thread224758.html

You can remove the require(tools), it's something from the other guys code.

You shouldn't have changed "image" into "Picture".

I have a very busy week this week, so I haven't got around to...

A blob field is just binary data, which in your code gets displayed as text. The most easy way would be to create a separate php page that retrieves your image and displays it. I have an example of...

It would be something like this. I assume you have a column 'id' in your tables that identifies each separate record.


<table>
<?php
$db_link = @mysql_connect('localhost', 'username', 'pass')...

Something like this:


<table>
<?php
$db_link = @mysql_connect('localhost', 'username', 'pass') or die(mysql_error());
@mysql_select_db('wowtahc1_achievements') or die(mysql_error());

...

If you output your name and description like this:

<table>
<tr>
<th class="title">name</th>
</tr>
<tr>
<td class="description">description</td>
</tr>
</table>

Can you give me a specific example ?

Ow damn. it should be:


switch ($type) {
case 'general': {
}
case 'quests': {
}

Don't know the structure of your tables, but I think you could create a join between the two, thus creating a unique_email column and a shared_email column. You can then use an IF to select the right...

Try this:


<?php
$db_link = @mysql_connect('localhost', 'username', 'pass') or die(mysql_error());
@mysql_select_db('wowtahc1_achievements') or die(mysql_error());

$type =...

basically you get the link on the side to be:

<a href="http://www.wowtah.com/achievements.php?type=general">General</a><br/>
<a...

Yes. That should be all.

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...

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...

If the software is used only in-house, I don't see the need of using a webserver (asp/asp.net/php). I'd choose the C# option.

As promised.

http://www.pritaeas.info/DaniWeb/AdminPanel.rar
http://www.pritaeas.info/DaniWeb/test.sql

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...

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...

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...

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...

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:
...

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...

http://www.daniweb.com/forums/thread111092.html

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...

This will print just one column name:


while ($row = mysql_fetch_assoc($result))
{
// use your data
echo $row['column_name'] . '<br/>';
}

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...

Absolutely true, and I agree. My point was (didn't make it clear enough I think) that the 1-1 relation does not by definition need to be made by the business logic. My preference is to enforce rules...

My guess is that they rely heavily on link tables. Suppose you have a dutch and american dictionary, they wouldnt be linked by using the same id (as you stated). Instead it would use a third table...

In my humble opinion, in this case you should still use the normalized version and add a unique key on the intermediate table, thus forcing one staffmember per department.

The solution with the...

You could use one int ID field and a second type field, which would indicate the type of transaction.

Looks like 602SQL is based on ANSI SQL which doesn't support auto increment. Best to ask this at 602SQL support.

Those are country codes, he was asking for nationalities. My country is The Netherlands but my nationality is Dutch. Also, the nationality is different in each language. This is probably the reason...

AFAIK there is no ISO table for nationalities.

Check out the new browser Kirix Strata. It is designed to gather and store information from the internet. It's quite useful. (http://www.kirix.com/) You could write a bot, but I think you can better...

Normally I'd recommend completely normalizing your tables. It would be overhead (as you stated) when you start out and may seem inefficient. However, note that maybe some day your need to extend your...

in MySql there is the LOAD DATA INFILE command. Perhaps PostGre has support for it.

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...