Re: [PHP-DB] HTML + PHP

-- unclosed/unbalanced tags (/td, /tr, /table). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* When the going gets tough, the tough go grab a beer. */ -- PHP Database Mailing

Re: [PHP-DB] Arrays and forms

do the same for prob[] as well. Having done that then in your example you should get something like: $prob[0]: Problem one $prob[1]: Problem two $level[1]: High $prob[2]: Problem three$level[2]: Low NB that $level[0] is undefined. -- Jason Wong - Gremlins

Re: [PHP-DB] php - mysql connection via Apache

a page. Has anyone seen this behavier before ? Yes. I've seen it before. Loads of times. It means your version of php was not compiled with mysql support, or the mysql module was not found. Try searching in the archives for an answer. -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] Insertion upon upload

new to databases then check out some php/database tutorials (there are _plenty_ out there). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Our business is run on trust. We

Re: [PHP-DB] two inserts at once?

is a auto increment field, as is id... but it seems I need to know the value of faqid to relate it correctly to the fgNumber... The retrieve faqid use mysql_insert_id(). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] which DBMS... MySQL or PostgreSQL

). Also google MySQL vs PostgreSQL should be helpful. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* It is better to wear out than to rust out. */ -- PHP Database Mailing

Re: [PHP-DB] OR on multiple columns

the archives, check the usual script sites (www.hotscripts.com, www.zend.com, www.phpclasses.org etc) for timing classes/functions/etc. Everything runs on my ISP's server. That's not an issue. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators

Re: [PHP-DB] OR on multiple columns

a syntax error. Is it not legal to do this? The php-mysql interface does not support multiple queries. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* A handful of friends

RE: [PHP-DB] Help with date....

( string format [, int timestamp]) and w - day of the week, numeric, i.e. 0 (Sunday) to 6 (Saturday) http://www.php.net/manual/en/function.date.php Not sure which you wanted since this is the php-db group :) Cheers Jason -Original Message- From: Rodrigo Corrêa [mailto:[EMAIL PROTECTED

Re: [PHP-DB] RE: passing array values in forms

. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Catch a wave and you're sitting on top of the world. -- The Beach Boys */ -- PHP Database Mailing List (http

Re: [PHP-DB] Storing Radio Buttons Checkboxes in MySQL

and values have to be different? When it is inserted into the DB it shouldn't matter since the record would not be a duplicate. manual FAQ PHP and HTML -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Progress output

-general php-db), it's been covered many times before. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* static buildup */ -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] How to seperate the web server and MySQL database server?

mysql to allow remote connections (checkout the GRANT command). Also if you have a firewall between the two machines you would naturally have to take that into account. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] more values in a array

. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Life is like a tin of sardines. We're, all of us, looking for the key. -- Beyond the Fringe */ -- PHP

Re: [PHP-DB] MySQL Database connection Problem

writing file './nrlug/home.frm' (Errcode: 28) This is obviously a mysql question. Go to their website and search on the error message. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] MySQL Database connection Problem

On Friday 03 January 2003 17:11, conbud wrote: Jason Wong wrote: On Friday 03 January 2003 17:00, conbud wrote: Hello can someone give me some possible reasons this error happens when I use the mysql client to add a tabe to a database. mysql create table home (id int not null, heading blob

Re: [PHP-DB] Formgenerator?

is cool, but doesn´t support a fieldcheck or events after an insert. There is also ImpAkt which supports all the features but it´s nich OpenSource. www.phpclasses.org -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Renaming a file uploaded by a form.

to be created by the PHP machine (wild guess) but it looks like this: /var/tmp//phptkYxkV Any ideas on how to get it to look like: filename.doc would be greatly appreciated. RTFM section on Handling file uploads, in your code print_r($_FILES). -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Drawing chart

jpgraph -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* The longest part of the journey is said to be the passing of the gate. -- Marcus Terentius Varro

Re: [PHP-DB] PHP files and special characters language

lang=whatever -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* When you die, you lose a very important part of your life. -- Brooke Shields */ -- PHP

Re: [PHP-DB] Serve images from files, or db?

the archives. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Life is a concentration camp. You're stuck here and there's no way out and you can only rage impotently against your

Re: [PHP-DB] How to solve T_STRING error?

that you have closing braces on the last two IF statements. Are you sure you're looking at the right file? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Promise her anything

Re: [PHP-DB] Select a table inside a db

On Wednesday 25 December 2002 00:10, zeroked wrote: Hi I am a newbie to PHP so please help How do I add information into my mysql db? I have a db called sitedb and I want to insert datat into my news table inside my sitedb. Merry Christmas. You forgot to say what the problem is. -- Jason

Re: [PHP-DB] Questions regarding primary keys, updates, and autoincrement

application to link tables together. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* This ASEXUAL PIG really BOILS my BLOOD ... He's so ... so ... URGENT!! */ -- PHP Database

Re: [PHP-DB] file upload array problem

INTO inventory (registration,type,total_time,price,description,picture_name) VALUES ('{$_POST['registration']}','{$_POST['type']}',...); -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

RE: [PHP-DB] extracting data

? To another odbc? to mysql? where? And do you want to manipulate the data before moving it? Cheers Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:17 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] extracting data Ok, I am

