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
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
Action: Correct the syntax of the function by entering the required number of
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?
PHP Database Mailing
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
I am not sure if this question has been asked before, If so sorry for asking
I have a site that the Client is moving from a MySQL db to Microsoft SQL
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
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
I thought of developing my own, but why build it if it exist
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.
From: Mark McCulligh [mailto:[EMAIL PROTECTED]]
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
Start up your web browser, go to the phpMyAdmin URL that
you just installed on your local machine, and
Thanks, I didn't know that phpMyAdmin could connect to another server
remotely. I will give it a try.
Mark McCulligh, Application Developer / Analyst
Sykes Canada Corporation www.SykesCanada.com
PHP Database Mailing List
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
I am a newbie to php (as i have announced several times on this bulletin
board =) so I thank you all for your help.
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
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()
Mail list logo