I was reading through book on using password function for user input and did some research and many here say it is not good to use. Anyways, I got the MD5 function working for my encryption method...
[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 new to normalizing and many-to-many relationships in MYSQL but I am trying to change my bad habbits of table structure.
I kind of guessed my way through my first problem and its all working...
[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'm a little confused about auto_increment. I fully understand it and what it does, but is it a good or bad thing? I used to think it was standard to put it on every table with an 'id' field, but ...
[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
If your site uses MySQL database, this detailed article discusses how to quickly set up and verify a backup process for MySQL within 15 minutes (using open source Zmanda recovery manager)
...
[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 a post in the PHP forum that kind of describes my problem.
PHP Forum
I have a MySQL database that has 380 fields and in between 200 thousand and 1 million records. The database is a...
[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
How do you sort by a particular column (such as date) for fulltext search results? (example table:
id
url
category
blurb1
blurb2
date
...
[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, I need help,
How do I move the contents from one table to another table in the same
database. ie the contents of "cart table" to "orders table" thus removing the
cont...
[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
Please take a moment to review and comment on our new design. There may be a few bugs but we are diligently working through them....
[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 cant figure out what is wrong with this query, it is coded in php.
PHP Code:
$insert = "INSERT INTO formquestions (order,qtext,qtype,required) VALUES ('$iorder','$iqtext'...
[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
Before I begin, can I just state I have never installed anything on Linux server, so I am very new to this...
Okay at the mo I have and using MYSQL version 3.23.58 on my Linux Sever, incase t...
[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,
I have tried this query on my local server and it works perfectly, anyway after i tried it on phpmyadmin 2.7.0-p version it didn't work
Code:
$select="select download_id, down...
[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
This is probably a really dumb question but have to ask as it's driving me nuts. I've got the volume switched off on my laptop so you wouldn't expect any noise out of it. When I'm typing MySQL com...
[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
In mysql mysql-4.0.15:
When I try to store the string "Benefactors;Deus for 2006;&euro 20", it stores
"Benefactors;Deus for 2006;€ 20" . I guess MySQL is interpreting &...
[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
For a gallery I'm trying to query for a picture by its id and also get some images before and after that id (according to current sort) are there references like DOM previousNode or stuff lik...
[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
As many of you know, the past few weeks haven't been easy with all the problems and bugs on the site. As a way of fixing everything once and for all, we decided to wipe the system clean and start a ne...
[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 cannot seem to properly optimize this statement used to show topics across all forums that have been recently replied to:
Code:
SELECT t.topic_id, t.topic_title, t.topic_sticky, t.top...
[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 not really sure how to explain this one.
I wrote a reate me script. One tha tallow syou to add a photo and leave comments for a photo. What I want to do is allow the admin to search thoru...
[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
Very simliar to my Conditional Join thread, I would like to combine two queries that have different WHERE clauses. Basically when looking for an item, it could be in one of two formats: Vendor-Co...
[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 a script that is going to be creating max 7000 rows/day (2,555,000 rows per year) into my mysql database. The data stored is really nothing...just some numbers.
What limits might i face...
[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
edit - found the answer.
thanks.
...
[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
Table Users(login VARCHAR(50),birthday DATETIME)
I would like to compute in how many days user has a birthday. I read topic about select user with birthday in next 7 days . I used this query:...
[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 am experiencing some problem from one year, its a strange one very difficult me to tell but i have tooo let me try
huh
Problem
i when feed data in database(mysql) from a GUI whic...
[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 need an order by clause on a roles table that has the role and also if it should be ordered first. So what I gotta do is order by the field menu = true then by the field id. The menu field tells...
[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
After reading my favorite Website.
http://dev.mysql.com/doc/refman/5.1...-functions.html
I didn't see where I could add a date_format to return PM and AM as lower Case.
Since the Query i...
[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,
i am working on a site which has an existing user table of site users (site_members). i am creating a new section to the site which will only be accessible to a subset of users. it is not ...
[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 
