Re: [PHP-DB] Editing/Updating Data with Forms

Sounds like you're more in need of a consultant than a mailing list.. Bob - Original Message - From: "Evans, Josh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 8:30 AM Subject: [PHP-DB] Editing/Updating Data with Forms > C

Re: [PHP-DB] saving details problem (big)

.. Something's not working right here.." ); //put code here to go do the postcode lookup showResults(); } ?> Just an idea.. Hope it will help or jog something.. Bob Weaver > I am making use of AFD postcode lookup application. > What it dose is ask for your postcode and r

RE: [PHP-DB] Stuck on db entry from select box...

les\""; $result = mysql_query($sql, $connection); $error = mysql_error(); if( eregi( "uplicate", $error ) ) echo( "Sorry, $files is already in the database." ); else echo( "$files added to database successfully." ); echo( "Add another file?" ); } ?> But it is your project... Later, Bob Weaver -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Stuck on db entry from select box...

sql_query($sql, $connection); $error = mysql_error(); if( eregi( "uplicate", $error ) ) echo( "Sorry, $files is already in the database.\n" ); else echo( "$files added to database successfully.\n" ); echo( "Add another file?" ); } ?> Later, Bob - Original Message

Re: [PHP-DB] Stuck on db entry from select box...

Bug report: You'll need to add another = to the if test.. if( $number == '0' ) $sql = "INSERT INTO $table_name( files ) VALUES( > \"$files\" )"; Dumb mistake.. Bob - Original Message - From: "Bob" <[EMAIL PROTECTED]> To: "ja

Re: [PHP-DB] tnsnames.ora + Apache & symbolic links

It is. You can override it in the conf file however. Later, Bob - Original Message - From: "Florian Clever" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 5:33 PM Subject: [PHP-DB] tnsnames.ora + Apache & symbolic links >

[PHP-DB] MySQL enum displaying values in Select

Hello, I have a problem I can't seem to overcome. Maybe it's just something simple but for some reason I am unable to read in values from a mysql db column (enum) and display the results in an option box. I can display the values to the screen but I can't seem to get them into the option box. Th

[PHP-DB] Populating multi-select list from mysql

Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = "SELECT category

RE: [PHP-DB] Populating multi-select list from mysql

Thanks for all the help. I got it working using the following code from Martin. Rob. $sql = "SELECT category FROM categories"; $result = mysql_query($sql, $connection); echo "\n"; while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category = $row['category']; echo "$cat

Re: [PHP-DB] Query Access DB by date

s it doesn't know what >I'm asking for. I'm confused. Thanks. The pound sign is correct. If your query doesn't work with the pound sign, then the problem is elsewhere. Post an example of your code. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection.

Re: [PHP-DB] foreign key problem

/foreign key relationship, you will have to specify what RDBMS you are using. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

RE: [PHP-DB] foreign key problem

Yes sir, you are correct. Thank you for correcting me. In practice, a NULL in a foreign key almost always means an orphan record. In most applications the designer will want to use the NOT NULL constraint. Bob Hall >A foreign key value can be null, if it suits the data application - or t

Re: [PHP-DB] the SET datatype

s table B changes. Is there anyway of doing this? > >Please help? > >[EMAIL PROTECTED] No sir. The members of the SET have to be entered as constant values in the column definition. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak --

Re: [PHP-DB] rewriting this query to remove IN

anybody have any ideas, thanks for this guys. Any help is much >appreciated. > >Scott Mebberson Sir, I can't offer suggestions without knowing what the subquery is. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak -- PHP Da

Re: [PHP-DB] composite keys

PRIMARY KEY () This is covered in the online manual. If you want to use an auto_increment field as the primary key, you can insure uniqueness in the SportName and TeamName fields by declaring a UNIQUE INDEX in the same way. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspecti

Re: [PHP-DB] MySQL execution order...

