[PHP-DB] Results with ledger stripes?

2004-01-25 Thread dan
s repeat until done The gizmo is up and running at http://www.dibcomputers.com/bandwidthmeter/index.php if you care to have a gander. Thanks a bunch, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Help Help

2002-10-09 Thread dan
s will not load. Help please. Dan J. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: Problem with mysql_connect(...)

2005-09-19 Thread Dan
If this is a windows computer, you might want to try adding C:\PHP (or whatever directory your PHP resides) into the path. I read somewhere that this needs to be done for PHP5 and MySQL. Not sure if it was true but seemed to clear up the problems I was having getting the 2 to talk to either other

RE: [PHP-DB] Re: Problem with mysql_connect(...)

2005-09-20 Thread Dan
27;s not recommended. -Original Message- From: viraj [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 12:14 AM To: Dan Cc: Michael Louie Loria; php-db@lists.php.net Subject: Re: [PHP-DB] Re: Problem with mysql_connect(...) this is a dll issue; if you are running php5 on windows

Re: [PHP-DB] Retrieve listings between two dates?

2001-01-09 Thread Dan Malcolm
Tried: SELECT * FROM calendar WHERE Year < #2000-12-31# AND Year > #2000-01-01# ORDER BY Start ASC supplied by "mqqla". I used his format against an Access 2000 database and it worked perfectly. dm ""Keith Spiller"" <[EMAIL PROTECTED]> wrote in message news:03f301c03e46$2515c370$6bdaead8@enigm

[PHP-DB] Re: [PHP] Lowercase problem

2001-02-05 Thread Dan Wilson
You need to put quotes around the upper- or mixed-case table names. SELECT * FROM "MixedCase" Of course within PHP, you need to escape those quotes: $query = "SELECT * FROM \"MixedCase\""; -Dan > Hi-- > > I don't know where the problem resides, bu

Re: [PHP-DB] Solid Database Installation

2001-03-01 Thread Dan Kalowsky
This was a problem on the 4.0.4 release (forgot a line break), but I believe the patch made it into the 4.04.pl1. If you can, please try the latest snapshot from CVS and see if this problem still exists for you. I was under the impression that much of this has been fixed for linux as well (I'

[PHP-DB] Re: Join statement and output

2001-03-04 Thread Dan Fitzpatrick
| date Dan __ Subject: Join statement and output Date: Sat, 03 Mar 2001 22:43:27 -0800 From: Norman Tan <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] No actual code, but hopefully, someone can help me throu

[PHP-DB] ODBC test cases

2001-03-07 Thread Dan Kalowsky
prepare($conn,"INSERT INTO odbctest2 (id,firstname,lastname) VALUES (?,?,?)"); if ($stmt2) { print "Trying execute stat2"; $stmt1 = odbc_execute($stmt1,array("1","This","Works")); } ?> -- Dan Kalowsky

[PHP-DB] ODBC test cases: CORRECTED

2001-03-07 Thread Dan Kalowsky
xecute stat1"; $stmt1 = odbc_execute($stmt1,array(1,"This","Fails")); } $stmt2 = odbc_prepare($conn,"INSERT INTO odbctest2 (id,firstname,lastname) VALUES (?,?,?)"); if ($stmt2) { print "Trying execute stat2"; $stmt2 = odbc_execute($

[PHP-DB] PHP: Good for articles?

2001-03-08 Thread Dan Eskildsen
ation for this type of application. Another Question: Can users via PHP update field data in a MySQL database? I would really appreciate any comments. Please cc: your reply to [EMAIL PROTECTED] It's snowing over here! Regards, Dan -- PHP Database Mailing List (http://www.php.net/) To u

[PHP-DB] Where do I get started?

2001-03-08 Thread Dan Eskildsen
DE539940B515@MSPMX01">news:9E35C54B0C7AD411B5C1009027DE539940B515@MSPMX01... > Dan, > > I think it is a very powerful combination. PHP is easy to learn as is > mySQL. They are both free and powerful. > > Question 2: Yes you can do about anything to a database with PHP including > updating field da

[PHP-DB] SSI and PHP?

2001-03-10 Thread Dan Eskildsen
MySQL to a day later having already programmed a small application that will display newspaper articles. Thanks! Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

Re: [PHP-DB] SSI and PHP?

2001-03-10 Thread Dan Eskildsen
I meant: I would like to THANK everyone who commented on my queries the last couple of days. ""Dan Eskildsen"" <[EMAIL PROTECTED]> skrev i en meddelelse 98cvq8$7dr$[EMAIL PROTECTED]">news:98cvq8$7dr$[EMAIL PROTECTED]... > Hi there, > > Can anyone

[PHP-DB] Storing character returns

2001-03-12 Thread Dan Eskildsen
I store newspaper articles into a MySQL database. The text that I insert (via phpwizard.net) contains a little formatting: line returns to separate paragraph, but when I suck the data out again to display it all the character returns vanish. Any ideas? Please cc comments to [EMAIL PROTECTED]

[PHP-DB] document.referrer in php?

2001-03-12 Thread Dan Eskildsen
Are the following javascript variables avaliable in php? I searched for this on www.php.net but could not find any references. document.referrer window.location I would appreciate your help. Please cc comments to [EMAIL PROTECTED] Regards, Dan -- PHP Database Mailing List (http

[PHP-DB] Re: SQL Mysql - Informix

2001-03-17 Thread Dan Fitzpatrick
] <- If you use blobs you may have some numeric tables I think The stuff in the square brakets is optional. Informix throughs in a lot of system tables and hidden tables. The systabnames table is in the sysmaster database and has the following fields: partnum, dbsname, owner, tabname, collate

[PHP-DB] No. of Users online right now?

2001-03-20 Thread Dan Eskildsen
Hi there, This is a NewBie Question: While out surfing I have often seen a message like: "There are 17 users on this site at the moment." Can I do this with php? Just to show how many people are on (browsing) the site at that moment? I run a community website. Thanks ===

[PHP-DB] file name extentions

2001-03-24 Thread Dan Eskildsen
the server will not execute the file. Any suggestions? Regards, Dan -- == Regards from Denmark, Europe Please cc your reply to [EMAIL PROTECTED] == I haven't lost my mind, I've got it backed up on TAPE somewhere...

Re: [PHP-DB] PHP on WIN32 with DB2 CLI

2001-04-01 Thread Dan Scott
Actually, CLI is almost function-for-function the same as ODBC. The PHP implementation of ODBC is quite a simplified version, but it covers most of the basic function. Chris, what is it that you are trying to do, specifically? Dan Phil Jackson wrote: > Chris - I think to use DB2&#x

RE: [PHP-DB] CSS versus Includes

2001-04-01 Thread Dan Fitzpatrick
passing this redundant data over and over again to the browser. If it is a separate flat file on the file system, it will have a real mod date and the web server and browser can determine when a fresh copy is needed. My 2 cents. Dan Matt wrote... > When I asked the question, what I meant was sho

RE: [PHP-DB] Re: send email

2003-11-26 Thread Dan Brunner
$header .= "$text\n"; mail($To, $subject, "", $header); } That should do it!! And of course you should send some kind of feedback to the user, so they now it worked as well. I hope this helps. I know there are better ways of doing this, functions or classes. But t

