RE: [PHP-DB] MySQL

, formation) VALUES ('$kwo', '$lsd', '$date', '$well', '$field', '$uni', '$license', '$formation') -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED] Sent: August 1, 2003 12:15 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL On Saturday 02 August 2003 01:46, Jeff wrote: I

Re: [PHP-DB] MySQL

] On Saturday 02 August 2003 01:46, Jeff wrote: I tried doing this through the news server, but something messed up. I just need to know how to make an HTML form write to a MySQL DB. This is what I have so far. [snip] And does it work? If it works then congratulations. If it doesn't work

Re: [PHP-DB] MySQL

Oh, and another thing, in this book I have, they say to give the forum action ?php echo $PHP_SELF ?. Yet it dosn't give a value to $PHP_SELF. IS this correct? Jeff [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] K, that got my a bit further, now it shows half the page but stops

Re: [PHP-DB] MySQL

in message news:[EMAIL PROTECTED] Myfault.. you should be using link_id instead of dbHandletry this: $result = mysql_query($strSQL, $link_id) OR DIE(Error retrieving records.); Quoting Jeff [EMAIL PROTECTED]: K, that got my a bit further, now it shows half the page but stops

[PHP-DB] MySQL Returns Error

Hi... again. :P Been working on this code all weekend, and I did take everyone's advice, but I'm still getting the same error. Error retrieving records. From line $result = mysql_query($query, $link_id) OR DIE(Error retrieving records.); of my code. When I first put the insert query in, it

Re: [PHP-DB] MySQL Returns Error

, shut_time DATE DEFAULT '-00-00' NOT NULL, pres VARCHAR(15) NOT NULL, tag VARCHAR(15) NOT NULL, PRIMARY KEY (lsd), UNIQUE gradient (gradient) ); Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wednesday 06 August 2003 01:14, Jeff wrote: Well I did what you said

Re: [PHP-DB] Sorting issue

Thank you EVERYONE.. AGIAN! *grin* John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Jeff wrote: Yes duh... I didn't realize numbers weren't considered characters. What's the sql entry for numeric characters? I'm new at this, and figure I'm not doing to bad

[PHP-DB] Sorting issue

that forces it to look at the entire record before sorting it? Thanks Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Sorting issue

kwo isn't sorting properly... actually, I need to retest the lsd column too. John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Jeff wrote: $query = SELECT kwo, lsd, date, event FROM $gradient_tablename $order_by_str

Re: [PHP-DB] Sorting issue