Sir, it would help to see the INSERT statement and the table definition. Bob Hall >I sent this message to the "general" list yesterday, and have yet to get an >answer (except for that Spanish "Snow White" virus attempt from Peru). > >I'm trying to downloa

Re: [PHP-DB] Join causing Error?

;s not the problem, since you say you did it in the query that worked, but I don't see the point. Bob Hall >Can anyone tell me why this: > Line 282mysql_select_db("centraldb",$db); > Line 283$qorder++; > Line 284$result = mysql_query("SELE

Re: [PHP-DB] Tricky database query involving two tables, much more detail

join B on something >where B.thing != "1" or B.thing is NULL > >The problem, again, is that this gets me things that are in B that >don't have a certain attribute...but what I want is things that >aren't in the set of (has certain attribute). > >Here&#

[PHP-DB] How to print last row in an array using WHILE?

w["cert_deg"], $myrow["job_title"], $myrow["institution"], $myrow["address_1"], $myrow["address_2"], $myrow["geo_loc"], $myrow["state"], $myrow["country"], $myrow["zip"], $myrow["phone"

[PHP-DB] Copy data from one mysql table to another?

ne into svt_members. Can you recommend a method? Thanks in advance, Bob Stone __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- PHP Database Mailing List (http://www.php.net/) To unsub

Re: FW: [PHP-DB] SELECT MAX(ID) PLUS 1

the project is in trouble. There's a limit to how much a programmer can do to solve problems caused by bad database design, as you have discovered. Bob Hall >Can anyone help me on this one >Lisa >-Original Message- >From: Walter [mailto:[EMAIL PROTECTED]] >Sent: Wedne

[PHP-DB] How to eliminate bad fields from a mysql query?

uot;institution"], $myrow["address_1"], $myrow["address_2"], $myrow["geo_loc"], $myrow["state"], $myrow["country"], $myrow["zip"], $myrow["phone"], $myrow["fax"], $myrow["e_mail"]); } So if (for instance) a u

[PHP-DB] Strange behaviour of Mysql_fetch_array + Submit button

ether with the quantity given in the correct textfield (I hope you can visualise what I mean). I have added the ADD TO CART code and the main page code below and hope anyone can help me solve this mystery (which it is to me anyway, but hopefully not for you guys). Thanx,

[PHP-DB] Re: [PHP] update count

On 06/16/04 09:53 John Nichel spoke: Bob Lockie wrote: What is the best way to only do an update if it going to update only one row? I want to protect my code so that it won't accidentally update more than one row. I can do a select first but there must be an easier way. :-) U

[PHP-DB] mysql_fetch_object

I'm using $row = mysql_fetch_object and I can reference column names by $row->name but how do I reference a pseudo column (that I make, like substring( name from 1 ))? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql_fetch_object

On 06/28/2004 12:07 PM Larry E.Ullman spoke: I'm using $row = mysql_fetch_object and I can reference column names by $row->name but how do I reference a pseudo column (that I make, like substring( name from 1 ))? Use an alias in your query: SELECT column, DATE_FORMAT('%m', date_column) AS d FROM

Re: [PHP-DB] mysql_fetch_object

On 06/28/2004 12:07 PM Larry E.Ullman spoke: I'm using $row = mysql_fetch_object and I can reference column names by $row->name but how do I reference a pseudo column (that I make, like substring( name from 1 ))? Use an alias in your query: SELECT column, DATE_FORMAT('%m', date_column) AS d FROM

Re: [PHP-DB] mysql_fetch_object

How does it handle fully qualified conflicting columns, like 'select a.name, b.name from a, b'? It won't handle that properly; in your example $row->name would be b.name (it'd overwrite a.name). You have to alias same-named columns. Hans Ok, I don't have that case but I was curious. -- PHP Da

[PHP-DB] mysql limit

If I select rows with a limit clause I need to know if there are more rows than the limit. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] new row object

I use $row = fetch_row_object, array_push($row) and I want to manually insert a row at the end of my array to indicate if there are more rows. Is there a way to create a row object? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: What's wrong with this QUERY?? - Thanks all.

