[PHP-DB] re:database tables relations advice

2008-11-27 Thread mrfroasty
I am quite new to database designs, I have a problem in my design...I can actually feel it, but I am not quite sure if there is a feature in mysql or I have to solve it with programming. Example: CREATE TABLE A ( user_id int(16) NOT NULL auto_increment,

Re: [PHP-DB] re:database tables relations advice

2008-11-27 Thread mrfroasty
be put in a single table.. the case is if you dont've many related tables.. pavan puligandla Microsoft has no beef with OpenSource. 2008/11/27 mrfroasty [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] maruti wrote: hii,, who said table with more no:of columns is a bad database

Re: [PHP-DB] re:database tables relations advice {solved}

2008-11-27 Thread mrfroasty
danaketh wrote: This is solved by using FOREIGN KEY but I'm not sure if MySQL have them present or just planned for some future release. mrfroasty napsal(a): I am quite new to database designs, I have a problem in my design...I can actually feel it, but I am not quite sure

[PHP-DB] re:store html codes in text field (mysql)

2009-01-07 Thread mrfroasty
Sorry if this has been asked before but I cant seem to find anything useful via google.. I have a text fields which stores my textarea input from a user, my design is meant to allow user to submit html codes...but mysql seem to replace all html tags with something else... Example: $title=some

Re: [PHP-DB] re:store html codes in text field (mysql)-SOLVED

2009-01-08 Thread mrfroasty
Chris wrote: mrfroasty wrote: Sorry if this has been asked before but I cant seem to find anything useful via google.. I have a text fields which stores my textarea input from a user, my design is meant to allow user to submit html codes...but mysql seem to replace all html tags

[PHP-DB] re:FOREIGN KEY{ERROR:1005/150}

2009-02-11 Thread mrfroasty
Hello, I have been browsing on mysql manual http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html with not much of success.I am trying to put 2 foreign keys(from different external table) on my table, but if I put the 2nd one it fails.here is my table CREATE TABLE

[PHP-DB] re:looking for SQL documentation tool

2009-03-04 Thread mrfroasty
Hello guysis there any tool that can create data relation from sql document?I have seen phpmyadmin, but still I am looking for other software to see what they have to offer... Thanks -- Extra details: OSS:Gentoo Linux-2.6.25-r8 profile:x86 Hardware:msi geforce 8600GT asus p5k-se

Re: [PHP-DB] re:looking for SQL documentation tool[solved]

2009-03-04 Thread mrfroasty
Thanks guys for the input...really appreciated :-) -- Extra details: OSS:Gentoo Linux-2.6.25-r8 profile:x86 Hardware:msi geforce 8600GT asus p5k-se location:/home/muhsin language(s):C/C++,VB,VHDL,bash Typo:40WPM url:http://mambo-tech.net -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-06 Thread mrfroasty
Hello, Storing only location of the image in dB wouldnt be any different than other string/data retrieved from the dB.That means if you have something like this in html documents whereby $image_location comes from the dB It should work without header stuffs Example img src=$image_location

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread mrfroasty
mins/td\n td$location/td\n /tr\n; } echo /table\n; echo img src='$location' border='1' height='150' width='200' alt='$build' ; ? /body /html/ mrfroasty wrote: Hello, It might be something with location where the script is located and the image.I think is normally

Re: [PHP-DB] Please help a newbie

2009-04-19 Thread mrfroasty
'); P:S id incremented automatically by MYSQL now GR mrfroasty Rij wrote: Hello, I am new to the world of PHP and MySQL. My objective is to create a table, insert values in it and read it back. Here's the partial code to create a table from a PHP file: if (!$table_exists) { $query=CREATE

Re: [PHP-DB] SELECT LIKE with % and without %

2009-05-02 Thread mrfroasty
Emiliano Boragina wrote: Hello. I am using this: $sql = SELECT * FROM table WHERE ID LIKE '%$_GET[id]%' AND title LIKE '%$_GET[word]%'; This doesnt work? $sql = SELECT * FROM table WHERE ID='some_id' AND title='some_title'; -- Extra details: OSS:Gentoo Linux profile:x86 Hardware:msi

Re: [PHP-DB] Re: Need help-Send email

2009-09-12 Thread mrfroasty
Is this related to PHP-DB? Anyways, if I understands it correctly is that mail() is working but the client is categorizing the mail received into the SPAM folder.This might means your issue is not longer on that mail(), but on the your mail-client filters. GR mrfroasty nagendra prasad wrote

Re: [PHP-DB] Books

2010-10-18 Thread mrfroasty
1.PHP Objects,Patterns, and Practice 2.Pro PHP Patterns, Frameworks,Testing and More MySQL: 1.MySQL Cookbook html/css no idea, I dont have good ideas of designing even if I become fluent in css.But its handy to know css just how it generally works and its place on the webAnyways, dont