Re: Cant change anything via web?
Hi Tyler, Most probably there is a problem in PHP configuration if you are sure MySQL is working properly. You didn't get any errors, did you? If not and you have acces to php.ini change the error reporting level to E_ALL. If you don't have acces to php.ini, call the error_reporting (E_ALL); so that you could get some verbose output from PHP about what the problem. Fero - Original Message - From: "Tyler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 15:43 Subject: Cant change anything via web? > Hey.. I've got a promblem. I use PHP, and I cant seem to be able to change > anything in the MySQL db via the webpage. I know the scripts are correct, > but nothing happens when I change somethign via web. I've even installed > PhpMyAdmin to moniter the DB via the web, and that doesn't work either. I > dont knwo whats wrong.. but the only way I can edit my DB is to do it via > mysqladmin ON the linux box > > -Thanks oin advance > Tyler > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin and mysql
Hello Martin, Your problem is related to PHP not MySQL. You should check the max_post_size directive in yor php.ini file. AFAIK, this limit is set to 8M. If you decreased the size, increasing it may solve your problem. max_post_size controls the maximim POST size you can do, and if you exceed this limit, your post will be discarded. - Original Message - From: "Martin Hudec" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 08, 2002 13:53 Subject: phpmyadmin and mysql > Hello MySQL, > > we have this problem: > > when using phpmyadmin if we select database to view and we put SQL > command to ENTER SQL QUERY/QUERIES TO DATABASE field and submit it, > it will display NO SQL QUERYwhat is wrong? > > please help me...thank you > > -- > Best regards, > Martin mail [EMAIL PROTECTED] > mobile +421.907.303.393 > icq34358414 > wwwhttp://www.corwin.sk > > PGP key fingerprint 21365ca05ecfd8aeb1cf19c838fff033 > > "In those days spirits were brave, the stakes were high, > men were real men, women were real women and small furry > creatures from Alpha Centauri were real small furry creatures > from Alpha Centauri." > > by Douglas Adams > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query only returns one row
Hi Chris,
You need to use a while loop to fetch all of the records returned in the
SELECT statement in PHP, as follows:
\n", $row["DBID"];
printf("First Name: %s\n",$row["FIRST_NAME"];
printf("Last Name: %s\n", $row["LAST_NAME"];
}
?>
- Original Message -
From: "Admin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 16:47
Subject: query only returns one row
>
>
> Hi,
>
> I finally established a connection to my db after I realized that it was
> located in a different directory than that which I kept placing my php
> files. As some would say, "D'OH!"
>
> The code below is intended to select and display all 1300 names from the
> NAMES_TBL but is only returning the first row. I'm still a bit new to php
> so this is probably something simple - a shove in the right direction
would
> be quite helpful.
>
> thanks!
>
> chris
>
>$db = mysql_connect("host", "user", "pwd");
> mysql_select_db("dbname",$db);
> $result = mysql_query("SELECT * FROM NAMES_TBL",$db);
> printf("DBID: %s\n", mysql_result($result,0,"DBID"));
> printf("First Name: %s\n", mysql_result
> ($result,0,"FIRST_NAME"));
> printf("Last Name: %s\n", mysql_result($result,0,"LAST_NAME"));
> ?>
>
> --
-
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql web-based admin tool?
Hi, The most widely used tool to reach MySQL over PHP is phpMyAdmin. You can obtain it from http://www.phpwizard.net/projects/phpMyAdmin/ - Original Message - From: "Ed Lazor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 5:53 PM Subject: mysql web-based admin tool? > I used to use some php scripts that allowed me to work on my database. I'm > trying to find them again... anyone know what they might have been called > or where to find them? > -Ed > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: localhost problem
It seems at least one of your username and/or password is not as you might think. You should find the my.ini file, which is either should be in C:\Windows for M$ Windows'98, and change your username-password info. After relaoding mysql, it should function. Regards - Original Message - From: "Pafo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 4:55 PM Subject: Re: localhost problem am still getting the same message http://www.pafo.net/mysql5.gif regards pafo - Original Message - From: <[EMAIL PROTECTED]> To: "Pafo" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 2:34 PM Subject: Re: localhost problem > On Wed, 21 Nov 2001, Pafo wrote: > > i still cant get pass this problem, i have now uninstalled PWS and still i cant access > > why why why why? http://www.pafo.net/mysql4.gif > > i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and > > i am connected thru a network card in my computer to the internet, all the time. > > Try logging in with "mysql -u root", then read up in the manual on the > grant system for adding other users. > > Sincerely, > Jan > > -- > Mr. Jan-Aage Bruvoll IT Project Manager > 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich > Zurich office: +41 1 307 4293, fax: +41 1 307 4281 > Office/fax: +44 2072408283 Mobile: +44 7740291600 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