Seems like changing the mixed fields back to VARCHAR worked! Thanks again guys! David T-G [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Sorting issue

Yes duh... I didn't realize numbers weren't considered characters. What's the sql entry for numeric characters? I'm new at this, and figure I'm not doing to bad so far. . John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Jeff wrote: kwo VARCHAR(10) NOT NULL, lsd

Re: [PHP-DB] Sorting issue

. To: 'Jeff'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Sorting issue Seeing code might help us. Aaron -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: August 8, 2003 10:44 AM To: [EMAIL PROTECTED] Subject

Re: [PHP-DB] MySQL Returns Error

I tried putting that in a few diffrent places, same result - is there somewhere special I need to put that? Matt Schroebel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:15 PM

Re: [PHP-DB] MySQL Returns Error

Oops, my mistake, it's not a blank entry - it re enters the last entry. I can hit F5 or click refresh 1000 times and it will enter the last entry 1000 times. Jeff [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I tried putting that in a few diffrent places, same result

Re: [PHP-DB] MySQL Returns Error

this. This is how I have handled it in the past though. -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:52 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Oops, my mistake, it's not a blank entry - it re enters the last

[PHP-DB] Modify MySQL Record

Hell! I'm having a small problem with modifying the data in a MySQL DB. And here's the error: (After I click the Submit Changes button) Error: 1064: You have an error in your SQL syntax near '(10-10-10-10)' kwo='1235', lsd='10-10-10-10', date='2003-05-05', well' at line 1 Here's the code:

Re: [PHP-DB] Modify MySQL Record

' ; $field_str .= perfs = '$perfs' ; $field_str .= event = '$event' ; $field_str .= fluid = '$fluid' ; hth Jeff Jeff [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc

Re: [PHP-DB] Modify MySQL Record

exactly what it's sending to the database. Might give you the answer right there. -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 12:35 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Modify MySQL Record Yah, I noticed that after I had

Re: [PHP-DB] Modify MySQL Record

be solved as soon as I get that one field to auto populate. :P Richard Hutchins [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Jeff, No problem. Happens to everyone, trust me. Anyway, I see you're using mysql_affected_rows($link_id) to get see how many rows were affected by the UPDATE

Re: [PHP-DB] Modify MySQL Record

'); $result = mysql_query($query, $link_id) OR die(mysql_error()); gradient - the auto increment field. Richard Hutchins [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Jeff, When you want to increment an autoincrement field, you just put NULL into the query. For example: INSERT

[PHP-DB] accessing mysql on non default port - windows

application needs to reside on windows and communicate with *nix. If this doesn't work, i guess i could use IPTables to NAT when requests come in on certian IPs? THanks for any assistance/advice you may have. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] accessing mysql on non default port - windows

Jason Wong wrote: On Sunday 06 February 2005 04:58, Jeff wrote: Hi. I need to access mysql from windows to *nix on both the default port of 3306 and a secondary port of 3307. php.ini states that win32 will only pay attention to MYSQL_PORT. Just specify the port you want to use in mysql_connect

Re: [PHP-DB] accessing mysql on non default port - windows

Jason Wong wrote: On Sunday 06 February 2005 07:59, Jeff wrote: OK, but my understanding was that your mysql server is on *nix, and your problem was accessing it from a windows client. So you should not be using localhost? I just did that for a test to remove the remote connection from

Re: [PHP-DB] accessing mysql on non default port - windows

thats no good. man if its something simple, i'm not seeing it. well it was something simple...and now i see it. old_passwords. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

Greetings, On 01/26/2016 08:18 AM, Karl DeSaulniers wrote: > On Jan 26, 2016, at 7:10 AM, Alko Kotalko wrote: > >> Hi, >> >> I have a working connection from PHP to SAP HANA through PDO and regular >> ODBC commands. >> [...snipped...] >> >> For example: >> "SELECT *

Re: [PHP-DB] mysql to pgsql

create table foobar (todaysdate datetime default now()); jeff On Sun, 4 Feb 2001, phobo wrote: Never used pgsql; but try DEFAULT NOW() NOT NULL ?? Siggy - Original Message - From: "Cameron" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 04, 20

Re: [PHP-DB] pgsql performance

Hi Cameron, One thing you may want to try is the -F tag on startup this disables disk syncs but is mostly benificial for writes, versus reads. Also remember that alot of PgSQL's speed benefits become aparent with large numbers of concurrent users. Jeff On Tue, 6 Feb 2001, Cameron wrote

[PHP-DB] RE: [PHP] Query - Grouping Results

this. (Jackson Structured Programming fans - all together now...) Regards Jeff --- ?php # Set these up with the right values $host = 'localhost'; $user = 'me'; $password = 'mine'; $database = 'thedb'; $sql = 'select * from

[PHP-DB] RE: [PHP] Query - Grouping Results

how about something like select distinct name, date_format(time, "%W %D %M %Y") as login from users, user_logins where user_logins.user_id = users.id order by name,time -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19,

[PHP-DB] MySQL for Billng Question

I want to have a database for my hours for my clients. I want to create a report where it shows only the hours back to the last time I was paid. I have no idea how to go about this. Any help would be appreciated. Jeff Oien PHP start here http://www.webdesigns1.com/php/ -- PHP Database Mailing

RE: [PHP-DB] HELP: Eporting data from mySQL with PHP

Hello, I'm trying to figure out how to get the data out of a table in a format which I can easily import into excel. I wanted to have tab delimited fields enclosed by quotes. I'm not sure how to do this? I check the mySQL doc and saw the mysqldump call but haven't found any mention of

RE: [PHP-DB] PHP an MySQL

I would recommend the first two books listed on this page: http://www.webdesigns1.com/php/books.php I've read both. Jeff Oien Can someone recommend a book that shows how to use PHP and MySQL. I need to see how to pass parms from a form to a PHP so I can Update, Add and Delete records

[PHP-DB] Encode/Decode Secure Enough?

Are encode and decode secure enough for storing credit card numbers on a Web server? Jeff Oien -- 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

Re: [PHP-DB] Escape for MSSQL?

al/en/function.addslashes.php -- Jeff Carnahan - [EMAIL PROTECTED] -- 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]

Re: [PHP-DB] Escape for MSSQL?

y PHP function addslashes() } }http://www.php.net/manual/en/function.addslashes.php } My apologies, you said MS-SQL.. Not MYSQL.. =) See: http://msdn.microsoft.com/library/wcedoc/adoce31/adoguide_27.htm =) -- Jeff Carnahan - [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.ph

