Re: [PHP-DB] Re: [PHP] What's wrong with this IF statement?

uilding SQL statements much easier. especially with mutiple SELECTS in a pull down form object. -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

project i'm working with, his host died or something. but, the phpMyadmin (on that host) can NOT do a backup of 200mb table without running out of memory or something weird. so what is the best way to text dump the table? i thought i would (pseudo-code): open DB do while not EOF grab 1000 row

Re: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

uot;c:/..." this (AFAI) does not cause memory issues Ignatius _ - Original Message ----- From: "Leo G. Divinagracia III" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 10, 2004 11:39 AM Subject: [PHP-DB] HELP: best way to TEXT du

Re: [PHP-DB] Generate Menu based on database structure

graeme wrote: Hi, Rather than writing a recursive function I'd suggest that you create a menu class and store each record as an object of the class. why reinvent the wheel: http://www.destroydrop.com/javascripts/tree/ -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Ma

Re: [PHP-DB] User Activities

. that is diff from the way MYSQL works. -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL backup software

Perry, Matthew (Fire Marshal's Office) wrote: Does anyone know a free MySQL backup program to schedule regular backups? mysql has the ADMINISTRATOR, well at least for win32... does timed backups. -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.ph

Re: [PHP-DB] MySQL problem..

ml/poems/browse.php on line 15 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connect to MySql DB on diferent domain

e some help or a simple example how > to do this? > > -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Comparison with formatted numbers

a number_format on > the test value? ie: '.. where price <= '200,000' ..' > > Help would be appreciated. > > Terry > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: please help.. serial number generator

unique serial number that you can check that > > > it's valid.. > > > > > > Thanks... > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] 2 groups of random result pls help...

1smith > 32 1sara > 12 1michael > 12don > 92 beth > 4 2bob > > -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (htt

Re: [PHP-DB] Help Needed

= mysql_query($query,$db); > > line 37:$num_result = mysql_num_rows($mysql_results); > > if($num_result == 0) >{ > echo "Invalid Username or Password entered"; > exit; >} > > Regards, > > Manoj > > 'I h

Re: [PHP-DB] JOIN in embedded query

(SELECT Emails.ID FROM Emails RIGHT > JOIN KeyWords ON Emails.ID = KeyWords.EmailsID) LIMIT 250 > > I am getting an error, and I am quite certain that it is my syntax > > -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] best way to stare true, false

ot succeeed so far. > > -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

"microphones"; > > I just got the exact same answer as if i would have done this: > > SELECT * FROM equipment WHERE class = "microphones"; > > so it didn't help. > > Can anyone offer a hint? > Thanks, > russ > > -- > PHP Database Mailin

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

as if i would have done this: > > SELECT * FROM equipment WHERE class = "microphones"; > > so it didn't help. > > Can anyone offer a hint? > Thanks, > russ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.p

[PHP-DB] authenticating methods...

count for the other tasks? or a single user that does everything including the INSERTS? and where are you storing the username and password? in the code itself or call it via the INCLUDE statement? thanks... -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List

Re: [PHP-DB] Re: securing directory tree and allowing PHP to work

provides PHP > and MySQL support. I cannot control the HTTP or PHP server build > configurations...They have autoindexing built into the Apache server. > just add an .htaccess file in that directory saying no one but LOCALHOST has access to it... http://www.javascriptkit.com/howto/htaccess5.

Re: [PHP-DB] Database question

eld size. then there's VARCHAR. the downside is that it's limited to 255 bytes... good news is that it's N+1 byte size. -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how to display tree structure from database???

ltavista.com and you have a 90-98% accurate translation. handy site to keep around... -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Enhancement of script

iew and > www.matrix-hosting.co.uk/prestige/admin_welcome.php for the admin side. > > Any help would be appreciated > > > Ray > > P.S. if any one also knows how to get it to display a 2 or 3 months at a > time or even a year this would also be a bonus as I have tried t

Re: [PHP-DB] Visitor tracking...

B might start to grow at fast rate... but you asked... :) -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] New to PHP and MySQL

gt; > Thanks for any and all help anyone :-) -- Leo G. Divinagracia III [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] Need a shopping cart

]> - 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] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators

Re: [PHP-DB] Clock struggles

>PHP timestamps are adding 7 hours to that. Is there a time zone property that needs >to be changed? -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTE

[email protected]

ately preceding the > ampersand. > > Does anyone know how to get around this? > -- Leo G. Divinagracia III [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] Order by unix timestamp

t; > He orders it by unixtime, but beginning with the oldest record. > i thougt i could fix it by using ORDER by !unixtime . > > Also does'nt work > > How can i fix the problem that the records are ordered by unixtime, > beginning with the newest record ? > > -

Re: [PHP-DB] I need a User Authentication solution

t; For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Leo G. Divinagracia III [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] multiple queries in one php statement....

> queries in a mysql_query() statement?? > > etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db) > > Thanks. > ___ > PGP KEY ID: 0xA86600E9 > _______ -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP

Re: [PHP-DB] Monitoring No. OF CLICKS for a link

button which is basicaly a link to some page. So I >want to track how many users click on the button or link, to view the page. > > Also how can I get the details about the person - like where is he located (country). > > Please help!!! > > regards, > Pranot -- Leo

Re: [PHP-DB] Access counter

gt; For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: [PHP-DB] config php w/ mysql

lt of mysql_query(...) is FALSE? check that result first? maybe the queries are returning no data or something... i mean if you can connect, then PHP and MySQL are working together just fine... i'd check the data first... -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mai

Re: [PHP-DB] Access counter

the script increase the > value by only by one, only if the the visitor for a new content (by clearing > the cache, e.g.). > > Thanks you replying.. > > "leo g. divinagracia iii" wrote: > > > in pseudo-code: > > > > make a text file - associate i