Re: [PHP-DB] form validation

and validate forms for you. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Qvid me anxivs svm? */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Next/Prev 10 lines

other day (or so it seems). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Nihilism should commence with oneself. */ -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Newbie PHP/MySQL question

4.2.3 MySql 3.23 IIS 5.0 My mind reading skills aren't very good, but I think there's something wrong with line 13 of your program. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] PHP/MySQL Problem....

If this is an all Redhat RPM installation then install the mysql-php*.rpm as well. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* If you suspect a man, don't employ him. */ -- PHP

RE: [PHP-DB] extracting data

If you are on a windows machine, you can create a DSN to the access file and use odbc from php to connect to it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] extracting data I

RE: [PHP-DB] My question in precise reg PHP and relational tables.

\$category_type/OPTION; } then in your form, use this code for the select box: SELECT name=product_type ? echo $option_block; ? /SELECT This will give you a drop down list that is dynamicly generated each time the page is viewed by the values in your category table. Cheers Jason -Original Message

RE: [PHP-DB] Now not selecting enough

Try putting this: echo (h5A HREF=\minutes_detail.php?id=$id\$meetingdate/A/h5); in your while loop. Right now it is just popping out the last record. Cheers Jason -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:00 AM To: [EMAIL

Re: [PHP-DB] pictures into MySQL

insert picture into mysql -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* It's not an optical illusion, it just looks like one. -- Phil White */ -- PHP

Re: [PHP-DB] login won't log in, HELP

, here are a couple of pointers: 1) Bypass the login page, hardcode the login details and see whether that gets you logged in. 2) Use print_r() on your major variables in strategic places in your code to see what's happening to them as they pass through your code. -- Jason Wong - Gremlins

Re: [PHP-DB] random select

. I am working off localhost on a WINXP machine. PHP 4.2.2. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Ain't that something what happened today. One of us got traded

Re: [PHP-DB] random rows...what about tables

the random table working. [snip] Anybody see the solution?? First we need to know _what_ the problem is. I think we can assume your code doesn't work the way you expected. Can you tell us _how_ it doesn't work? Error messages? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] random rows...what about tables

. There's an example in the manual which shows you how to use mysql_list_tables(). Get that working, _then_ adapt it to return random tables. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] UPDATE tbl problem...

you're not testing for it? You should _always_ use something like: mysql_query('...') or die(mysql_error()); Second, the reason why it fails is because you need commas between the items in your SET clause: UPDATE table SET col1 = 'val1', col2 = 'val2' ... -- Jason Wong - Gremlins Associates

RE: [PHP-DB] mysql-windows xp

the option to Protect my computer or network. Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 7:54 AM To: SELPH,JASON (HP-Richardson,ex1) Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql-windows xp that didn't

RE: [PHP-DB] mysql-windows xp

work until I disable ICF. Try running winmysqladmin though if you haven't already. or give a more detailed error message. Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB

RE: [PHP-DB] copying data

. This may be tricky as I am not sure if you can bait and switch the file from under the odbc connections nose. Cheers Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 10:33 AM To: PHP-DB Subject: [PHP-DB] copying data I

RE: [PHP-DB] php- odbc- access

the records over. You can also have them export their data to a CSV file, upload that file and mysql can import it. Other than that I am not sure what you can do. Cheers Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 7:41 AM

RE: [PHP-DB] Update Query Help...