[PHP-DB] INSERT Problem

(First_Name, Last_Name) VALUES (\Jeff\, \Oien\); $result = mysql_query($sql,$connection) or die(Failed); or $sql = INSERT INTO $table_name (First_Name, Last_Name) VALUES (\$First_Name\, \$Last_Name\); $result = mysql_query($sql,$connection) or die(Failed); yet this will work from the command line

RE: [PHP-DB] INSERT Problem

OK, did that and it's just printing the INSERT command back to me. INSERT INTO OVEvents (First_Name, Last_Name) VALUES(Jeff, Oien) Any help from here? Thanks. Jeff Oien HINT echo $sql; /HINT always helpful, then paste that into the command line client and check the error Cameron

RE: [PHP-DB] INSERT Problem

That told me my problem. Thank you! I hadn't selected the database in my connect include but had it in other scripts and not this one. Long story but thanks for the help. I can stop banging my head now. Jeff Oien on 5/9/01 12:29 PM, Jeff Oien at [EMAIL PROTECTED] wrote: Am I missing

[PHP-DB] Autoincrement Question

If I have a database that has three records and I delete the entire third record, when another record is then added will the auto_increment number be 3 or 4? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

[PHP-DB] MySQL Connect Problem

. Typical code: ? $connection = @mysql_connect(localhost, jeff, *) or die(Couldn't connect.); if ($connection) { $msg = success!; } ? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

RE: [PHP-DB] MySQL Connect Problem

Yes they are. Jeff Is the MySQL and Apache running on the same machine? Jeff Oien wrote: I have MySQL on a new Win2000 install and can't connect to it using PHP. I am able to connect using the command line. I'm not sure what the next step is to troubleshoot. I've checked the username

RE: [PHP-DB] MySQL Connect Problem

Used Prompt in Win2k. Moved to the apache/mysql/bin directory and typed mysql. Jeff Oien You said you could connect through the command-line. How did you do that? Jonathan Here is sample code: ? $connection = @mysql_connect(localhost, jeff, *) or die(Couldn't connect

RE: [PHP-DB] MySQL Connect Problem

Yes it is running. I don't need to use a password when running from the command line but I am when connecting through PHP. This is exactly how I did it on my Win98 machine but it isn't working with W2k. Jeff Oien Well the mysql tool doesn't need any authentication usually when you first set

RE: [PHP-DB] MySQL Connect Problem

Here is sample code: ? $connection = @mysql_connect(localhost, jeff, *) or die(Couldn't connect.); if ($connection) { $msg = success!; } ? This is on my machine only used by me. I also tried connecting to IP address and 127.0.0.1 and it still won't work. Thanks. Jeff

RE: [PHP-DB] MySQL Connect Problem

I tried your code and got this: Warning: Can't connect to MySQL server on 'localhost' Also tried ip address of my machine. So at least maybe that narrows down the problem. Jeff Oien Hi Jeff, I am using Windows, but am a beginner. Here is some code I use maybe it will help I use

[PHP-DB] Parsing Error

the following webpage. What am I doing wrong? !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd; html head titleTitle/title /head body ?php $hostName=localhost; $userName=jeff; $password=jeff; $databaseName=jobs

Re: [PHP-DB] Parsing Error

Thanks Larry. Now I am getting a printf too few arguments error on this line: printf(A HREF=\mailto:[EMAIL PROTECTED]?subject=$store\%20$jobdesc\;$jobdesc/ABR\n); Thanks, Jeff Larry Rivera [EMAIL PROTECTED] wrote: After a brief look it appears that your call to mysql_query is incorrect

[PHP-DB] Re: Installing PHP3 with mysql support on MOSXS

. Jeff -- 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]

[PHP-DB] Alternating Values

in Group1 is Rm101, this person be assigned Rm102 with that equation being in the PHP script? If that's the case would I retrieve all the records for Group1 and find the largest ID (auto_increment type)? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

[PHP-DB] Need a shopping cart

is Windows NT 4 with PHP 4 and PERL 5. I sure hope someone can help. Thanks in advance. Regards, Jeff [EMAIL PROTECTED] - ICQ UIN: 736807 Training, Web Hosting and Design http://www.HookedOnThe.Net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] Inserting Variable Variable?

Hi, I'm not quite getting it. If $x is 1 here is what happens. $varname = C_First_Name.$x; echo $$varname; then $$varname prints as $C_First_Name1. However $C_First_Name1 prints the contents of the variable. Jeff Oien Hi Jeff. $varname = C_First_Name.$x; // e.g. if $x == 3

RE: [PHP-DB] Inserting Variable Variable?

I found a solution but not sure if it's the most efficient. I need to first define a simpler variable: $C_First_Name = ${C_First_Name.$x}; then INSERT VALUE $C_First_Name. Jeff Oien Hi Jeff. $varname = C_First_Name.$x; // e.g. if $x == 3 then ... echo $$varname; // ... prints

[PHP-DB] Only Insert on Error?

I can't figure this out. The first code works as far as inserting into a MySQL database with the !result error checking. The second with the error code commented out doesn't. I can't figure out why. Jeff Oien if ($M_First_Name) { $sql = INSERT INTO $table_name (First_Name, Last_Name

RE: [PHP-DB] MySQL Timestamp

Thanks. I was using MySQL by DuBois book as a reference. Jeff According to the manual, 12 is YYMMDDHHMMSS and 14 is MMDDHHMMSS. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DATETIME Jeff Oien [EMAIL PROTECTED] wrote: I have a field that's timestamp(12

[PHP-DB] Re: Installing PHP3 with mysql support on MOSXS

undefined symbol: _strtol Aborting. Has anyone an idea what's going wrong? Try running the configure with --with-mysql and not including the path. That will use the internal mysql libraries that PHP has. It worked for me. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Limit Select Field Characters?

I have a timestamp field that looks like this 0109011754 but I only want to compare 010801 when doing a SELECT. Is there a way I can do this? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP-DB] Inserting NULL?

I have a variable that is either Yes or No. I would like NULL to be inserted if it's No. Can I do this? if ($variable == 'No') { $variable = 'NULL'; } then INSERT it. Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] Averaging Numbers

the numbers fine, I just don't know how to go about putting these all into variables or an array or if I can do this within a query and then take an average for them. Hope that made sense. Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] Averaging Numbers

something like this for months. Cheers (and apologies!) Russ I have a cron job that runs on a Unix server that runs a PHP file that gets a number from a Web site and inserts it into the database. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP-DB] Averaging Numbers