[PHP-DB] multi-language site

2004-01-15 Thread Dan Hewins
r the Spanish column. Does this sound like a good approach? Is PHP capable of something like this? Thanks for any help or suggestions you can give. Dan Hewins -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] multi-language site

2004-01-16 Thread Dan Hewins
different sites (English, Spanish, Admin-Eng, Admin-Esp). A separate question is this: where are the good resources for XML on the web? Thanks. Dan On Jan 16, 2004, at 4:18 AM, <[EMAIL PROTECTED]> wrote: The advantage of doing it the way Dan describes is that it is very easy to set up an admi

Re: [PHP-DB] Where's the error?

2004-04-08 Thread Dan Brunner
Not even the title?!?! Dan On Apr 8, 2004, at 2:55 PM, [EMAIL PROTECTED] wrote: It is not displaying anything at all. -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:52 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB

[PHP-DB] lamer noob question

2004-04-15 Thread Dan Bowkley
AIRSPRICESFAQTRAILERCONTACT MEDIRECTIONS This site copyright (C) 2004 by Eva-M. Hollmann. All rights reserved.Website design by Dan at http://www.dibcomputers.com"; style="color:#2f2f2f; font-size:xx-small;text-decoration:none;font-weight:bold;" target="new">DIB Comput

[PHP-DB] stuck on stupid...can't find the bloody error...

