[PHP-DB] PHP - MSSQL - LINUX

2004-03-16 Thread Santhosh Kumar
Hi All, Where do I get mssql.so to connect mssql with my PHP4.0.6 and PHP4.3.3 Regards, Santos Kumar.M

[PHP-DB] Re: mssql query

2004-03-16 Thread Frank M Flynn
On Mar 16, 2004, at 5:17 PM, [EMAIL PROTECTED] wrote: From: Adam Williams <[EMAIL PROTECTED]> Date: March 16, 2004 7:32:57 AM PST To: [EMAIL PROTECTED] Subject: mssql query I've used mysql a little, but now I'm working with a MS SQL SERVER 2000 database. We have a proprietary application/hardware

Re: [PHP-DB] BLOB

2004-03-16 Thread Micah Stevens
$data = mysql_query("select from "); while ($d = mysql_fetch_array($data)) { echo $d[''].""; } .. or something like that. -Micah On Tuesday 16 March 2004 05:16 pm, Ng Hwee Hwee wrote: > hi, > > i've read the blob document in MySQL manual and i know it is similar to a > text field an

Re: [PHP-DB] BLOB

2004-03-16 Thread Ng Hwee Hwee
hi, i've read the blob document in MySQL manual and i know it is similar to a text field and can store large amount of binary data..however, in phpMyAdmin 2.5.4, i can't see the contents of my blob fields... how do you view it? sorry for my ignorance.. hwee - Original Message - From:

[PHP-DB] File Upload

2004-03-16 Thread Bruno Santos
Hello all Can someone tell me why PHP give all this erros, when it really opens the file and displays all it's contents ? Uploading files... File Type: text/plain UP: /tmp/teste.txt UP2: teste.txtFile uploaded successfully *Warning*: fopen(teste.txt): failed to open stream: Permission denied i

[PHP-DB] Re: need to select one cell from one row in one table...?

2004-03-16 Thread Justin Patrin
Aj Seelund wrote: ok, this might be difficult to explain, but this is what im trying to do... i have a table in my db call db_blog. in it i have an auto_increment column called entryNum. i use that strictly for order when i view the blog. i also have a column called comNum. each row in the t

[PHP-DB] Re: Inserting Data in Multiple Tables.. again

2004-03-16 Thread Justin Patrin
Craig Hoffman wrote: Here is the problem I am experiencing: I have a form that collects data and I would like it to send it to three tables in a MySQL DB. One table is called TRAININGLOG , other is called CORE and the third is USERS. The USER table is the main table that contains the prima

[PHP-DB] Re: Inserting Data in Multiple Tables - MySQL

2004-03-16 Thread Justin Patrin
Craig Hoffman wrote: Is it possible to write one INSERT statement to populate multiple tables? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ Nope. One record, one inse

Re: [PHP-DB] mssql query

2004-03-16 Thread Adam Voigt
SELECT count(id) FROM users WHERE DATEDIFF(eventtime,GETDATE(),d) == 1; Or something along those lines, all the date functions are very well documented in the "digital books" that come with Enterprise Manager. Open up the reference, and search for datediff, and there should be a link in there for

[PHP-DB] mssql query

2004-03-16 Thread Adam Williams
I've used mysql a little, but now I'm working with a MS SQL SERVER 2000 database. We have a proprietary application/hardware setup where when a person enters the building, the time they enter the building is automatically put into the database in a field called eventtime, and their access card

Re: [PHP-DB] Multiple Sorts

2004-03-16 Thread kc68
I asked this question several weeks ago; search for kc68 on this list archives and you should find the more complete response. The coding with my fields is: ?sort_field=cbc asc, net_receipts&sort_order=desc Play with the order and asc and desc as another response suggested. What's confusing i

RE: [PHP-DB] Multiple Sorts

2004-03-16 Thread Hutchins, Richard
Robert, You should be able to just do: SELECT * FROM access_tracking WHERE user = '$user_id' ORDER BY time DESC,date_accessed ASC; Just experiment with the ORDER BY columns and the ASC and DESC orders to get the results you're looking for. Hope this helps, Rich > -Original Message- > Fr

[PHP-DB] Multiple Sorts

2004-03-16 Thread Robert Sossomon
How can I write a sort to sort on 2 columns, one ascending, one descending? $get_list = "select * from access_tracking where user = '$user_id' order by time,date_accessed desc" But the ordering seems backwards sorted by date first, and then time. TIA!! Robert -- PHP Database Mailing List (http