Re: [PHP-DB] DATETIME

> > 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

Re: [PHP-DB] finder

> > 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 a

Re: [PHP-DB] finder

> > 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

[PHP-DB] Re: [PHP] CREATE question

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 d

Re: [PHP-DB] from a table, I have to pick only those rows which have two specified fields

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

Re: [PHP-DB] Question about access rights in php/mysql

> > 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,

Re: [PHP-DB] Pull Down Menu with ODBC query

Try something like this: --SELECT--\n"; foreach ($menu as $m) { if ($m['sls_his_cust_id'] == $_POST['menu']) echo "{$m['sls_his_cust_id']}\n"; else echo "{$m['sls_his_cust_id']}\n"; } ?>

Re: [PHP-DB] Question on PHP connect MS SQL 2005

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

Re: [PHP-DB] Re: record pointer

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 colum

Re: [PHP-DB] record pointer

If I understand what you're asking, just write a simple query. $picked = ; $sql = "SELECT * FROM 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']; echo $id; // shows y

Re: [PHP-DB] mssql connecting

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

Re: [PHP-DB] MySQL BETWEEN Problems

So just change it to WHERE last_name BETWEEN 'A' AND 'G' . That'll get you Aa-Fz :) On 5/18/07, Tony Grimes <[EMAIL PROTECTED]> wrote: We tried that and it didn't work. We've also tried every combination of upper and lower case too. Tony On 5/18/07 2:18 PM, "Brad Bonkoski" <[EMAIL PROTECTE

Re: [PHP-DB] DB Design Concepts

the business logic says it's needed, 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@list

Re: [PHP-DB] DB Design Concepts

Max, I am assuming that since column b will only be populated 7% of the time that it is not a value specific column (does not matter if it has a value or not) Therefore I would suggest leaving the NULL's in there as it will not (at least should not) affect any system performance. On 5/2/07, Ma

php-db@lists.php.net

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: "?> On 3/30/07, elk dolk <[EMAIL PROTECTED]> wrote: thank you bastien, those wrappers are confusing fo

Re: [PHP-DB] Using multiple submits on a page and retaining $POST data

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 "--SELECT--\n"; *// This will create a loop to return each option of your dropdown* foreach ($query_result as $q) { *// This if s

[PHP-DB] MSSQL Server

I cannot connect to my MSSQL server. I use the following connection string: php: -- $connection = mssql_connect ('server','user', 'password') or die ('server connection failed'); $database = mssql_select_db

Re: [PHP-DB] Special Character

To turn off the auto formatting of hyphens: In Microsoft Word 2003: Open a new document. Go to Tools>Auto 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