[PHP-DB] LEFT JOIN in UPDATE

hi...trying to circumvent the limitation of the DELETE statement only being able to use its own table...idea is to mark the records to be deleted via an UPDATE statement which allegedly accepts LEFT JOIN and then performing the DELETE statement. Question is how to properly form a LEFT JOIN using

[PHP-DB] DELETE in mysql?

. Thanks --- Adv. Systems Design [EMAIL PROTECTED] wrote: Maybe my example attempt is misguided but the idea is to look up the prod_id from temp to know which records to delete in the prod, prod_price, prod_cat tables, all having the prod_id field as a link...just like you can do in a SELECT

[PHP-DB] DELETE in mysql?

sorry if this is painfully obvious but I can't seem to figure it out...It seems to me (unless I am reading it waay wrong) that the mysql DELETE command does NOT allow you to refer to columns from other tables! I have identified certain records to be deleted from 3 tables and created a temp

[PHP-DB] UPDATE query to add to a field

hello all: I need to be able to update a field in MySQL, the catch is that I have to add on to text that is already there and I have to be able to do it within MySQL (phpMyAdmin). My first idea was to do: SET prod_desc = prod_desc + more info to tack on to end but this is a mathematical

[PHP-DB] PHP and MSSQL using APACHE

Hello all: Just have been tasked to port an app created on (linux)php/mysql/apache to run (on Win2K) php/mssql/apache. Any links with info on setting up mssql to work with php and apache (all on win2k) appreciated! Luis __ Do You Yahoo!? Find the

[PHP-DB] inserting NULL value

Hello * I am trying to batch load data into MySQL 3.23.39 from data that I am preparing using MS Excel, converting to tab-delimited txt file and uploading using phpMyAdmin... ...the problem is in trying to load the NULL value for some columns...if I leave the column empty it just gets truncated,

[PHP-DB] CASE tool

Hi: Anyone offer recommendations for a CASE/E-R modeling/Data dictionary tool that can be used with MySQL? Thanks Luis __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- PHP

Re: [PHP-DB] Table display Driving me Crazy!

I figured out what was wrong...and yes, the db call was from phplib...I am making modifications to existing code and so haven't figured out all the inns and outs...what I did was just create an array from the object that was being called by the query and then addressed those array elements

[PHP-DB] Table display Driving me Crazy!

Hello * trying to output mysql content into a table, but the table is designed to use 3 Trows to display info for ONE product (table also has to have 5 columns): row1 sku1|sku2|sku3|sku4|sku5 row2 img1|img2|img3|img4|img5 row3 nam1|nam2|nam3|nam4|nam5 -

[PHP-DB] SQL query (OT)

hi: I have 2 tables, lesson and lesson_gle, where lesson holds lesson data and lesson_gle holds repeating data that are how the lesson correlates to various state standards (one lesson can have many correlations)...one particular lesson may have a math correlation as well as a language arts

[PHP-DB] (OT) SQL query repeats

hello: I have 2 tables...lesson and lesson_gle (which holds repeating data for lesson, i.e. l_id, glenum) the following query gets results, but there are repeated entries (one for every repeat in lesson_gle table) SELECT * FROM lesson, lesson_gle WHERE lesson.l_id = lesson_gle.l_id HAVING

[PHP-DB] image resizing

Is there a way of sizing image resolution on the fly? TIA Luis __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] Cookie is set?

anyone have a good method or code snippet to check if the user is accepting cookies? Thanks luis __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database Mailing List

[PHP-DB] AOL and Cookies (sessions) HELP!

I have a login procedure using php4 sessions that craps out when people try to login using the AOL browser...basically the AOL browser just ignores the cookie (due to a proxy server blocking it I think) and the user can't log in and they don't get any feedback about it either...they are just

[PHP-DB] changing field size

hello *: I have initially set a field named title to be varchar(50)...I am finding that it is not long enough...can I change the size without adversely affecting existing data? Thanks Luis __ Do You Yahoo!? Get personalized email addresses from

[PHP-DB] User Permissions

Hello *: I have to code an app that must enforce user permissions in terms of data entry and editing (only certain records may be edited by certain people). I realize that each situation is unique, but does anyone have a starting place they recommend? TIA Luis

[PHP-DB] CodeCharge IDE (OT)

I accidentally entered php.org instead of php.net the other day when I was looking for the php man pages and came across the CodeCharge IDE...I know no tool can foresee all possible situations and therefore cannot be a panacea (or even useful), but I was wondering if there are any users of this

Re: [PHP-DB] Where do I get started?

One of the best kept secrets (apparently) is to take a program that someone else has created (preferably a mature project that has undergone some growth and cleaning) and learn what it does...syntax is just that...you will see that there are about a million ways of doing any one thing, but only

[PHP-DB] retrieval of NEXT, PREV records

I have set up links to browse records one by one, using (ID+1) for NEXT and (ID-1) for PREV...the only problem is that if there is a hole in the ID sequence (as from DELETION), there is no record returned...How can I have it so that the 'holes' are paved over and not returned? TIA Luis