TalkPHP
Home Forums Articles Glossary Awards Register Rules Members Search Today's Posts Mark Forums Read
 
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
by awuehr on 11-10-2008 in Tips & Tricks
» Vulnerable methods and the areas they are commonly trusted in.
by Village Idiot on 11-04-2008 in Classes & Objects
» Simple way to protect a form from bot
by codefreek on 10-23-2008 in Basic
» The Basics On: How Session Stealing Works
by wiifanatic on 09-12-2008 in Security & Permissions
» How to keep your forms from double posting data
by drewbee on 07-03-2008 in Tips & Tricks
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
TalkPHP > Search Forums » Search Results
Showing results 1 to 9 of 9
Search took 0.03 seconds. Search: Posts Made By: macov
Forum: MySQL & Databases 01-03-2008, 03:39 AM
Replies: 6
Views: 2,128
Posted By macov
Shouldn't be item_id removed from "GROUP BY" and...

Shouldn't be item_id removed from "GROUP BY" and "SELECT"?. When you try to COUNT item_id, you should list all columns (e.g., votes.poll_id votes_pollid, itmes.* in the GROUP BY (with an exception...
Forum: MySQL & Databases 12-30-2007, 06:19 AM
Replies: 3
Views: 975
Posted By macov
The question is if you should do a cascading...

The question is if you should do a cascading delete. Just think. You have a blog, users post comments to your articles, and if an user account is removed should all his/her comments be deleted? It...
Forum: MySQL & Databases 12-30-2007, 04:22 AM
Replies: 12
Views: 1,313
Posted By macov
Whatever it is, don't use it... I suggest...

Whatever it is, don't use it...

I suggest DBDesigner 4

fabFORCE.net (http://fabforce.net/dbdesigner4/)
Forum: MySQL & Databases 12-29-2007, 10:40 PM
Replies: 12
Views: 1,313
Posted By macov
Still there are missing the descriptions of...

Still there are missing the descriptions of relationships. Looking at your model, I don't know what kind of a reletionship is between USER and CONTENT.

Is a user creating a content, reading,...
Forum: MySQL & Databases 12-11-2007, 09:46 AM
Replies: 18
Views: 2,887
Posted By macov
It is really hard to comment until it will be in...

It is really hard to comment until it will be in the graphic form and relationships between entities will be presented. I suggest using DBDesigner 4 (http://fabforce.net/dbdesigner4/)
Forum: MySQL & Databases 12-10-2007, 04:37 PM
Replies: 18
Views: 2,887
Posted By macov
Make yourself familiar with the idea of...

Make yourself familiar with the idea of session.

IP changes everytime user log in, therefore you will need a table 'sesssions' (id, users_id, ip, etc..) to manage their activities.

A table...
Forum: MySQL & Databases 12-10-2007, 11:41 AM
Replies: 18
Views: 2,887
Posted By macov
It is always good to have a business...

It is always good to have a business requirements. Why are you keeping ip address in the user column? IP will be changing everytime an user will be logging. The salt will be the same for each user?...
Forum: MySQL & Databases 12-02-2007, 02:02 PM
Replies: 29
Views: 1,968
Posted By macov
I don't use SQLYog, but HeidiSQL is a really nice...

I don't use SQLYog, but HeidiSQL is a really nice tool for development.
Forum: MySQL & Databases 11-28-2007, 12:03 PM
Replies: 29
Views: 1,968
Posted By macov
HeidiSQL, really nice and...

HeidiSQL, really nice and freeware.

http://www.heidisql.com/
Showing results 1 to 9 of 9

 

All times are GMT. The time now is 11:34 PM.

 
     
Contact Us - TalkPHP - PHP Community - Archive - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design