That's exactly what I needed. Thanks. I'm absolutely awful with math and this is my first time averaging numbers from a database. Jeff Oien Maybe I am missing the complexity but I would just add them all up as you retrieve them (or where you are printing them out) and then when you finish

[PHP-DB] Query and Date problem

) code in question When I print $today it's: 2001-08-15 and the date field in the database is also displaying as 2001-08-15. Any suggestions? Thanks in advance. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

RE: [PHP-DB] Re: Query and Date problem

Jeff Oien [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I want to retrieve the last 15 days of data from a certain time but not today's. I have this but it's still giving me today's data: $today = date(Y-m-d); $sql = SELECT volume, date,

[PHP-DB] Photo Album Schema

I want to make a photo album that will have users who sign up to create an album and then have the albums open to the public. I was thinking of doing it like this but I've never done a relational database before so if anyone thinks of anything I should change please let me know. Thanks. Jeff Oien

RE: [PHP-DB] Photo Album Schema

Thanks for the suggestion but this is a personal project to be used for learning and as a place for friends to post photos with only the features that we all want. Jeff Oien This has been done. see http://www.photopoint.com This is a free service available to the public. rick Richard

RE: [PHP-DB] Photo Album Schema

I should have said photo_filename. That was what I intended to do. Would you suggest one directory for all photos or separate directories for each user? Jeff Oien Rick: I don't see any .php tags there... plus just because someone else has done it doesn't mean he can't do it as well

[PHP-DB] Date_Format Question

I have a date like this in date format in MySQL 2001-08-29 and I want it to say August 29, 2001 I tried this and it didn't work. select date_format('creation_date', '%b %D, %Y') from Chart_Users; Could you tell me what I'm doing wrong or how I should do this? Thanks. Jeff Oien -- PHP

Re: [PHP-DB] Date_Format Question

date_format(creation_date, '%M %D, %Y') as creation from Chart_Users; Jeff Oien Jeff, mysql select now(); +-+ | now() | +-+ | 2001-08-29 21:21:50 | +-+ 1 row in set (0.00 sec) mysql SELECT DATE_FORMAT(NOW(), '%b %D, %Y

[PHP-DB] Previous | Next (Again)

is the second etc. and know which the current one is if the id field has gaps in it. Not sure if that made any sense. Jeff Oien -- 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

[PHP-DB] Password Question

they use for other things I think it would be best for it to be encrypted. Jeff Oien -- 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]

RE: [PHP-DB] Password Question

I like the new password idea. How do I make sure it's them who's creating a new password so that someone else doesn't maliciously change their password? If someone knew someone's username and e-mail address I would think they could change it. Thanks. Jeff This doesn't seem to solve his problem

RE: [PHP-DB] Previous | Next (Again)

but this I'm just clueless. Jeff Oien I would add the field picnumber int or something to your DB. This is where the pic falls in the order of pics in the album. The the previous and next should be as simple as doing select picnumber,piclocation from album where user=$user and (picnumber=$number-1

RE: [PHP-DB] Previous | Next (Again)

into an array? Thanks for the help. Jeff Oien I don't know of a way to do the insert in a single query (anyone?!?) with this... but assuming the fields in pic are id int PRI location varchar(30) picnumber int user varchar(20) $query = Select max(picnumber) from pics where user=\$user\; $dbq

[PHP-DB] Parsing Error

\IModify/I/A/ A HREF=\delete.php?rowid=$rowid\IDelete/I/A /TD /TR\n; } echo /TABLE; mysql_free_result($result); ? BRBR A HREF=internal.htmlReturn To Main Menu/ABR A HREF=add.phpAdd An Item/A /body /html -- Jeff Grossman ([EMAIL PROTECTED]) -- PHP Database Mailing

