Hi All,
I have a DB that is storing the date/time an event happens in DATETIME
format, i.e. 1254252889, which translates to Tue, 29 Sep 2009 19:34:49 UTC
I am trying to write a query in PHP that will look for any row that falls
within a range of dates, i.e. between Sep 1 and Oct 1, but
Hello… I must to do a finder with 10 posibilities.
This 10 can be full or empty.
(sorry... I just ask this but I’m not understand yet)
I know how to do a finder about any field, but this is my first time with
one like this where the user can find a “house” in a “zone” or find
anything
But with that it doesnt difference between full and empty field…
If the user want search on two posibilities on ten...
Maybe I'm not understanding what you're asking...
Or maybe you don't understand the query...
Say your form has 10 checkboxes.
If the users picks 3 out of ten boxes and
On 10/30/08, Daniel Brown [EMAIL PROTECTED] wrote:
On Thu, Oct 30, 2008 at 2:19 PM, Dan Shirah [EMAIL PROTECTED] wrote:
Is it possible for us to use PHP to create temp tables in our database?
[snip!]
But all that does is give me an ifx_prepare fails message.
(Forwarded to PHP-DB
On 9/18/08, Vaibhav Informatics [EMAIL PROTECTED] wrote:
Any simple command like distinct?
--
Vaibhav Informatics, 304 Vasant Plaza, Munirka, Near Subway, New Delhi-110
067 Ph: 011-26194466 Email :[EMAIL PROTECTED]
could you provide a little more detail, please?
Are you saying that you
Hi Everyone,
I am attempting to wrap my head around an issue and wanted to see if I was
thinking right.
I am attempting to setup a pURL site, one where they go to something like:
example.com/purl.php?purl=jason1234 and the site says Welcome Jason. I
have that part of it working, and it's
Try something like this:
tddiv align=right
SELECT name=menu
?php
$conn = odbc_connect(HOMES, , );
$billdate = $_POST[ 'billdate' ];
$q_menu = SELECT DISTINCT sls_his_cust_id FROM sls_his where
sls_his_prchdat_alt = $billdate;
$r_menu = odbc_exec($conn, $q_menu);
while
Alice,
In regards to:
Call to undefined function mssql_connect() in
/home/TDC/Desktop/create_new_entry_master.php on line 20
Do you have the MSSQL extension uncommented in your PHP.ini?
Dan
If I understand what you're asking, just write a simple query.
$picked = your_selection;
$sql = SELECT * FROM your_table WHERE cat = '$picked';
$result = mssql_query($sql) or die (My_Error_Message);
$row = mssql_fetch_assoc($result);
$id = $row['id'];
$name = $row['name'];
$cat = $row['cat'];
Okay, in your first post you said you were selecting by category, now you're
saying you are selecting by ID and want all corresponding records that have
the same category as the selected ID.
Which way are you trying to do this??
On 7/5/07, elk dolk [EMAIL PROTECTED] wrote:
O.K. the id column
Did you already try these steps?
http://us2.php.net/manual/en/function.mssql-connect.php#70918
On 5/23/07, Bryan [EMAIL PROTECTED] wrote:
I'm trying to connect to mssql 2000 on a windows server 2003 standard
box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of
course. Any
, at application run time if certain conditions were met, the
column takes on the characteristic NOT NULL attribute.
-Original Message-
From: Dan Shirah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007 3:50 PM
To: Max Thayer
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] DB Design Concepts
I believe what he is saying that since you wrap your echo in double quotes,
that you should not use duoble quotes again inside the same echo.
Therefore your code should like like this:
td width=90 height=70
?php echo img src='/album/img/'.$photoFileName[2].' width='90' height='70
' border='0' /
Try something like this:
Your query here to get your dropdown values
**
*// This first option value will set your default dropdown to display as
blank*
echo OPTION value=\\--SELECT--/OPTION\n;
*// This will create a loop to return each option of your dropdown*
foreach ($query_result as
I cannot connect to my MSSQL server.
I use the following connection string:
php:
--
$connection = mssql_connect http://php.net/mssql_connect('server','user',
'password') or die ('server connection failed');
$database = mssql_select_db
To turn off the auto formatting of hyphens:
In Microsoft Word 2003:
Open a new document.
Go to ToolsAuto Correct Options
Select the Auto Format As You Type tab
Deselect the Hyphens (--) with Dash (-) option.
Even though it says it will replace a double hyphen (--) with a Dash (This
is an em
16 matches
Mail list logo