Re: [PHP-DB] checkboxes names & values in mySQL (newbie)

2002-10-10 Thread Andrey Sosnitsky
Hello, John. You wrote 10 îêòÿáðÿ 2002 ã., 23:40:10: J> 2 questions: J> Should I have a unique form name for each checkbox, and store it's J> boolean value in the database, OR (is it more streamlined) .. J> To create an array=myarray[$i]> with the same name but different value

Re: [PHP-DB] arrays

2002-09-23 Thread Andrey Sosnitsky
Hello, roslyn. You wrote 23 ñåíòÿáðÿ 2002 ã., 11:51:02: Try file() function "file -- Reads entire file into an array". See manual at http://www.php.net/manual/en/function.file.php for details. rj> hello, rj> im not sure of how to create a 1-d array. i want to read a text file and put each li

Re[2]: [PHP-DB] date format to dateformat

2002-09-22 Thread Andrey Sosnitsky
Hello, CrossWalkCentral. You wrote 23 ñåíòÿáðÿ 2002 ã., 2:05:38: So, explode() requires a seperator as a first argument. You code is $date= "10-01-2002"; list ($day, $month, $year) = explode("-", $date); echo "$year-$month-$day"; See PHP manual at http://www.php.net/manual/en/function.explode.

Re: [PHP-DB] date format to dateformat

2002-09-22 Thread Andrey Sosnitsky
Hello CrossWalkCentral, Sunday, September 22, 2002, 7:06:18 AM, you wrote: Try this $date= "10 01 2002"; list ($day, $month, $year) = explode(" ", $date); echo "$year-$month-$day"; C> I am having problems coverting the followign date format. Does any one have C> any insight on this. C> $date=

Re: [PHP-DB] Selecting one random column from MySQL

2002-09-18 Thread Andrey Sosnitsky
Hello, Shoulder. You wrote 18 ñåíòÿáðÿ 2002 ã., 5:20:55: Do you mean random row? So, try this $query = "SELECT * FROM table ORDER BY RAND() LIMIT 1"; $result = mysql_query($query); etc... StSF> Hi all, StSF> How can I select one random column from a MySQL table? StSF> Thanks, Taj

Re: [PHP-DB] previous and next with postgresql

2002-09-10 Thread Andrey Sosnitsky
Hello, Angelo. Try pn.class.php at www.phpclasses.org AMR> I am trying to have previous and next links in my php script AMR> wich i make a select from a table. I am using postgresql AMR> anybody has a link for a tutorial or a sample code doing this? www.pskov.ru -- Best Regards, Andrey

Re: [PHP-DB] PHP4-PostgreSQL-Solaris

2002-07-29 Thread Andrey Sosnitsky
Hello, Jan. You wrote 29 èþëÿ 2002 ã., 11:56:50: "./configure --with-pgsql" JF> But what are the exact compiling options I have to use? Read for details: http://www.php.net/manual/en/ref.pgsql.php www.pskov.ruwebmaster|programmer|DBA www.invest.pskov.ru www.education.pskov