[PHP-DB] Forms Question

the value that is in the database. Can I use a drop down menu, or should I just go to radio buttons? Thanks, Jeff -- Jeff Grossman ([EMAIL PROTECTED]) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

[PHP-DB] Mail() function and the php.ini file

I'm attempting to setup the PHP module to allow the mail() function to work. As I understand, I need to edit the php.ini file? I can't locate the file to edit. Can someone point me in the right direction? I'm using OSX Server. Thanks, Jeff Panis [EMAIL PROTECTED] -- PHP Database Mailing List

[PHP-DB] Unwanted Column Updating

something? Jeff Oien -- 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]

[PHP-DB] How to put data

Hello How do you Normal put you mysql data in to a php table. Jef -- 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]

[PHP-DB] GREATEST, LEAST

Could anyone give me an example of how to use GREATEST and LEAST in a MySQL query. I want to look through the last 15 records in a certain field and find the highest and/or lowest number. Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Speed Up Code?

this more efficient? http://www.webdesigns1.com/temp/code.txt Jeff -- $table_name = Chart_Users; $sql = SELECT * FROM $table_name order by album_title; $result = mysql_query($sql,$connection) or die( Couldn't execute query.); //if(! $result = mysql_query($sql

RE: [PHP-DB] Re: Speed Up Code?

= stripslashes($title1); $date1 = $row['date1']; $cnt = $row['cnt']; $display_block .= trtd nowrap align=\left\ ba href=\display_album.php?id=$id\$titlenbsp;/a/b/td td align=\left\$cnt/tdtd align=\right\ nowrap$date1/td/tr; } Hi Jeff, the most important rule you should follow: don't

[PHP-DB] MySQL to Email and Line Breaks

and those \n show up in the database data. I must be missing something. Thanks for any help. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] MySQL to Email and Line Breaks

This isn't what I'm looking for because the output is to email not HTML. What I would like is the natural line breaks in the form input to be preserved and then result in line breaks in the email without having to add any \n, which didn't work anyway. Jeff Oien check out nl2br() function