is it a mysql field type of datetime? if so, you may want to use this instead $timestamp=date(Y-m-j H:i:s); $update = UPDATE accounts SET atime='$timestamp' WHERE id-sys='$tmp'; that puts the current timestamp in mysql format for entry into your table. Cheers Jason -Original Message

Re: [PHP-DB] Typical login script... user problem... :)

, $db_pass to see whether they contain what you think they contain. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Persistence in one opinion has never been considered a merit

Re: [PHP-DB] passing variables

with the other code but it still loads the form under if (!$login_clients and !$register_clients){ If I use isset it does the same thing. Quickest solution, stick a phpinfo() in the first line your code to see exactly what is and isn't being set. -- Jason Wong - Gremlins Associates

RE: [PHP-DB] How do I... (update one table from one page which displays multiple editable tables)?

. Cheers Jason -Original Message- From: Michael Knauf/Niles [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] How do I... (update one table from one page which displays multiple editable tables)? I have a simple form that displays

Re: [PHP-DB] Function questions...

the choices provided in the while loop from the database. Please let me know what you think. Your table doesn't seem to be closed. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

using PHPMyAdmin, minus the var of course, the table is created. When I run it in my code, nothing happens. I do a die($SQL) to see the final outcome of the query and it's correct and is what I am using to run the query in PHPMyAdmin. mysql_error() to see what the problem is. -- Jason Wong

Re: [PHP-DB] php and mysql

on the form before they edit it) *change the prices after submission of the form into the mysql database THANKS A LOT, it will really help I bet it will ;-) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Parserproblem by cascading outputscript

. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* FORTUNE PROVIDES QUESTIONS FOR THE GREAT ANSWERS: #15 A: The Royal Canadian Mounted Police. Q: What was the greatest

RE: [PHP-DB] query

Ideally, you would have 3 tables like so... Projects(with one record per project) - projectID |ProjectName| etc... 1 my project 2 another project Users(with one record per user) --- userID| userName| etc... 123 Joe Blow 124

Re: [PHP-DB] Re: PHP/MySQL not available remotely...

... If phpinfo() doesn't work then I think you've got far bigger problems than setups to worry about ;-) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* I knew one thing: as soon

Re: [PHP-DB] foreach loop from MySQL select query to HTML select list

it looks like). Use mysql_fetch_assoc() instead. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* There are things that are so serious that you can only joke about them - Heisenberg

RE: [PHP-DB] Resource id #2

Try this... either... while ($row = mysql_fetch_array($result)) { $title = $row['Books.Title']; $author = $row['Books.Author']; ... print $title; } or... while ($row = mysql_fetch_array($result)) { print $row['Title']; ... } -Original

Re: [PHP-DB] Resource id #2

mysql_error(); die(Couldn't search the library.); } -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* [Crash programs] fail because they are based on the theory that, with nine

Re: [PHP-DB] Undefined Constant

am trying to get the $row[price] to echo so that Javascript recieves a string, converts it to an integer, and later on in the code, gives the user a total. Any ideas? Use: $row['price'] -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] Connecting to remote db securely

look but not touch. To tighten things further you can ask them to allow access only from _your_ host. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* When some people decide

Re: [PHP-DB] PDFlib

On Monday 25 November 2002 23:19, nikos wrote: Hello everybody Does evrybody know if there is a free version of PDFlib Thanx Nikos You have started a new thread by taking an existing posting and replying to it while you changed the subject. That is bad, because it breaks threading.

Re: [PHP-DB] MySQL connectiviy

to undefined function: mysql_connect() MySQL support was installed with --with-mysql=shared,/usr' This is the redhat 8.0 default. I guess it just can't find the function library. Any pointers any one could give would be really appreciated. Have you installed the php-mysql*.rpm ? -- Jason Wong

RE: [PHP-DB] MySQL Problem

Still think we need to see the PHP code before determining that it is an SQL problem. Regards, J -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 11:55 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Problem On Friday 22 November

Re: [PHP-DB] mysql_num_rows()

an insert statement for every instance, when the 17 turns into zero the loop stops. For some reason the $insert never recieves any value. Please post your code. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] date()

, if within PHP then use UNIX_TIMESTAMP. Select unix_timestamp(storedDate) as date FROM SomeTable where blah blah Should work like that? Yes, something like that. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

RE: [PHP-DB] serious help with linking data together...

you haven't really said what the problem is - but this is what I can see... Functions like COUNT, MAX and MIN etc. are group functions (or aggregate functions). For example, select count(*) actually only returns 1 record - the total count. When you mix aggregate functions with regular selects

