Kia Ora
The following script is designed to welcome back a previously logged on user
But
I am little stuck as to why i cant get the $last_login variable to work the row exsists in ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi guys,
I hope you can help ... this one has me stumped.
I have a list of currency transactions made by users. I need to generate a list of users along with their transaction total (sum ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am using now function to get current date when info is added to my table. I am using a hosting provider that is 6 hrs ahead in time zone so i always have to subtract 6hrs to get the correct time...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Does anyone know how to setup a database linked to a website please ? I would like to setup a database so that when someone fills in their first name and email address to receive newsletters, it...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I've been struggling with finding the best way to get similar data from two tables sorted and returned.
To simplify things, I need `id` and `dateAdded` returned from t1 and t2, sort...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Looking for suggestions on how to auto increment a field based on a field from an outside table.
For instance, if InvoiceNo is in InvoiceTable and CompanyName is in CompanyTable, would like to...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hola database type folks,
I have been trying to get this right for sometime but now must admit defeat
I have 3 tables
artists -> holds details on the artists
card_gallery -> h...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
One database provides a list of items to be used in a query against another database's table. The two different database are on two different servers.
Can I get the list from one query and us...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi...
do someone maybe know where can i find some free software to see mysql diagrams?
any suggestion appreciated...
thanx in advance...
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Is it possible to view an E-R diagram within MySQL? (As in Relationships in Access)
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello to all you db gurus...
Im looking to merge two tables in my db (or more specifically, insert one's values into the other). This post is pretty helpful for how to set up the merge, but my...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I've seen this asked before and although someone answered that it is possible, they did not post the solution, so if anyone can enlighten me that would be helpful.
Basiclly with table info
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
SQL Edge is a universal SQL query tool that allows users to execute SQL queries, browse schema information in ER diagrams, and visualize data relationships. With SQL Edge, users can use only one q...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I have a simple CMS and I am wondering what is the correct way to categorize articles in a database. I have a main articles table, like so:
Code:
CREATE TABLE articles (
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Well, I've gotten a DB that I made to keep track of inventory. Its got a couple of tables, but the one thats giving me greif is the "changes" table. Here is the makeup of it ....
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
i have this sample table:
studid varchar(10)
name varchar(40)
address varchar(40)
in which i queried and displayed list of students, what i wanted to do was disp...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
so a bunch of results are grabbed from the DB matching my query (each with a unique ID) and i'm paginating them with a limit of 20...
if i know the ID of a specific result i want to go to, is ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi people
I have a php application which successfully connects to mysql and interacts with the database.
I am using apache as my web server.
I would like to invoke my code from the comma...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
situation:
a user wants to change their username on my site and their username is littered accross many tables in the DB. If in every one of those tables i've got a static "user_id" c...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have two questions. One pertaining to the proper structure of my database and the other to the way MySQL handles dates.
1) I am setting up a database with personnel information on employee...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
When some one use the term cluster saying ' we have two clusters one here one in some other city' what do they mean by that? , is cluster is like copy of a database at different locations ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I can't remember having this problem before, but when I try to insert a new row into my database, it throws an error when it gets to a column name that has a space in it. Is there any way to reso...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have to filter a query by the first letter in its name. I have a menu that looks like this:
A-E | F-J | K-O | P-T | U-Z
How would I gather, for example, records that start between A and ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I can query my MySQL database with any SELECT, UPDATE, DELETE, etc. queries, and it works perfectly, but when I try to do a LOAD DATA INFILE query, I get a permissions problem. Any ideas why this...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Using LIKE='%Gates Bill%' in a column containing 4 rows:
1. Bill Gates is the man who owns the money of the world.
2. Billy the Kid shot and robbed a dozen banks, killing 42 and injuring 4...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