RE: [PHP-DB] Re: MySQL to Email and Line Breaks

I tried wrap=hard already. I should have mentioned that. Sorry if this is off topic. Jeff Oien You need a wrap= within your textarea.. You may need a couple if the browsers haven't come together on it yet.. But you can check it out here: http://www.blooberry.com/indexdot/html/tagpages/t

RE: [PHP-DB] MySQL to Email and Line Breaks

these breaks? I can't find any \n in the data. Then when it's sent via email of course there are no line breaks displayed. Jeff Oien Hiya, If I remember correctly, you much send both \r and \n to terminate a line on an e-mail, regardless of the platform. This should include the header

[PHP-DB] DISTINCT Question

How can I do a query for a distinct field plus get the info from other fields? I tried this: select DISTINCT email, name_first, name_last, id from applicants; and it gave me everything. Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Re: WELCOME to php-db@lists.php.net

by PHP after pulling the data out of mysql? Any help I can get on this would be greatly appreciated. Thanks. -Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] replication questions

. Does this make sense? Anyway, I hope I've made this clear enough for someone to jump with answers and comments. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Weird intermittent No Database Selected problem

is appreciated!! Thanks! Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: [PHP] Weird intermittent No Database Selected problem

or something holding open previous connections to the db and the script just connecting to the last connected db. Anyway... Sorry for the trouble! Jeff -Original Message- From: hugh danaher [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 5:37 PM To: [EMAIL PROTECTED] Cc: php

[PHP-DB] how to update a text BLOB in ODBC?

hi, i am having the devil of a time with this. have been researching it for 3 weeks. have posted to php.faqts.com (no answer), looked a million times on php.net, and www.borland.com/interbase, written people email (no response!) and even tried to get the people at easysoft to answer (they are

Re: [PHP-DB] how to update a text BLOB in ODBC?

thanks for the correction, miles and martin.. just an email typo. i still have the problem though. :( -- Jeff Stern 949-824-2326 [EMAIL PROTECTED] Social Sciences Computing Services University of California, Irvine 3151 Social Science Plz Irvine CA 92697-5100 On Tue, 19 Nov 2002

Re: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

try : if (strlen($products) == 0) { echo nothing entered in field; } http://www.php.net/manual/en/function.strlen.php Jeff - Original Message - From: Aaron Wolski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 3:03 PM Subject: [PHP-DB] checking

Re: [PHP-DB] How to find the last ID?

) VALUES ('$agentname') but I need to find out the ID value it created, how can I do this easily? Thanks Chris --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem with insert query

and line 9 is $query = insert into recipients (recipient_name, recipient_email) values ('friend', '.$mails[$i].'); --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL, PHP, and XML

only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Weird Segfaults with Oracle, PHP, Apache2

fine if you use sqlplus. I'm not sure why it's dying. Has anyone seen anything like this? --- Jeff Harris - Network Engineer Golfsmith International, Inc. CCNP, CCNA

RE: [PHP-DB] Weird Segfaults with Oracle, PHP, Apache2

-Original Message- From: Thies C. Arntzen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 5:33 AM To: Harris, Jeff Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Weird Segfaults with Oracle, PHP, Apache2 On Tue, Jul 08, 2003 at 05:51:47PM -0500, Harris, Jeff wrote: We're

[PHP-DB] RE: Weird Segfaults with Oracle, PHP, Apache2

/libpthread.so.0 #0 0x407a5582 in sskgmstat () from /opt/oracle/OraHome1/lib/libclntsh.so.9.0 -Original Message- From: Harris, Jeff Sent: Tuesday, July 08, 2003 5:52 PM To: '[EMAIL PROTECTED]' Subject: Weird Segfaults with Oracle, PHP, Apache2 We're getting segfaults (11) when we try

[PHP-DB] Newbee: Array Field Separator: \035

the gdbm file do I have to stick with dba_* calls or are there other function I can use to process the data? Thanks, Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Newbee: Array Field Separator: \035

I figured out the field seperation on my own. Thanks anyway, jeff Jeff Langley wrote: Hi, I am reading an already created gdbm file with dba_fetch into an array. I am able to print out the array but not the individual elements. The elements are separated with ascii \035. How would I

  1   2   >