2004-04-24 Thread Dan Bowkley
work order number that already exists. Help this feeble-minded programmer wannabe? Oh, as to the \' madness down yonder: should I or shouldn't I backslash the single quotes? TIA Dan The Board Lady - Work Order Database 0.1a \n"; echo ""; echo "Work Orde

[PHP-DB] Re: RE :I thought "4" didn't equal "456456456%20%20OR%201<>2"

2004-05-10 Thread Dan Bowkley
DING! That's the sound of a little lightbulb turning on... Thanks so much for that tidbit...I could certainly see myself getting screwed by not using such a thing. Dan - Original Message - From: "Neil Smith [MVP, Digital media]" <[EMAIL PROTECTED]> To: <[EMAIL

Re: [PHP-DB] supernoob strikes again

2004-05-09 Thread Dan Bowkley
n > some input verification is recommended : > http://www.dibcomputers.com/new-dibcomputers/index.php?id=456456456%20%20OR%201<>2 > > > > > "Dan Bowkley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > got it...rather than return false, mysql_resul

[PHP-DB] supernoob strikes again

2004-05-08 Thread Dan Bowkley
dibcomputers.com/new-dibcomputers/index.php and I've got it also retrievable as a text file at the above url with .txt appended. I know there's an easy way to do this...I'm just braindead at the moment. Staring at this thing for too long I guess. :) Thanks in advance, Dan the Noob

Re: [PHP-DB] supernoob strikes again

2004-05-08 Thread Dan Bowkley
The 404 page is also inserted into the template, or at least that's the idea...index.html?id=404 is the error page. ?id=1 is the main page, other pages are numbered accordingly. - Original Message - From: "Justin Gruenberg" <[EMAIL PROTECTED]> To: "Dan Bowkl

[PHP-DB] narrowing it down...

2004-05-09 Thread Dan Bowkley
I've come up with this: if (mysql_result ( mysql_query ("SELECT id FROM dibcomp_site WHERE id = $page_req"),0)) {$thisid = "404";} else {$thisid = $page_req;} and, well, it doesn't work. I think it really ought to...

Re: [PHP-DB] supernoob strikes again

2004-05-09 Thread Dan Bowkley
got it...rather than return false, mysql_result throws an error if the query returns nothing. What a pain. Finished product at http://www.dibcomputers.com/new-dibcomputers/index.php.txt if anyone wants to steal it... D - Original Message - From: "Dan Bowkley" <[EMAIL P

[PHP-DB] lamer noob with repeat question

2004-05-02 Thread Dan Bowkley
rds ( name varchar(40) default NULL, phone varchar(12) default NULL, email varchar(40) default NULL, purveyor varchar(40) default NULL, job_no int(5) unsigned NOT NULL default '0', date varchar(10) NOT NULL default '', board_type varchar(100) NOT NULL default '', weight_in decimal(4,2) default NULL, weight_out decimal(4,2) default NULL, last_three int(3) unsigned default NULL, PRIMARY KEY (job_no), KEY last-three (last_three) ) TYPE=MyISAM; Can anyone help me to get this thing working? TIA Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] lamer noob with repeat question

2004-05-03 Thread Dan Bowkley
Anyone? - Original Message - From: "Dan Bowkley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 02, 2004 1:21 AM Subject: [PHP-DB] lamer noob with repeat question > Hello everyone, > > I've been working on (read:tearing my hair out ov

Re: [PHP-DB] IBM DB2

2004-09-08 Thread Dan Scott
x27;s Edition from http://www14.software.ibm.com/webapp/download/search.jsp?rs=db2pde if you want to test it out. Registration is required, but there's no license fee involved as long as you're not using the database in a production environment. Dan -- PHP Database Mailing List (http://

