RE: [PHP-DB] numeric string problem

yeah, i would go with Rick on this. however, the reason i think it's not working is because it's comparing the contents alphabetically ie. "2" is greater than "1" but is also greater than "10", "19" etc etc alphabetically, just as anything beginning with "b" is greater than "a" and also "aazzx

[PHP-DB] can't insert into MS-access

I can't use sql command "insert into " but I can use "select" and it condition.I use DSN that provide by ODBC and use MS-Access as source file. I found Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in and my code is " in

[PHP-DB] Access to Mysql

I am a complete newbie at this so please excuse me if I seem stupid. I have a guestbook on one site which was created using ASP and an Access database. I have created a new site using the much more friendly PHP and wish to get the data into my mysql database. Can I do this easily, and if so can a

[PHP-DB] Error insert into MS-access through ODBC not aviable

I can't use sql command "insert into " but I can use "select" and it condition.I use DSN that provide by ODBC and use MS-Access as source file. my code : $connect = odbc_connect("sosdb","","") or die ("can not connect") ; ->successfult $order_trans_detail_sql = "insert into order_trans_detail

RE: [PHP-DB] Access to Mysql

Funnily enough, I had to do something similar last week... Command line utility which will create a sql file to create the MySQL database. No guarantees that it works for everything, but it fulfilled my purposes... Syntax is: php -q odbc2mysql.php new_db output_file dsn [user] [password] And

[PHP-DB] Getting days after last login. Date problem

Hi there, I would like to find out the changes on content after a members last login. The format of the date stored in the member db is e.g.: Feb 13, 2002 The format of e.g pictures uploaded is: 2000-02-13 How can I search for pictures which are uploaded since the members last login. Is ist p

Re: [PHP-DB] Getting days after last login. Date problem

> Hi there, > > I would like to find out the changes on content after a members last login. > > The format of the date stored in the member db is e.g.: Feb 13, 2002 > The format of e.g pictures uploaded is: > 2000-02-13 > > How can I search for pictures which are uploaded since the members la

Re: [PHP-DB] Getting days after last login. Date problem

Thanx! Andy "* R&Ze:" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi there, > > > > I would like to find out the changes on content after a members last login. > > > > The format of the date stored in the member db is e.g.: Feb 13, 2002 > > The

[PHP-DB] Re: Getting days after last login. Date problem

Hey there... Sometimes it is easier to store the date as a unix timestamp (seconds since midnight 1/1/1970) cause it allows you to format the date any way you want, and php has cool date and time functions which rely on a timestamp. A time stamp example is like this: Formatted date: " . dat

[PHP-DB] Re: mysql_connect() and phpmyadmin

Hi Martin! I dont think I understood your question right here. Are you trying to connect to mysql ? regards Raymond "Martin Allan Jensen" <[EMAIL PROTECTED]> wrote in message 005901c1b40d$6143c390$040a@IceSystems">news:005901c1b40d$6143c390$040a@IceSystems... I just don't understand why

[PHP-DB] Need help (displaying select data from an array)

First up soory for the long messge but I'm totally stuck, I've been stuck for the past 3 days. I'm trying to display the results of a search, The code I've written so far displays the first five results and the links to pages for the rest, how do I display only the rows that I want. The code I

RE: [PHP-DB] Error insert into MS-access through ODBC not aviable

Penockio, You might find this helpful: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168 Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server > -Original Message- > From

RE: [PHP-DB] Need help (displaying select data from an array)

session_start() does not take a parameter. Use: session_start(); session_register($clothes); -Original Message- From: Renaldo De Silva [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help (displaying select data from an

[PHP-DB] Problems with pg_FieldNum

Greetings, I am having trouble with the PostgreSQL pg_FieldNum() funciton. When I execute the following: $DB = pg_Connect ( "dbname=lists" ); $Recs = pg_Exec ( $DB, "SELECT 123 AS \"ABC\"" ); $FieldName = pg_FieldName ( $Recs, 0 ); print ( "FieldName: $FieldName" ); $FieldNum = pg_

[PHP-DB] MS SQL Server 7

I am trying to get PHP to work with MS SQL Server 7, but its not liking something when I do a mssql_connect() it says " Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\test.php on line 7 I have added the proper extensions, have put them in the right directory. S

[PHP-DB] First and Last Record Query

Does anyone know how to grab only the first and last record of a query. I have a table named periods with two fields, period_id and period_name. The user will select a start period and an end period from a drop down list, assigning $start_period and $end_period variables based on the period id.

Re: [PHP-DB] First and Last Record Query

well, if you're using an array, you could use a for like this: $row = mysql_fetch_row($result); for( $i=0;$i To: <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 12:32 PM Subject: [PHP-DB] First and Last Record Query > Does anyone know how to grab only the first and last record of a query

RE: [PHP-DB] First and Last Record Query

Why are you iterating through the array? Why not just: $start_id = $row[0]; $end_id = $row[count($row)-1]; -Original Message- From: David Fudge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:40 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] First and La

Re: [PHP-DB] First and Last Record Query

yep, good point. thanks. =) - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'David Fudge'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 12:43 PM Subject: RE: [PHP-DB] First and Last Record Query > Why are you iterating through the array?