RE: [PHP-DB] Email Encryption?

Why email? If the Admin tool uses SSL, that is all you need. Regards, J -Original Message- From: Aaron Wolski [mailto:aaronjw;martekbiz.com] Sent: Friday, November 15, 2002 11:39 AM To: 'Aaron Wolski'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Email Encryption? Just thinking here..

RE: [PHP-DB] Email Encryption?

is ever passed via email. Regards, Jason Vincent Voice Architecture, Nortel Networks (905) 863-7480 (ESN 333) [EMAIL PROTECTED] -Original Message- From: Aaron Wolski [mailto:aaronjw;martekbiz.com] Sent: Friday, November 15, 2002 11:47 AM To: 'Hutchins, Richard'; [EMAIL

Re: [PHP-DB] database update question

'); -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Politicians should read science fiction, not westerns and detective stories. -- Arthur C. Clarke */ -- PHP

RE: [PHP-DB] phpmysqladmin

http://www.phpwizard.net/projects/phpMyAdmin/ yes it is - and it is a great tool J -Original Message- From: Matt Giddings [mailto:cen10761;centurytel.net] Sent: Friday, November 15, 2002 12:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] phpmysqladmin Anybody have the url for

RE: [PHP-DB] Email Encryption?

address on file) and let then know that someone has changed their account number, and if it wasn't them... blah blah Regards, J -Original Message- From: Aaron Wolski [mailto:aaronjw;martekbiz.com] Sent: Friday, November 15, 2002 1:18 PM To: 'Peter Beckman' Cc: Vincent, Jason [BRAM:1334

Re: [PHP-DB] a menu item from a database, linked to a list from a another table

On Thursday 14 November 2002 23:17, [EMAIL PROTECTED] wrote: Jason Wong [EMAIL PROTECTED] wrote on 11/13/2002 10:46:32 PM: On Thursday 14 November 2002 07:32, [EMAIL PROTECTED] wrote: Is this even possible? I have a menu that is generated from a table. What is your menu -- a set

RE: [PHP-DB] Difference between 2 dates.. thoughts?

You should be able to do this at the database level - of course you never said what database that is. Regardless, check your database documentation for the max() and min() functions - never used these on date but they might work - do you always want the first record and the last record in the

RE: [PHP-DB] Difference between 2 dates.. thoughts?

13, 2002 12:27 PM To: Vincent, Jason [BRAM:1334:EXCH]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts? Hi There, Well the first and last record of the results. So if 1000 records were found... then record #1 and then record #1000 - perform data calculation between

RE: [PHP-DB] date()

use the php function substr to chop off what you don't need, since all the dates can come from mysql as -mm-dd or however, just use substr($mydate, 0, 10) or however far out, that truncates the actual $mydate. -Original Message- From: [EMAIL PROTECTED] [mailto:epeloke;echoman.com]

Re: [PHP-DB] date()

() on them in your query: ..., DATE_FORMAT(...) AS datefield, ... where datefield is the name of your column holding the date. If you're doing calculations on your dates in your PHP code then you should convert them using UNIX_TIMESTAMP() in your query. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] a menu item from a database, linked to a list from a another table

the link bring up a list of items from another table in the database, not an html page. So I guess this would be a select statement linked from a select statement? Is this even possible? Yes, google - dynamic linked listbox php. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

Re: [PHP-DB] upload data to MySql

in your code so you can verify that they contain what you expect them to contain. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Term, holidays, term, holidays, till we leave

Re: [PHP-DB] php array max value pr. year

, but first you need to: 1) explain why you're using 2 arrays 2) state whether the non-maximum values are used at all, if they are being used, /how/ are they being used. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] arrays db

you just keep the 'latest' value -- which should be the maximum value? in a loop. But it have all the values and years in the array. How do i only take ONE value per year in PHP NOT SQL?? I really hope this is discriping enough!! -- Jason Wong - Gremlins Associates - www.gremlins.com.hk

[PHP-DB] indexing on existing DB

(I know this is more of a mySQL question than PHP, but allow me this one if you would...) In MySQL, is there any difference between creating an index at table creation time, and creating an index on an existing table? Does an index created on an existing table re-index itself after each

Re: [PHP-DB] ROugh idea of speed

:) He wants around 5 fields each containing 50 chars. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Say something you'll be sorry for, I love receiving apologies