[PHP-DB] selective query?

2004-10-31 Thread Dan Bowkley
ing_index(name,'.',-2) ASC"); echo "DomainLowest SpeedAverage SpeedHighest Speed\n"; while ($mongorow = mysql_fetch_array($mongo, MYSQL_NUM)) { if($bg=='#dd') $bg='#ff' ; else $bg='#dd' ; echo "http://www.

Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Dan Brunner
Hello!!! What is the Length of the varchar field, in your database??? Dan On Friday, January 25, 2002, at 01:22 PM, [EMAIL PROTECTED] wrote: > I'm having a problem with varchar fields out of mssql which are only > returning value lenghts < = 256 characters. > > I k

Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Dan Brunner
If you need something that big Use a TEXT type instead. Dan On Friday, January 25, 2002, at 01:35 PM, [EMAIL PROTECTED] wrote: > thanks for your reply. It's 5000. > > > > Kevin Won > - > IT

RE: [PHP-DB] FIle Uploading to database

2002-02-03 Thread Dan Brunner
eeds to be...with the file name of $pic_name2... All you're storing is the Pictures Name, Size, and Type And you would do something like this for the tag... ... echo ("\n"); ... $data->name is the mysql field for the Picture Name.. I use mysql_fetch_object f

Re: [PHP-DB] Re: FIle Uploading to database

2002-02-04 Thread Dan Brunner
Hey did you get it to work yet?!?! Dan On Sunday, February 3, 2002, at 09:08 PM, [EMAIL PROTECTED] wrote: > Umm.. > > SET parameter is for the UPDATE query > > > "Adam Royle" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL

Re: [PHP-DB] Re: FIle Uploading to database

2002-02-04 Thread Dan Brunner
m at first too!!! You can also do debug the script. Like this echo $ResumeUp; That should print the tmp file you form created... Let me know... Once this pasts...It works really well... Dan On Monday, February 4, 2002, at 09:35 AM, [EMAIL PROTECTED] wrote: > The INSERT

Re: [PHP-DB] Re: FIle Uploading to database

2002-02-04 Thread Dan Brunner
GOOD What was the problem!?!? Dan On Monday, February 4, 2002, at 01:44 PM, [EMAIL PROTECTED] wrote: > Ok, > > I got it woohoo!!! > > It works! > > Thanks for all your help > > -Original Message- > From: Dan Brunner [mailto:[EMAIL PROTECTED]] > S

Re: [PHP-DB] Searching Documents

2002-02-08 Thread Dan Brunner
Hello!!! Use LIKE in your Select statement...Like this!! $sql = "Select File_Name From Table2 WHERE File_Name LIKE '%$Search%'"; $Search would come from a form... Dan On Friday, February 8, 2002, at 09:06 AM, [EMAIL PROTECTED] wrote: > I was wondering if t

[PHP-DB] Flipping through records

2002-02-12 Thread Dan Swensen
Hello, I am attempting to put together a page whereby results from a database are displayed, and previous / next hyperlinks allow the user to "flip" through records. I attempted to do this by using a unique ID (that auto increments) and then including links like so at the bottom of the page: -

[PHP-DB] Flipping through database records

2002-02-12 Thread Dan Swensen
Hello, I am attempting to put together a page whereby results from a database are displayed, and previous / next hyperlinks allow the user to "flip" through records, one at a time. I attempted to do this by using a unique ID (that auto increments) and then including links like so at the bottom o

Re: [PHP-DB] Flipping through database records

2002-02-12 Thread Dan Swensen
and create an > > array and then store that in a session? > > > > olinux > > > > > > --- Jason Cox <[EMAIL PROTECTED]> wrote: > > > Dan, > > > > > > Here's an idea for you: > > > > > > Rather than try to pass

Re: [PHP-DB] Flipping through database records

2002-02-12 Thread Dan Swensen
TECTED]">news:[EMAIL PROTECTED]... > > Interesting Jason, just to make sure I'm clear: > > > > basically, you would query the table and > > while loop through the query result and create an > > array and then store that in a session? > > > > olinu

[PHP-DB] undeclared variable error