field is probably an integer field and integers do not require quotes. Remember, wrap your strings in quotes and don't wrap your numbers (unless the number is really a string in disquise.) Good luck, Bob -Original Message- From: Harry G [mailto:harry (removethis)@gabha.net] Sent: T

[PHP-DB] RE: Session Values Change

Jacob, Here is my solution. At the top, it checks to see if you are passing a new name via a querystring. If not, it checks to see if a name is present in the session yet. If not, it initializes the session to "Jacob". It puts the session's value into the variable $view. If you passed a name

[PHP-DB] Pear DB and DB_DataObject : recommended?

appy using as others are brought onto this project. Thanks for your thoughts and opinions, Bob S.

[PHP-DB] Time table was updated?

Is there a function available to find out what time a table in a mySQL database was updated? If you can help please mail me at [EMAIL PROTECTED] Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: how to question...

Hi Jas, if I understood your question right, you can solve your problem best with something like the following: Bob "Jas" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ok here is what I would like to accomplish,

[PHP-DB] How to turn off error display

( $result, $i++ ))) { // display what we have // printf/echo stuff } pg_close( $dbcon ); Thanks Bob Parker -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to turn off error display

On Tuesday 16 April 2002 22:30, you wrote: > I believe what you are looking for is: > @pg_fetch_row( $result, $i++ ) > > But check the manual for @. > > =C= > > * > * Cal Evans > * Techno-Mage > * http://www.calevans.com > * Thanks, I think that's it

[PHP-DB] Problems on inserting two tables

que values ($glid); etc that fails because $glid is not initialised. My next attempt was '$sql = select nextval ('serial') as glid;' etc Neither does this initialise $glid. I'm not sure if this is simply a timing problem, or if there is something wrong with my log

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

Pan, It looks as if you may be using FORM with method=get. If so try method=post to get the full data Bob Parker On Saturday 27 April 2002 20:35, you wrote: > From: "Chris MacKenzie" <[EMAIL PROTECTED]> > > > I've come across an interesting problem. I'm try

[PHP-DB] How to force a new browser page?

uuton to return to the original list so I would prefer to open the other pages in new windows. How please? If a web developers list is more appropriate for this question kindly recommend one. Thanks Bob Parker -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: How to force a new browser page?

On Wednesday 01 May 2002 08:15, you wrote: > In article <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] says... > Thanks for the replies on this topis folks. For the moment the http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Dropdown list question...

> I am populating a dropdown list from a database. This is working >fine with one minor glitch... For some reason, the first entry in the >database does not seem to be getting populated into the list. I do not see >anything wrong, and was hoping that someone else might be able to spot a >

[PHP-DB] error messages to variables

"You can suppress the error message on failure by prepending a @ to the function name.". How can you get the error string into a local variable? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

Re: [PHP-DB] Connecting to DB on separate server?

Cassy M Rowe wrote: I have a php page on server #1 trying to access a database on server #2. What do I put in the following blanks: $hostname: ___ (have tried IP, http, localhost, nothing works) $username: blah $password: blah $database: _ $link=mysql_connect($hostname, $u

Re: [PHP-DB] error messages to variables

Jason Wong wrote: On Monday 04 November 2002 12:10, Bob Lockie wrote: "You can suppress the error message on failure by prepending a @ <http://www.php.net/manual/en/language.operators.errorcontrol.php> to the function name.". How can you get the error string into a local vari

[PHP-DB] persistant database connections

I'm using mysql_pconnect(...) at the beginning of a PHP page. Can I safely use mysql_select_db(...) later on the page? I thought I read somewhere that you can't rely on HTML to be rendered from top to bottom. Can I rely on PHP to be interpreted from top to bottom? -

Re: [PHP-DB] Re: persistant database connections

Richard Allsebrook wrote: There's a whole world of difference between 'rendered' and 'processed - the page is processed top to bottom (baring any branching in your php) - and generally rendered from top to bottom - some parts being rendered after as the missing components (images etc) are loaded