Re: [PHP-DB] Problem with my first script

(as i found before that took about 10 minutes of debugging on a similar debugging session...) ;-))) -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] T

Re: [PHP-DB] log out

fault i specify, it puts it as offline. Another way > was to have cron do this for me... > > But i still wonder if it's possible to have php sessions do this for me, > as some kind of mechanism must exists for the session expires... > -- Leo G. Divinagracia III [EMAIL P

Re: [PHP-DB] Question regarding php and mysql with binary data...

choose save > picture as i can get the name of the > picture from the DB and not have to insert it my self. > Does anyone now how can i do that with a file that comes from a db??? > > thanks > ___ > PGP KEY ID: 0xA86600E9 > _______

Re: [PHP-DB] HELP!! - Search

UMMM... can you be a little bit more specific? what section aint working? error messages??? Matthew Cothier wrote: > > Whats wrong with this?? Its not working... > {snippage}... -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php

Re: [PHP-DB] Problem with my first script

I have realized that the problem is below that line: > the problem is pointing to the line where i fetch the first variable: > $nombre=$myrow("nombre"); > -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

Re: [PHP-DB] report style printing

with some Custom Report Style? > > the long way is to setup an ODBC with m$ access and let the access report writer handle all the pretty printing... -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTEC

Re: [PHP-DB] saving to two tables at the same time

easy... but trains the "wrong" stuff... ;-) -- Leo G. Divinagracia III [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] html generated web pages

olor blue. > > and i can give to some users privileges, so they can change the image and > > the color easily through a userfriendly admin form. > > > > about the "html generated web pages", > > i mean how php generates html-extension web pages (with ima

Re: [PHP-DB] webpage counters

to change the permission of the file to: > chmod 666 counterfile.txt > > My questions are: > 1. Which is more efficient in terms of time, i.e. accessing a database or > accessing a text file? > 2. is the second counter secure? is there a possibility that the file > counterfi

Re: [PHP-DB] USA Attacks (Nostradamus -- Further Info)

wow... i didnt know nostradomus used PHP with a database backend? otherwise, please don't post this stuff on this list... -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comman

Re: [PHP-DB] I need help Please....

; > $query.="hpassword VARCHAR(50),"; > $query.="head VARCHAR(50),"; > $query.="body VARCHAR(50),"; > $query.="ears VARCHAR(50),"; > $query.="eyes VARCHAR(50),"; > $query.="hair VARCHAR(50),"; > $query.="mouth VARC

Re: [PHP-DB] Passing parameters to a PHP file.

TECTED] > (Quite el 'nospam' para responder) > (Remove 'nospam' to reply) > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the

Re: [PHP-DB] problem with dbase connections using ODBC

want to use PHP ;> > > thanks in advance > > don > > -- > 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 PROT

Re: [PHP-DB] search engine for database driven site?

: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Leo G. Divinagracia III [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] Backups, best practices

last 20 years. one of persons is the porn king of the internet, and PK is left out... > > pkzip is made by a different company i think > -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] date

gt; > i am a bit confused. i inserted few dates in the above format and asked > mysql to list them by date and it does not seem to work. > > any suggestions?? please :) > > ax > -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.ph

[PHP-DB] what's a GOOD starting HOURLY rate for a PHP/MYSQL job?

okay, you consultants... i'm gonna venture at work to do some side jobs here for some online dynamic web pages. but what would be a good starting pay rate? or would you contract for the entire job? what about a per PAGE/SCRIPT basis? thanks... -- Leo G. Divinagracia III [EMAIL PROT

Re: [PHP-DB] Design suggestions - performance improvement

te for (filmID -> fd_date) loop select sd_starttime from session_data where fd_id = sd_fd_id print sd_starttime end loop next fd_date next movie film_detail has a 1 to many to film_date film_date has a 1 to many to session_data -- ------

Re: [PHP-DB] Help with MySQL

you try to access your data, the system would not let you in. this is common. -- --- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to produce the report using PHP?

r you can ODBC it, and use ms access and it's report writer. -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php & date manupulation functions

return "01" echo $month; // would return "01" echo 4year; //would return "00" -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] dbase and Debian

Ricardo Markiewicz wrote: Unfortunately, I can't convert the dbf files to SQL tables, so, i need dbase support in PHP :( connect via ODBC, perhaps? then ADOdb or PEAR it? -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubs

Re: [PHP-DB] Really Good PHP editor

maguma has their open studio too. http://sourceforge.net/projects/openstudio -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Email Article, Print Article

strip out all of the fancy tables and graphics and stuff in the "printed" page option. plus, i use this trick to read a site that separates the article into multipages. when you click on the PRINTED option, it dumps the whole article into a graphics free format... ;) -- Leo G. Di

Re: [PHP-DB] Looking for a small open-source PHP-DB app that utilize OOP.

check out UCCASS. not only oop, but smarty as well... http://www.bigredspark.com/survey.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] What is the most efficient way to store SELECT results

Robert Palmer wrote: I'm not I was clear in my question. A query returns 1,000 rows from the table. I want to store the entire result of that query in order to be able to create separate pages to return the results rather than all on one page "e.g. Page 1 2 3 4 ... ". Not sure if it's importa

Re: [PHP-DB] Re: backup of database record before update

Stephen Sunderlin wrote: Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion on the board here that MYSQL triggers were not so reliable and still somewhat problematic so I archive through the application. Just curious. i have used a couple simple t

Re: [PHP-DB] Efficient way to access MS SQL server

charlie wrote: The native SQL driver for PHP has a problem with a limit on the number of characters in a string, so can't use that. hmmm interesting. how much is the limit? i used PHP's mssql_* functions and while i only used about 20 chars on a character search string in the WHERE, i