2002-02-13 Thread Dan Howard
4 PHP Warning: Undefined variable: PHP_SELF in c:\inetpub\wwwroot\testform.php on line 14 Here is the code: First name: Last name: Address: Position: Does anyone have any ideas, or where I need to look more to learn what the problem is here? TIA Dan -- PHP

RE: [PHP-DB] undeclared variable error

2002-02-13 Thread Dan Howard
elp for us newbies! Dan -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 12:11 PM To: 'Dan Howard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] undeclared variable error change: if ($submit) { to: if (ISSET($submit)) { -Origin

Re: [PHP-DB] optimizing script...

2002-02-15 Thread Dan Brunner
suppose maybe you could make the Variables($car_type,$car_model,$car_year) into an array. Then ereg_replace the new array, then turn it back to the variables...I think it's explode...and implode Never tried it Good Luck Dan On Thursday, February 14, 2002, at 10:57 PM, [EMAIL

Re: [PHP-DB] Re: forced page links...

2002-02-27 Thread Dan Brunner
with cookies. And check for that variable every page with an If...else..statement. like If (empty($CheckPLEASE){ echo "Sorry You are out of order"; exit(); }else{ echo "hey your good to go!!"; } And so on and so on... Dan On Wednesday,

RE: [PHP-DB] accessing system cmds w/ PHP

2002-02-27 Thread Dan Brunner
Hello... Try exec() I know it works moving files. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:37 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] accessing system cmds w/ PHP Can anyone tell me how to access linux

Re: [PHP-DB] easy date format question

2002-03-04 Thread Dan Brunner
Hello!! it should be $today = Date("Y"-"m"-"d"); Dan On Friday, March 1, 2002, at 04:50 PM, [EMAIL PROTECTED] wrote: > should be simple as pie, of course, but i can't find a straightforward > syntax example in the documentation. i'm trying to c

RE: [PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Dan Brunner
Hello!! First uninstall your old version of php(php-4.0.6-9.7.0) Then install the new RPM If you're using the Red Hat update thingy... Or download the source and recompile it!! Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, Mar

Re: [PHP-DB] records into an editable box

2002-03-06 Thread Dan Brunner
Hello!! Do you mean a textarea?? And you want to populate the "textarea" with the data, right? Dan On Wednesday, March 6, 2002, at 01:34 AM, [EMAIL PROTECTED] wrote: > How would I change this sql statement to pull the db table and display > it > within an editable box

Re: [PHP-DB] Selecting Drop Down Value From DB to Edit

2002-03-27 Thread Dan Harrelson
If I understand your question, when editing an existing record where StateID = "CA", you want the drop-down to show "California" as selected. You need to add a little code into your while loop to echo "SELECTED" into the appropriate "option" tag. -Dan

RE: [PHP-DB] include() statement hell!

2002-03-27 Thread Dan Brunner
Has anybody told him to check his PHP.INI??? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 6:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] include() statement hell! #1. You may want to double-check the path w

Re: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Dan Brunner
u have an error... I too messed around trying to just using PHP, but I gave up using just PHP, Javascript plays nice with PHP anyway!! Dan On Monday, April 1, 2002, at 12:57 PM, [EMAIL PROTECTED] wrote: > I was close. :) > > -Original Message- > From: Jason

[PHP-DB] Selecting random record from a database?

2002-04-02 Thread Dan Swensen
Hi all, Does anyone know a quick and easy way to select a random record from a database? I'm looking to put together a simple random quote generator, a la linux's "fortune." Any help would be much appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

Re: [PHP-DB] AOL Problems

2002-04-09 Thread Dan Brunner
Hello!! So is the old value of "new location" not being passed to the next page? OR Is the new "category" variable not being passed to the next page?? Dan On Tuesday, April 9, 2002, at 12:44 PM, [EMAIL PROTECTED] wrote: > Hi group, > > I wonder if

Re: [PHP-DB] HTML tables in PHP

2002-04-10 Thread Dan Swensen
nt too, unless you really do want to make a new table for every record returned. Hope that helps. Good luck, Dan > Hi everyone! > > Is there a good tutorial on how to write html tables in PHP? > > In my last post "Not displaying all records" I have the items > d