RE: [PHP-DB] First and Last Record Query

>> Why are you iterating through the array? Inexperience. Thanks for the help guys. I'll give it a try. Randy -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:43 AM To: 'David Fudge'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] First an

[PHP-DB] Passing form values with quotes, to itself

Hi there. I have a form that contains several fields w/ text info (which may or may not contain single and double quotes). When the user clicks Preview, the form's action is set to call itself ($PHP_SELF), and the info is displayed nicely so they can read it over, and verify it before saving to

Re: [PHP-DB] Passing form values with quotes, to itself

before you submit to the db, you have to escape the quotes like this: $Body = addslashes($Body); all " " will show up as \" \" and ' ' will be \' \' when you pull the info from the db, you'll have to use "stripslashes()" to remove those you put in. $Body = stripslashes($Body_from_db); - Ori

[PHP-DB] undeclared variable error

Folks, I am very new to PHP, and have been working through some tutorials. I have been able to post data from mySQL, but when I tried to do a form page to enter data into the database I get the following error: PHP Warning: Undefined variable: submit in c:\inetpub\wwwroot\testform.php on line 4

Re: [PHP-DB] Required pages...

I include this file on the top of all my scripts: /admin/index.php is the script where i do the login andrés - Original Message - From: "William Fong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2002 2:52 PM Subject: Re: [PHP-DB] Required pages... > I am

RE: [PHP-DB] undeclared variable error