Re: [PHP-DB] forum test

Seabird wrote: I'll look into it, thanx, can you access the jump-menu?? Forum should be all the way in the bottom. The jump menu doesn't work. I think you nad a 'name' field for each Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours

Re: [PHP-DB] problem with postgres

ems a while ago using Mandrake and connnecting via localhost. On my setup the user from php was apache. IIRC I ad to create the postgres user 'apache' and provide the necessary permissions on all tables etc. HTH Bob -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to limit a WHILE statement?

quot;salutation"], $myrow["first_name"], $myrow["mid_name"], $myrow["user_name"]); Best regards, Bob Stone __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text

Re: [PHP-DB] Re: PostgreSQL versus MySQL

Doug, You've posted your usual good sense, combined with one statement I strongly disagree with. >One of >these products is a relational database management system. The other is a >quasi-SQL-like-front-end-to-systems-of-indexed-files that has never >concerned itself with things like standards

Re: [PHP-DB] Re: PostgreSQL versus MySQL

>On Sun, 8 Apr 2001, Bob Hall wrote: > > > Doug, > > > > You've posted your usual good sense, combined with one statement I > > strongly disagree with. > > > > >One of > > >these products is a relational database management system

Re: [PHP-DB] Re: PostgreSQL versus MySQL

Doug, There's something wrong here. This is the internet, we're disagreeing, but we're not flaming each other. If we keep this up, they'll revoke all our software licenses because of our noncompliant behavior. >Hi Bob! > >That would make a very interesting study

Re: [PHP-DB] Re: PostgreSQL versus MySQL

>On Mon, 9 Apr 2001, Bob Hall wrote: > > > > MySQL is providing an SQL frontend to a > > >bunch of tables and indices, that is it ... it is up to the programmer to > > >handle the "managing of data" part where it revolves around being > >

Re: [PHP-DB] Select statements - A Quest !!!

which contains the child records. I might be able to figure it out if know what a kaizen is. You haven't declared any primary keys on the employee table, and you didn't say which DBMS you're using. In general, pattern is SELECT dept, Count(p.something), Count(c.something_

Re: [PHP-DB] Help with mysql and php 4.03

move the ON conditions to the WHERE clause. FROM city, state_prov, area_phone, ... WHERE state_prov.state_id = city.state_id AND area_phone.city_id = city.city_id AND ... Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sq

Re: [PHP-DB] SELECT question

. > >Thanks! > >Nick Sir, use GROUP BY and an aggregate function. SELECT items.itemId, description, link, Sum(qty) AS sum_qty, price FROM carts, items WHERE carts.custId = '$custId' AND items.itemId = carts.itemId GROUP BY itemId; Bob Hall Know thys

Re: [PHP-DB] ORDER BY in MYSQL ? 8(

t the end. I know that I have to use the Danish character set to get the correct sort for Norwegian. Check the manual for instructions on changing character sets. It's been a while since I've done it, and I no longer remember how. Bob Hall Know thyself? Absurd direction! Bubbles bear n

Re: [PHP-DB] Use of Like

e language section of the MySQL online manual. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] PHP/Apache not totally closing MySQL connections

as far as it cares (if I "mysqladmin processlist", no connections show up.) Indeed, if I shut down the MySQL server, the socket remains. Only if I shut down Apache will it ever go away. So, if left going for awhile, tons of these dead sockets will pile up. Before I post a bug repor

Re: [PHP-DB] PHP/Apache not totally closing MySQL connections

#x27;CLOSED' state sockets ultimately are being recycled. I guess I just wasn't getting the same httpd process that had them open before, because at one point I had about 5 of these sockets hanging around while new connections continued to appear. : Bob Maple (Brazilian) : When l

Re: [PHP-DB] How can recommend a book for SQL and DB design

book sounds like the best bet, when it comes out. Bob Hall -- Know thyself? Absurd direction! Bubbles bear no introspection.-Khushhal Khan Khatak -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PRO

