RE: [PHP-DB] Date comparison problem

2002-07-11 Thread Gabor Niederlaender
But I would like to do it the other way round. I mean for the solution you have mentioned, I have to make the query on the whole record, then compare the two dates and filter the right ones. I'd like to make the query look like: SELECT something FROM table WHERE datetime $form_date So I think

Re: [PHP-DB] RH7.3+Oracle9i(9.2.0)Client+PHP4.2.1+Apache1.3.26

2002-07-11 Thread Hubert ADGIE
in a76999.pdf [ ORA-00909 invalid number of arguments Cause: An Oracle function was referenced with an incorrect number of arguments. All Oracle functions, except for SYSDATE, require at least one argument. Action: Correct the syntax of the function by entering the required number of arguments. ]

[PHP-DB] php-security

2002-07-11 Thread Gabor Niederlaender
Hi all! One can see in every php manual and install hint, that you have to consider security issues if you install php as a CGI, but I cannot really imagine what this means. What security issues? Can someone tell me an example, what can happen? Best regards, Gabor -- PHP Database Mailing

RE: [PHP-DB] Date comparison problem

2002-07-11 Thread joakim . andersson
Hi, Assuming your dates have the format you specified and that you only want to compare dates, not time aswell. $str_sql = SELECT something FROM mytable WHERE LEFT(my_datetime, 10) = ' . str_replace(/, , $form_date) . '; or if day / month is reversed in MSSQL $str_sql = SELECT something FROM

[PHP-DB] MSSQL functions vs. ODBC functions

2002-07-11 Thread Mark McCulligh
I am not sure if this question has been asked before, If so sorry for asking again. I have a site that the Client is moving from a MySQL db to Microsoft SQL Server. Is it better to setup an ODBC connection to SQL Server and use the ODBC functions OR to use the MSSQL functions. If I have the

[PHP-DB] phpMyAdmin for Windows?

2002-07-11 Thread Mark McCulligh
I have a site that is on a Windows Server : and having problems with the Hoster giving me telnet access to Admin MySQL. Is there some thing like phpMyAdmin for Windows. I want to put it in a folder on my site to manage the DB. I thought of developing my own, but why build it if it exist

RE: [PHP-DB] phpMyAdmin for Windows?

2002-07-11 Thread Ryan Jameson (USA)
phpMyAdmin uses PHP and PHP is available for windows. So if I understand your question, the answer is yes, there is something LIKE phpMyAdmin for Windows. It is not a windows application though. Ryan -Original Message- From: Mark McCulligh [mailto:[EMAIL PROTECTED]] Sent: Thursday,

Re: [PHP-DB] phpMyAdmin for Windows?

2002-07-11 Thread Eugene Mah
If you have a local webserver with PHP installed, all you should need to do is install phpMyAdmin on your local server and configure phpMyAdmin to look for the databases on the remote machine. Start up your web browser, go to the phpMyAdmin URL that you just installed on your local machine, and

Re: [PHP-DB] phpMyAdmin for Windows?

2002-07-11 Thread Mark McCulligh
Thanks, I didn't know that phpMyAdmin could connect to another server remotely. I will give it a try. Mark _ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation [EMAIL PROTECTED] -- PHP Database Mailing List

[PHP-DB] Re: Select string.

2002-07-11 Thread Jason Morehouse
Single quotes within the select work fine. $login = mysql_query(SELECT * FROM Users WHERE Username = '$User_Name'); On Thu, 11 Jul 2002 06:47:54 +1200, Shiloh Madsen wrote: Yet another thing i need some quick help with. What is the proper way to generate a select string in php. I know if

[PHP-DB] resource ID #3

2002-07-11 Thread Jonathan
I am a newbie to php (as i have announced several times on this bulletin board =) so I thank you all for your help. Mi problemo: I have a database of events going on at local colleges. The names of the tables are the abbreviated names of the colleges. I grab those with a 'SHOW TABLES' command

RE: [PHP-DB] resource ID #3

2002-07-11 Thread Beau Lebens
Jonathan, most (all?) of the database query-related functions in PHP return a Resource ID which contains the data resulting from your query. To access that information, you need to pass the Resource ID thru a function like (assuming u r using MySQL) mysql_fetch_array() or mysql_fetch_row() Have