change: if ($submit) { to: if (ISSET($submit)) { -Original Message- From: Dan Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 12:21 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] undeclared variable error Folks, I am very new to PHP, and have been working through so

RE: [PHP-DB] Passing form values with quotes, to itself

try: "> Also, please include a sample field value and the results of our tests -Original Message- From: Faye Keesic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 12:03 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Passing form values with quotes, to itself Hi there. I hav

Re: [PHP-DB] Passing form values with quotes, to itself

Try this. That should to the job. Jim Lucas - Original Message - From: "Faye Keesic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 10:02 AM Subject: [PHP-DB] Passing form values with quotes, to itself > Hi there. > > I have a form that contains severa

Re: [PHP-DB] Passing form values with quotes, to itself

it will still cut off with the double quots. if you have a double quote inside of a double quoted value property This will still break. it does care if they are escaped. Jim Lucas - Original Message - From: "David Fudge" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, Fe

[PHP-DB] Connecting to ms acces dbase from php

Anyone know how this is done, I know it has something to do with installing ODBC drivers, I downloaded them but I don't understand what I'm doing, Also can you use an acces database on the same machine or do you have to connect to a remote machine over some kind of network to use odbc. Can any

[PHP-DB] A while loop prob ?

Hi All What have I done wrong here. 3 yes 3 hours I have been plaing with this loop. All it shows is the last record in my db. It should show and record containing any string in the search. Error works Please help I beg you... As always thank you for any help Dave C - My Code

Re: [PHP-DB] Passing form values with quotes, to itself

Doesn't PHP have something that will automatically do this? I can't remember, but I think you had to enable it in php.ini or when you compile. (just like to know for future reference). thx. -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.4

Re: [PHP-DB] A while loop prob ?

You forgot the: - My Code Ends Here ... Jokes aside, and with some level of assumption, use: if ( isset($submit) ){ Your while() should be: while (list($name, $details, $price, $imgloc)==mysql_fetch_array($srchresult)){ = - is to set a variable == - is to compare

RE: [PHP-DB] A while loop prob ?

Need to show us more code. For instance: where is $srchrow set? Next, change: if ($submit){ to: if (ISSET($submit)) { Why are you over-writing $name, $details, $price, $imgloc with list() before you even use them? -Original Message- From: Dave Carrera [mailto:[EMAIL PROTECTED]] Sent:

[PHP-DB] Re: MS SQL Server 7

Hi there. Have you tried it with the odbc functions? Same prob? Cheers, Joe :) "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am trying to get PHP to work with MS SQL Server 7, but its not liking > something > > when I do a mssql_connect()

RE: [PHP-DB] undeclared variable error

Thanks Rick, That took care of the $submit error, but I still have the following error showing: PHP Warning: Undefined variable: PHP_SELF in c:\inetpub\wwwroot\testform.php on line 14 Here is line 14: I still don't know what's going on here. Thanks for your patience and help for us newbie

RE: [PHP-DB] undeclared variable error

change: to: note the semi-colon -Original Message- From: Dan Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 2:34 PM To: Rick Emery; [EMAIL PROTECTED] Subject: RE: [PHP-DB] undeclared variable error Thanks Rick, That took care of the $submit error, but I still

RE: [PHP-DB] Connecting to ms acces dbase from php

You need to install data source name at : Start --> Settings --> Control PAnel --> Data Sources(ODBC) Gurhan -Original Message- From: Renaldo De Silva [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 2:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Connecting to ms acces dba

Re: [PHP-DB] A while loop prob ?

Heh, with the help from Mr. Emery, I see the/a part of the problem now. You have to fetch the results before you can extract the data into variables. After you do the query, you must run a/the mysql_fetch_array. HTH -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.

[PHP-DB] phpmyadmin and mysql

Anyone know the ins and outs of phpMyAdmin? I have been getting the "accessed denied" error. The user is set right the passwd is set right and I am using the ip address of the website. Am I missing something. I know the database was orginally created by the admin control panel (maybe cgi) and

Re: [PHP-DB] Flipping through database records

You would pass the array index between pages. For instance, let's say I had the following db schema: table: user username varchar(10) fname varchar(10) lname varchar(10) dob data(14) ...ect Now let's say that there are 10 records in the table. Each time I visit the page I would do something li

[PHP-DB] counting multiple columns based on different values

I'm gonna go out on a limb and guess that I'm missing something obvious (and easy) because this sure seems like it should be able to be done. Here's the issue: I need to pull the client name and ID out of one table and then, count the records in a different table (called ratings) that match two d

Re: [PHP-DB] counting multiple columns based on different values

Perhaps the world is just a little more perfect today... Try this: SELECT clients.clientname,clients.ID,count(ratings2.clientID),count(ratings2.client ID) from clients LEFT JOIN ratings as ratings2 on (clients.ID = ratings2.clientID) LEFT JOIN ratings as ratings3 on (clients.ID = ratings3.client

[PHP-DB] RE: Logging visits using a database

Hi I have never used it but sounds like analog would fit your needs pretty well. Check them out at: http://analog.sourceforge.net/ Hope this helps.. Gurhan -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 6:29 PM To: [EMAIL PROTECTED];

[PHP-DB] Re: Problems with pg_FieldNum

Brady A. Johnson wrote: > Greetings, > > I am having trouble with the PostgreSQL pg_FieldNum() funciton. When I > execute the following: > > $DB = pg_Connect ( "dbname=lists" ); > $Recs = pg_Exec ( $DB, "SELECT 123 AS \"ABC\"" ); > > $FieldName = pg_FieldName ( $Recs, 0 ); > print ( "

Re: [PHP-DB] counting multiple columns based on different values

All is right in the world! This worked like a charm! Thank you So much! John --- Jason Cox <[EMAIL PROTECTED]> wrote: > Perhaps the world is just a little more perfect > today... > > Try this: > > SELECT > clients.clientname,clients.ID,count(ratings2.clientID),count(ratings2.client > ID) from

Re: [PHP-DB] counting multiple columns based on different values

Oops. I spoke too soon. This didn't quite get it. My results came back with column 3 and 4 having the exact same number in them for each record rather than column 3 having the count of status 3's and column 4 having a count of the status 4's. I've tried messing with the left join syntax trying t

[PHP-DB] Logging visits using a database

Hi Excuse the cross post I am thinking about building a logging tool to do visit analysis using SQL, rather than doing log file analysis. The aim is to analyse requests for dynamic pages called via php as well as static pages. Static pages will use an include for logging. Php calls may have two

Re: [PHP-DB] counting multiple columns based on different values

I see what you mean. The following query will return a result set where the clientID is returned twice, once of each status, with the number of times each status appears. You would have to run through your result array and match the clientID and the status your looking for to get the count. SEL