[PHP-DB] Re: MySQL Field length

> Hi, > > What is the maximum length for the name of a column in MySQL? > > Thanks for your help http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Legal_names -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: mktime question

http://www.mysql.com/documentation/mysql/bychapter/manual_Functions.html#IDX1342 "insert into tbl (timeCol) values (now())" when you retrieve the time from mySQL, you format it the way you want and then display it !!! http://www.mysql.com/documentation/mysql/bychapter/manual_Functions.html#IDX13

[PHP-DB] Scrollbar + javaScript

content the scrollbar does not appear. My problem is that i would like to know whether the scrollbar is here or not; hence adjust the width of the table (and colums) accordingly! I have disabled horizontal scrollbar ("overflox-x: hidden" in CSS). Thx, Nadim Attari Alienworkers.com

Re: [PHP-DB] Scrollbar + javaScript

use google and you will find your solution. > > Regards, > > Filip de Waard Hi, My sincere apologies. In fact I sent this to a different forum (PHP at OVH)... dunno how it ended here. Again my sincere apologies. Best Regards, Nadim Attari -- PHP Database Mailing List (http://www.p

[PHP-DB] mySQL Parse Error

l neck cardigan (12 ply) with high ribbed welt and turn-back cuffs, authentic coconut buttons', '0') I get: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''itemcode', 'collection', 'promotion', 'bestSeller', 'newArriva I can't understand... tried googling but still no answer! Can someone help me please, regards, nadim attari -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mySQL Parse Error

> You should not have quotes around the column names. Yea. that was the problem... 'color' a was trivial error ! i got it at home after office hours!!! Seems that a break is necessary when things go wrong !!! Thnx Nadim Attari -- PHP Database Mailing List (http://www.php.net/) T

[PHP-DB] Re: Good books on sql / mysql

http://sudhirmangla.i6networks.com/books/database.htm http://www.maththinking.com/boat/computerbooks.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Deleting older records

> Okay I have a timestamp field how do I create a query to delete all entries > older than an hour. Timestamp field is set by now() function. DELETE FROM tblDownloadTrack WHERE `timestamp` < TIME_TO_SEC(DATE_SUB(NOW( ), INTERVAL 1 HOUR)) -- PHP Database Mailing List (http://www.php.net/) To uns

[PHP-DB] Re: I have a CR-LF problem when pulling stuff out of my DB

the contents are contained in an array 2. foreach (lines as linenum => line) line = RemoveWhiteSpaces(line); 3. fwrite back to file that's a rough idea.. hope it helps, nadim attari == This may not be exaxtly PHP-DB related but it is a result of s

[PHP-DB] Re: E-mail as HTML

> In PHP, how do I submit data by e-mail as HTML to a specified address? And where can I find samples of that in http://www.php.net/ ? HTML Mime mail at phpGuru http://www.phpguru.org/static/mime.mail.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.n

[PHP-DB] Re: Database Error submitting form

at the very top of the page! This line will not give the notice - even if isset() is not added! Hope it helps! Nadim Attari <[EMAIL PROTECTED]> a écrit dans le message de news:[EMAIL PROTECTED] > Dear Friends, > My form was working on localhost, without any error and was writi

[PHP-DB] Re: characters problem

> $myquery="INSERT INTO `$table` (`comments`) VALUES ('$mycomments')"; $mycomments = addslashes($mycomments); $myquery = "INSERT INTO $table (comments) VALUES ('$mycomments')"; See: http://www.php.net/addslashes Hope it solves the problem. nadim

[PHP-DB] Re: donwload listed dir

http://www.chrispederick.com/work/php/source/file/file.php "It Clown" <[EMAIL PROTECTED]> a écrit dans le message de news:[EMAIL PROTECTED] > Hi All, > > How would i create links dynamicaly for each file that has > been listed in a dir? > > Regards > __

[PHP-DB] Re: HELP PLEEASSSEE

> > . > while($row = mysql_fetch_array($result)) > { > ?> > > > . --- USE QUOTES > . while($row = mysql_fetch_array($result)) { ?> . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: How to get PHP to download web contents

> How would you get PHP to download a file such as a web page and put it in a string? >From the manual: $html = implode ('', file ('http://www.example.com/')); Note: As of PHP 4.3.0 you can use file_get_contents() to return the contents of a file as a string. -- PHP Database Mailing List

[PHP-DB] Re: A complex query problem

>From MS-SQL Server Manual: A subquery is a SELECT query that returns a single value and is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another subquery. A subquery can be used anywhere an expression is allowed. Unfortunately you do not have Sub-queries in mySQL ... Try

[PHP-DB] Re: Multiple same values only wanting one

> How do I select * from a table, but I do not want it to return the same > value if two fields are the same. Example - DISTINCT - GROUP BY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Old dbase 2 or 3 conversion

(7.0 i suppose) So if you can write PHP codes using the examples... Regards, Nadim Attari HelpPC 2.0PC Programmers Reference - Copyright (c) 1990 David Ju

[PHP-DB] Re: Images and PHP

PHP http://www.php.net/manual/en/ref.image.php ImageMagick http://www.imagemagick.org/www/identify.html PEAR: Imagick http://pear.php.net/package-info.php?package=imagick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: insertion problem (2)

ry($sql); Try this. Hope it gonna work. And for the next time, when you ask a question, please include all of the details which are relevant to your question. Good things to mention in your post include: a.. URL's b.. Keywords c.. A good description of the problem d.. Troubleshooting steps you have already taken Also, please give your question a relevant subject. "robots.txt syntax question" is a good subject. "Please help" is not a good subject. Regards, Nadim Attari -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: variable and MySQL

> I'd like to use $get_question_data[xxx_name_en] > $get_question_data[$test_name_en] > $get_question_data[{$test}_name_en] > ${get_question_data[$test_name_en]} try this ... $get_question_data["{$test}_name_en"] Hope it works... Nadim Attari -- PHP

[PHP-DB] Re: retrieve enum values

= enum('1', '2', '3') $enumValuesArr = split(',', str_replace("'", "", substr($fld_type, 5, -1))); echo ''; foreach ($enumValuesArr as $enumValue) echo "$enumValue" echo '';

[PHP-DB] Re: String manipulation

http://www.php.net/manual/en/function.substr.php Full String Documentation http://www.php.net/manual/en/ref.strings.php Regards, Nadim > Hi there everyone, > > > > I'm working with a mysql Db where I have a single string that I have to > split into 2 strings, the first character is the first nam

Re: [PHP-DB] Shrinking gifs.

r" both [quoted from the manual] "... returns an image identifier representing a BLACK image of size x_size by y_size." Question: Does anyone have a script / piece of code that keeps transparency after creating the thumbnail ? Regards, Nadim Attari -- PHP Database Mailing List (ht

Re: [PHP-DB] Shrinking gifs.. .

sx,$imsy); Thanks Martin for the tips.. Regards, Nadim Attari "Martin Norland" a écrit dans le message > nikos wrote: > > Thank you Martin > > I install new gd, reconfigure php and now is running OK. > > > > But, it was a mass to realize that shortening gifs

[PHP-DB] Re: MySQL - Unable to run service

,11388 - http://www.experts-exchange.com/Databases/Mysql/Q_21045378.html And please, give more specific info about your problem... Best Regards, Nadim Attari Alienworkers.com Ralph Brickley wrote: > I have been using MySQL for quite some time and am now running Server 4.1. I > have been de

[PHP-DB] Re: MySQL - Unable to run service

Another link: http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Windows_upgrading.html Regards, Nadim Attari Alienworkers.com Nadim Attari wrote: > Hello, > > I'm not being rude but it is a good thing to do before coming here: > > http://www.google-is-my-best-frie

[PHP-DB] Re: WAMP

Hello, I use XAMPP locally to test my scripts.. i haven't tested it online. Have a look: http://www.apachefriends.org Regards, Nadim Attari Alienworkers.com Kinfe Tadesse wrote: > Hello, > > Can any one recommend me a well-tested package containing Apache, MySQL > and P

Re: [PHP-DB] Re: [PHP] the opposite of a join?

s not present in |table2| (that is, all rows in |table1| with no corresponding row in |table2|). This assumes that |table2.id| is declared |NOT NULL|. Here it goes: select company.* from company left join contacts on company.companyId = contacts.companyId where contacts.companyId IS N

[PHP-DB] Re: help needed.

Hello, Maybe these can help. Web Server on CD: http://ampstart.ly-le.info/ http://www.stunnix.com/ http://www.server2go-web.de/ http://www.indigostar.com/microweb.php PHP EXE Compiler/Embedder : http://www.bambalam.se/bamcompile/ p.s.: Make sure you encode your PHP codes before distributing...