[PHP-DB] auto-increment question

2002-04-23 Thread Dan Swensen
they still need to auto- increment. Can this be done, or do I need to find a workaround (and if so, can anyone suggest anything?) Thanks in advance, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] auto-increment question

2002-04-23 Thread Dan Brunner
Hello!! ALTER TABLE table1 AUTO_INCREMENT = 1000; That should do it... You can use that anytime.. Dan On Tuesday, April 23, 2002, at 12:21 AM, [EMAIL PROTECTED] wrote: > Hi all, > > I'm wondering if there is a way to start an auto-increment field at a > number > other

Re: [PHP-DB] Search tutroial

2002-04-24 Thread Dan Swensen
Getting a search function running perplexed me, too, until I looked at the MySQL docs. With the Full-Text Search function I got a search function working in minutes. http://www.mysql.com/doc/F/u/Fulltext_Search.html Watch out for the weird bug that ignores duplicate rows, though. It can make

Re: [PHP-DB] Search tutroial

2002-04-24 Thread Dan Brunner
l_query($query); while(list($quantity)=mysql_fetch_row($ret)) Dan On Wednesday, April 24, 2002, at 01:47 PM, [EMAIL PROTECTED] wrote: > By the way SELECT uid, id, image, iname, quantity, type, user where it > shows > below that user isn't in the query- it is there in my editor.

Re: [PHP-DB] Search Script

2002-04-25 Thread Dan Brunner
t_Name, Art_Job_Number, Size, Item_Number FROM Table1 WHERE Print_Name LIKE '%$Print_Name%' ORDER BY $or $place"; $result = $nav->execute($sql, $db, "mysql"); $rows = mysql_num_rows($result); for ($y = 0; $y < $rows; $y++){ $data = mysql_fet

[PHP-DB] Re: multiple queries

2002-05-29 Thread Dan Koken
x27;$project' = 'Pre-Approved' ORect... "; $result = mysql_query($sql); $record_count = mysql_num_rows($result); HTH Good luck Dan.. === Natividad Castro wrote: > Hi to all, > I have a search form where users can search project b

[PHP-DB] Re: display 4 at a time

2002-05-30 Thread Dan Koken
ection); while ($row = mysql_fetch_array($mysql_result) { $prod_name = $row["prod_name"]; $prod_image = $row["prod_image"]; $prod_ID = $row["ID"]; echo "$prod_name"; } $page += 4; echo " "; ?> -------

[PHP-DB] RE: [PHP] date problem

2002-06-06 Thread Dan Hardiker
[rtfm for more details] rather than pulling the rows. From here it looks like your fastest option, but your not providing enough information. -- Dan Hardiker [[EMAIL PROTECTED]] ADAM Software & Systems Engineer First Creative Ltd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] MYSQL Socket error :\

2002-06-21 Thread Dan Harrington
I'm no expert on XP, but you may want to check the firewall settings, to make sure that windows XP isn't preventing the connection. For the $host, you may want to either use 'localhost' or 127.0.0.1 Cheers, Dan > -Original Message- > From: Marco Lanin

[PHP-DB] Re: subtracting one query from the other

2002-06-27 Thread Dan Koken
= second_record.id ORDER BY something HAVING first_id = NULL Here only the second_records will be selected if there is no matching first_record. HTH.. Good luck .. Dan - Harpreet Kaur wrote: > Please help, I am stuck and my mind is frozen. > > I want to sub

[PHP-DB] Re: resizing images comming out of blobs

2002-07-05 Thread Dan Koken
_image is name of blob field from the DB ----- HTH.. Good luck.. Dan. === Andy wrote: > Hi there, > > I am wondering how to resize an image which is stored in a mysql blob field. > > With files this workes just fine, but

[PHP-DB] Re: PDF

2002-07-08 Thread Dan Koken
. and hope this helps in some way. Have a great day... Dan Natividad Castro wrote: > Hi to all, > How can I display info in a PDF? > All I need is to be able to read from a table and display fields into a PDF. > Before, I had my DB in Microsoft Access, so I bounded all the fields in a &g

