Re: [PHP-DB] MySQL performance and crash

MySQL is stable enough. May be it'll be better to rewrite your code or to add some indexes to Users? I can help you with ideas of refactoring. Murat BIYIKLI wrote: I use a Linux web server with PHP-MySQL. The hardware is good enough with 2GHz CPU and 1 GB RAM. and 7200 Cycle/min Serial ATA IDE HD

Re: [PHP-DB] MySql Client API still old version

1. Did you install MySQL-client or only MySQL-server? 2. Do you think I'm a telepath? Please, if you want good answers, tell, at least, your OS and PHP version. I can't help you without any information. 3. You choose wrong maillist for this question. Here are many php-programmers, but not syste

[PHP-DB] Test

test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL software question

May be ERwin or BPwin can help you. imho ERwin works with MSSQL, Access, so maybe new versions work with MySQL too. Vincent Jordan wrote: Is there a piece of software that will allow my to create MySQL databases and table relations in a graphical format without having to connect to the database?

Re: [PHP-DB] generating reports in php

First, describe more details about reports such you need. Second, please, do not start new topics by replying on existing. It breaks strukture of mailing list and makes view of topics complicated. Carlos Merino wrote: hi, Is there any product to create reports in an easy way like Crystal Repo

Re[2]: [PHP-DB] Re: ummm i am confused

ing a ; on the above line. PHP even told you on what line TR> the >> TR> error occurred. You do not have to post all of your code if the error TR> occurs >> TR> on line 4. And please choose a better subject for your posts. >> Try to translate errors better.

Re: [PHP-DB] access denied

er script that sets $dbHost, $dbName and, w> $dbPassword to the correct things to connect to the db -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: ummm i am confused

gt; on line 4. And please choose a better subject for your posts. Try to translate errors better. Error is in missing bracket. TR> Regards, Torsten Roehr -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] ummm i am confused

connection); w> $pic=mysql_fetch_array($pict); w> picscreate($pic[1],$pic[2],$usernum); w> }; ?>> w> Welcome to the RuneRunners Runescape service page w> The currrent Runerunners are: w> w> picspprep(1,$connection); w> picspprep(2,$connection); ?>> w> w> w&g

Re: [PHP-DB] Javascript help require

ould say "Numeric R> value require". And curser's focus should come on R> textbox named "Phone_no". R> Pls answer if you can. I have tried but not 100% R> succeed. R> Regards R> Rinku R> __________ R> Do you

Re: [PHP-DB] MySql syntax error using PHPWiki

PPNaml> It seems that the SQL syntax is incorrect as no table is included in the PPNaml> SQL statement. Is it something to do with adding a "'prefix' => ''," line PPNaml> to $DBParams in index.php? Is it something else entirely? PPNaml> Any help is app

Re: [PHP-DB] strange query

roup by job_stats.job_stat_id, job_stat, job_stat_code pM> order by job_stats.job_stat_order asc pM> Any idead anyone please pM> tia pM> pedro -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] explode() and a database call...?

age is TPrsc> strictly prohibited. If you have received this communication in error, TPrsc> please notify us immediately by e-mail, and delete the original message. TPrsc> *** -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] Select news based on dates

ate = $news["date"]; >> } >> >> >> Monday, May 17, 2004, 3:50:04 PM, T. wrote: >> >> THG> Hello, >> >> THG> I would like to display my news like this: >> >> THG> *10.04.2004.* >> THG> - news 1 >> T

Re: [PHP-DB] Select news based on dates

G> I'm thinking of some while loop but I'm not sure that it will work nor I THG> know how to create that query. THG> TNX -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] more detail..passing array_var with $_get

purpose is that i add all product 1 by 1 in my local pc SK> then just adding to database in server at once... SK> the best way is using array right?? if i using session then it just the same result SK> thanx -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP

Re: [PHP-DB] passing var array

when I echo it, it appear "array"... SK> Thanx SK> Sk2 -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] db query problem

rdId. JB> Can this be done in a subquery or is two queries required? JB> Having worked mostly with MySQL I dont' have a lot of experience with JB> subqueries. JB> Any suggestions on the best way to approach this probelm? -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] db query problem

o queries required? JB> Having worked mostly with MySQL I dont' have a lot of experience with JB> subqueries. JB> Any suggestions on the best way to approach this probelm? -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] Handling missing rows on joins

d RB> of business, service, or organization that uses user registration and RB> storage of personal details)... -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Handling missing rows on joins

ng levels will cause problems as well, but the RB> code for that has been made so deleting a level will move all users assigned RB> to that level to a different one. RB> Any suggestions for handling this better would be appreciated ... RB> TIA RB> Rene RB> -- RB> Rene Brehmer

Re[2]: [PHP-DB] Curious if include_once will work better than include

e more EG> than once will alter the result, than use include_once. Another EG> alternative is to use require() or require_once() to make sure that the EG> file is included. Just my $.02, EG> Eric -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Curious if include_once will work better than include

ed to just using a plain "include". I call $connectionSDWIS(which is in the include) 5 different times? -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] Tuesday, April 13, 2004, 7:52:10 PM, Karen wrote: KR> Curious about "include_once" versus "include&qu

Re: [PHP-DB] How to get only 2nd row in result set ???

net/ RB> References, tools, and other useful stuff... RB> Check out the new Metalbunny forums @ http://forums.metalbunny.net/ -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] passing a variable value of PHP into the alert of JavaScript.

on of PHP code from HTML tag just the same as I call a function of JavaScript from HTML tag? PS> I meant, Like this "CustID"; PS> - Original Message - PS> From: "Mikhail U. Petrov" <[EMAIL PROTECTED]> PS> Date: Tue, 30 Mar 2004 17:35:33 +0400 PS> To:

Re: [PHP-DB] passing a variable value of PHP into the alert of JavaScript.

Hi! I didn't exactly understood what you mean, but I think there're no problems with it... You should echo these variables into html, for example: bla bla bla function my_alert(name, lastname, address){ alert(name); } bla bla bla Hello Prabu, Tuesday, March 30, 2004, 5:21:39 PM, you wrote: P

Re: [PHP-DB] checkboxes and loops

Hi! I think you should rename checkboxes to box[1], box[2] etc. So you will get an array $_POST["box"]. I think it will be better. Best wishes, Mikhail U. Petrov, PHP-programmer Hello matthew, Monday, March 29, 2004, 9:45:28 AM, you wrote: mp> OK lets see if I can figure out ho

Re: [PHP-DB] Select Query--Need help urgently

s in advance. ijc> Regards, ijc> Irin Can you exactly describe results of your query? And I noticed that tablename - "Class", but in query it's "class"... Try to correct and write the results. -- Best wishes, Mikhail U. Petrov PHP-programmer -- PHP Dat

Re[2]: [PHP-DB] Need help with MySQL query

r_id, a.partner_name VD> from partner a, program b VD> where a.partner_id = b.partner_id VD> and b.partner_id in (1, 2, 3) >> Best wishes, >> Mikhail U. Petrov. >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://

[PHP-DB] Need help with MySQL query

Hi! I need help with simple mysql query. I have table: program{ program_id, partner_id } partner{ partner_id, parnter_name } how I can get number of distinct partner_id's where program_id in ( bla bla bla)? Best wishes, Mikhail U. Petrov. -- PHP Database Ma