Re: [PHP-DB] Order DB through url toggle

we set up out order by clause */ $orderBy = 'priLastName'; if (isset($HTTP_GET_VARS['orderBy'])) { $orderBy = $HTTP_GET_VARS['orderBy']; } /* and the desc asc */ if $HTTP_GET_VARS['dir'] = 0 { Try: if $HTTP_GET_VARS['dir'] == 0 { -- Jason Wong - Gremlins Associates - www.gremlins.com.hk

Re: [PHP-DB] mysql_fetch_array() question

a single query. What fields do the tables 'users' and 'Members' contain? There should be a field there (like eg. userid) which links the two together. If there isn't one then you should seriously restructure your tables so that there is one. -- Jason Wong - Gremlins Associates

RE: [PHP-DB] MySQL password protection?

actually you can make a .php file with your connection info, include it in your .php files at the top and encrypt that one file (they don't need to see it anyway). use a php encoder for the file with your login info in it. -Original Message- From: 1LT John W. Holmes

Re: [PHP-DB] Quarter question..

... -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Ask not what's inside your head, but what your head's inside of. -- J.J. Gibson */ -- PHP Database Mailing

Re: [PHP-DB] Quarter question..

that instead of just die(), it dies with a mysql_error(). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Maybe you can't buy happiness, but these days you can certainly

Re: [PHP-DB] boolean instead of array

() statements to incorporate a mysql generated error message: die( . mysql_error()); Once you get that example working, you can modify (one step at a time) to suit your needs. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design

Re: [PHP-DB] error messages to variables

in php.ini. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* I can't stand squealers; hit that guy. -- Albert Anastasia */ -- PHP Database Mailing List

Re: [PHP-DB] Getting affected rows before executing query?

it to a DELETE query. 3) Backup your database/tables before doing anything drastic. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Art is a jealous mistress. -- Ralph

Re: [PHP-DB] PHP Case Sensitivity

for variables. There are two possibilities: 1) Your code is buggy 2) PHP is buggy I suspect it's the former :) but if you think it's the latter then post your code here. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] Infinite Loop?

deleted the script after receiving 2500 emails ! :'( Can anyone point out what the problem with this is? while($tmp = $NowUnix) You're not updating $tmp or $NowUnix inside your loop. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web

Re: [PHP-DB] boolean instead of array

going. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* My friend has a baby. I'm writing down all the noises he makes so later I can ask him what he meant

Re: [PHP-DB] Am I doing This Right?

printing the names values of important variables at strategic places in your code to verify that they contain what you expect them to contain. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Am I doing This Right?

out the variables. All my important variables are $HTTP_POST_FILES and those are all null. manual Variables Variable scope And also if you're using a version of php newer than 4.0.6 then you should be using $_FILES instead of $HTTP_POST_FILES. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Restarting Mysql

% mysqladmin shutdown works. safe_mysqld doesn't. Any suggestions on getting around the reboot? Write a script that UNLOCKs the table(s) and run it when the error occurs. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] Am I doing This Right?

On Friday 01 November 2002 15:05, [EMAIL PROTECTED] wrote: ?php function war3_replays_submit() { if ( isset($replay_file) ) { Doing what right? Where/what is the problem? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design

RE: [PHP-DB] Converting database from MS Access to MySQL on Linux

I use this, it has a nag screen but doesn't require any money. http://www.accessmysql.com/ works as an access plugin, just select an access table, point it to your mysql db and click a button. easy to use. -Original Message- From: Matthew Hildebrand [mailto:gosherm;byu.edu] Sent:

Re: [PHP-DB] URGET HELP : Logic Help - for first record do_this for each record after do_that

for remaining rows } -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* When you get your PH.D. will you get able to work at BURGER KING? */ -- PHP Database Mailing List

Re: [PHP-DB] Millions of records in MySQL

On Friday 25 October 2002 16:10, Steve Vernon wrote: Hiya, I remember ages ago that mysql does not properly handle upwards of 10 million records in a table? Any details would be great! Try it, or ask on the mysql list? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open

Re: [PHP-DB] printing an array

) Close the table row: echo /tr; -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* You have mail. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] images

www.hotscripts.com www.phpbuilder.com sourceforge.net freshmeat.net -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* bank holiday - system operating credits not recharged

<    1   2   3   4   5   6   7   8   9   >