[PHP-DB] Re: bouncing an idea...

2002-07-10 Thread Dan Koken
To get around it, I wrote my own, and it does not require any site to have the font on their system in order to work. Hope this helps some. Have a great day... Dan. = Kirk Babb wrote: > I'm a grad student with a university medical

[PHP-DB] Re: Construct, Q+E, QBE

2002-07-18 Thread Dan Koken
"; $where_and = ' AND '; } $sql = " SELECT * FROM customers $compare"; You could let them put in the compare such as '<=' and use a single input field for price, but I found I had more problems trying to explain that to users. That's your choice. However

[PHP-DB] Re: n00b deleting entries from db.

2002-07-28 Thread Dan Koken
es. One to get the number of records and the other to substitute the variable $num_records into the DELETE as DELETE from file file limit $num_records - 75, $num_records HTH Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: adding a space in mysql

2002-07-31 Thread Dan Koken
Ron I do believe that placing a space in '%$var %' will do the same as a varchar and sprip it off the end. Not positive. However I believe something like this will do the trick: SELECT something FROM a_file WHERE replace(CONCAT_WS('','.',a_file.field,'.&#x

[PHP-DB] Re: adding a space in mysql

2002-07-31 Thread Dan Koken
Ron Wallace wrote: > thanks, helpers, but I think I have a simple solution: > I will insert a space at the front of the string, > where the db must accept and retain it. > > BTW, here is the SQL I am working with: > // > elseif ($desc==desc) { > $sql="

[PHP-DB] Re: Select * from t1.id where not equal to t2.id ???

2002-08-03 Thread Dan Koken
Dave, Try something like this: SELECT * FROM t1 LEFT JOIN t2 ON t2.id = t1.id WHERE t2.id is NULL HTH. Dan. Dave Carrera wrote: > High all > > I cant seem to get this sql working. > > I am trying to pull everything from table 1 (t1) where t1.id is not > equal to table

[PHP-DB] Re: select distinct with all columns

2002-08-12 Thread Dan Koken
SELECT * FROM equipement WHERE class = "microphones" GROUP BY type; Russ Arbuthnot wrote: > I have a mysql table named "equipment" with 11 columns named: id, > staff_member, class, type, manufacturer, model, description, picture, > created, modified, and published. > > I'm trying to write a

[PHP-DB] gd Library config problem.......

2002-08-21 Thread Dan Kelly
psa/mysql' '--with-iodbc=/home/builder/psa-patch/psa/apache/../release/lib/libiodbc' '--with-imap=/home/builder/psa-patch/psa/apache/../release/lib/imap-cclient' ~~~~~~~~ Notice that it say

[PHP-DB] Re: Charts...

2002-08-21 Thread Dan Koken
placing the variable in the height or width and display the one pixel image as such: echo ""; You can stack different colors. But you only get bar graphs. HTH. Dan. James Hatridge wrote: > Hi all.. > > I'm using SuSE 8.0, mysql, and PHP4. Is it possible to make charts w

[PHP-DB] Re: New to PHP & mySQL

2002-08-25 Thread Dan Koken
Ray, Why not just simply give them a list of available times that meet their number of days requested starting with the day they ask for. Would look something like this. HTH. Dan. Have a great day. -- "; $sql = " SELECT DATE_ADD(prev_end.bookin_start,

[PHP-DB] Query display question

2002-08-26 Thread Dan J.
Hello, I am some what new to php. I have an odbc query written and it displays like I want it to but... I want to be able to setup a next / prev button when say records = > 10. How would I go about this? Thanks Dan J. -- PHP Database Mailing List (http://www.php.net/) To unsubscr

[PHP-DB] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
cause of this, I would like to hear back commentary back on any suggested recourse from those who've done this already. Hopefully this will prove to be a useful change, and people will be happy :) As always send your comments to me. >------

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
r something like that, to allow me to keep it in a different release schedule (as ODBC standards don't change that rapidly). But I've heard some complaints against such ideas, so I haven't pushed it (yet). Anyways naming convention can be changed very easily. >-----

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
st sense and be the easiest to support on our end of things. >-------< Dan Kalowsky"I'll walk a thousand miles just http://www.deadmime.org/~dankto slip this skin." [EMAIL PROTECTED]-

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-11 Thread Dan Kalowsky
bc functions stay odbc_*, rather than to start > iterating through odbc2...odbc3 and so forth. Don't know an easy > solution right now. > Shane Shane, I agree that the naming convention should stay the same. I'm only calling it that now so I can test it and reference it with oth

Re: [PHP-DB] Getting a list of MSSQL databases

2002-09-17 Thread Dan Healy
Thanks That will work for me Dan "Ryan Jameson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... I believe you'll have to do this: "select * from master.sysdatabases" :-) <>< Ryan -Original Message- From: Dan Healy [mailto:[EMAI

Re: [PHP-DB] Need help urgent!!

2002-09-26 Thread Dan Brunner
Check your register_globals value in your PHP.INI!! Dan On Thursday, September 26, 2002, at 11:48 AM, [EMAIL PROTECTED] wrote: > I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars > from > 1 php to the other how i fix it? > > Thanks > >

[PHP-DB] with-oci8 and RedHat distribution

2002-09-28 Thread Dan Trottier
r' '--with-unixODBC=shared,/usr' '--with-apxs=/usr/sbin/apxs' I've installed Oracle 9i on this system and I want PHP to use the OCI8 extension. Unfortunately the configure options above have --without-oci8 defined. I didn't install all the development packages which I now regret. Documentation indicates I need to recompile php with --with-oci8=$ORACLE_HOME to get this to work. If I try to use the same configure options as above I end up having to extract tons of RPM packages. Can anyone suggest what a reasonable set of configure options are or possibly a list of all RedHat RPMS that would need to be installed in order to configure php with the same options as in the default distribution. Any help or pointers would be appreciated. Thanks, dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Mysql vs postgresql

2002-10-01 Thread Dan Koken
are needed. Maybe the new release of mySQL with sub-selects and transaction processing will compare favorably??? Donno?? Anyway that was my experience.. hope it helps. Have a great day... Dan Gabi Munteanu wrote: > I would go for postgresql. > Reasons? > > triggers,procedures,a

[PHP-DB] Re: Print data

2002-10-25 Thread Dan Koken
nt by using the print button. HTH... Have a great day... Dan José Moreira wrote: hello, at my company we have several network printers and i was was wondering if it's possible to print directly to them using PHP, instead of showing on the screen or both ... to gain more control on what

Re: [PHP-DB] uploading

2002-11-05 Thread Dan Brunner
?> $pic comes from a form...I strip out any unwanted junk( it's better when you want to display the file)I insert the Data to the Database, including the file's locationand copy the file where it belongs... The actual file is uploaded into a temp directory..you have t

[PHP-DB] mysql_select_db() and mysql_query()

2002-11-29 Thread Dan Martin
mysql_num_rows($result); I've search my references and the PHP Manual, but can't seem to figure this out. I'd be grateful for a reference or guidance. Thanks, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Solaris 2.6, PHP 4.0.4pl1, Solid EE 3.51

2001-04-03 Thread Dan Kalowsky
rt would be good. The mailing list archives and cvs logs are a good source. The php documentation is fairly upto date as well. -- Dan Kalowsky "Tonight I think I'll walk alone, Worldgate Communications I'll find my soul as I go home." Software Engi

Re: [PHP-DB] IBM DB2 connectction problems

2001-04-06 Thread Dan Scott
ariable before you start your webserver: . /home/db2inst1/sqllib/db2profile Dan ManieQ wrote: > OK, here are some important details about my system: > > 1. Linux (Mandrake 7.2) > 2. Apache 1.3.14 (from distribution) > 3. jre118 (rpm, IBM version) > 4. IBM DB2 V7.1 >Installe

[PHP-DB] Error in non existing line

2001-04-06 Thread Dan Guja
Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90 And I have just 89 lines Here are the last linse from index.html: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] Re: Help please

2001-04-10 Thread Dan Fitzpatrick
d FROM users WHERE username='$uname'",$db); Hope this helps. Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

  1   2   >