Re: [PHP-DB] group by get last record

AVING Max(s1.Moment) = Max(s2.Moment); BTW, you can't assume that your original statement will always return the first slide. People who have tested GROUP BY statements say that the value returned from columns with no aggregate function is somewhat random. Bob Hall -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Is the query I need even possible?

.visitor_id GROUP BY v1.page_id, v1.visitor_id HAVING Max(v1.timestamp) = Max(v2.timestamp); Substitute Min() for Max() to get the earliest visit. Bob Hall -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] storing serialized() data in the db -> can it be queried on?

a really powerful overriding reason, the best solution is to have a seperate table for the array, with a foreign key that points back to the record in the original table. That will make retrieving data a lot easier; e.g. you can do a query with a join and "WHERE thisField = 'j

[PHP-DB] stupid mySQL connect \ pconnect problems - pls help

without problems, but it just does not want to work now. Any ideas please Thanks BOb -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] password in md5 to connect to mysql instead of clear password

never appears in code. I don't know a thing about unhashing MD5 encrypted strings. Sorry I can't help you there. But, it sounds like you've already found that info. Good luck, Bob Sherer -Original Message- From: Jon-Eirik Pettersen [mailto:[EMAIL PROTECTED] Sent: Thursda

[PHP-DB] RE: PHP5-MySQL Not Connecting Through Socket

1) Do you have a /etc/my.cnf ? 2) In this do you have the bind-address directive set? i.e. [ bind-address = 127.0.0.1] this is the default for debian packages versions. 3) Also confirm the my.cnf reflects the mysql.sock path properly as well. Robert Allen, zce Operations, FIO Labs LLC

RE: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

arted MySQL; no luck. 3) my.cnf's socket file path and name in both [client] and [mysqld] are the same and have been set accordingly. I am still stumped as of why PHP cannot connect through Unix socket to MySQL! On 8/30/05, Bob Allen <[EMAIL PROTECTED]> wrote: > 1) Do you have a

[PHP-DB] SSL implementation

are many options to choose from. Does anyone have any Pros/Cons on the subject of which implementation is best? Thanks for your comments, Bob -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Select distinct field won't return distinct value

I'm just learning MySQL so don't know all the syntax. There is a "LIST" function in Sybase Adaptive Server Anywhere which would do that. Is there an equivalent function in MySQL? Query: SELECT distinct niin, list(serial_number) FROM fmds.maintenance_equipment group by niin order by niin Output

RE: [PHP-DB] Select distinct field won't return distinct value

It is a Sybase vendor function but I was wondering if mysql had something comparable. I don't see anything in the manual. Maybe the subquery is the only way to go. -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 8:50 AM To: Blanton, Bob Cc

[PHP-DB] mysql databases

how would you add something new into a table and take out something old? example: (1) 1st something (2) 2nd something (3) 3rd something (4) 4th something and then you add in something new so then the table would look like (1) new something (2) 1st something (3) 2nd something (4) 3rd something

Re: [PHP-DB] mysql databases

sorry, i meant that i wanted to remove the oldest entry and put in a new entry with UPDATE or INSERT. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Session Problem

what version of php are you using? i ran across a problem with sessions not working for windows in php 5.2 because the directories for the sessions were not created. On 1/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I don't think that the problem is on the browser setting... Cause I've t

Re: [PHP-DB] A good PHP Ajax tutorial

well i found a site that has a lot of web building tutorials on it. i havent looked much at them though. the site is http://www.w3schools.com/default.asp On 2/24/07, Denis L. Menezes <[EMAIL PROTECTED]> wrote: Dear friends. Can someone please suggest a good pHP/Ajax tutorial? Thanks Denis --

Re: [PHP-DB] newbie help

This is definitely not the best advice in the world. The truth is you could staple your eye lids open and never blink, but it wouldn't be very beneficial. I highly suggest you invest some of your time in reading about databases and how relational databases work, and more than that how they work wel