[PHP] PHP Udate MySQL command

I am trying to get an update command to work in PHP. I am able to update records going directly to phpmyadmin command line. I have even let it produce the php code to insert, but have not been able to get it to work. I have it stripped down to one command hoping to get it to work then

Re: [PHP] PHP Udate MySQL command

On Fri, 2010-06-04 at 06:46 -0400, Gary wrote: I am trying to get an update command to work in PHP. I am able to update records going directly to phpmyadmin command line. I have even let it produce the php code to insert, but have not been able to get it to work. I have it stripped down

Re: [PHP] PHP Udate MySQL command

Ashley Sheridan a...@ashleysheridan.co.uk wrote in message news:1275649100.2217.45.ca...@localhost... On Fri, 2010-06-04 at 06:46 -0400, Gary wrote: I am trying to get an update command to work in PHP. I am able to update records going directly to phpmyadmin command line. I have even let it

Re: [PHP] PHP Udate MySQL command Success

Gary gwp...@ptd.net wrote in message news:a9.ea.07323.381e8...@pb1.pair.com... Ashley Sheridan a...@ashleysheridan.co.uk wrote in message news:1275649100.2217.45.ca...@localhost... On Fri, 2010-06-04 at 06:46 -0400, Gary wrote: I am trying to get an update command to work in PHP. I am

[PHP] PHP and MySQL SELECT COUNT (*)

What I want to do is find the top 10 servers where the column steps = iisreset. The following code works great except that the page is not displaying the servername in the 'Server Name' column of my results (nothing appears, the column is just blank). servername and steps are the important

Re: [PHP] PHP and MySQL SELECT COUNT (*)

On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: What I want to do is find the top 10 servers where the column steps = iisreset. The following code works great except that the page is not displaying the servername in the 'Server Name' column of my results (nothing

Re: [PHP] PHP and MySQL SELECT COUNT (*)

Dan Joseph [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: What I want to do is find the top 10 servers where the column steps = iisreset. The following code works great except that the page is not displaying

Re: [PHP] PHP and MySQL SELECT COUNT (*)

On Wed, Sep 17, 2008 at 2:30 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: Dan Joseph [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED] wrote: What I want to do is find the top 10 servers where the column steps =

Re: [PHP] PHP and MySQL SELECT COUNT (*)

Dan Joseph [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:30 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: Dan Joseph [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED] wrote: What

Re: [PHP] PHP and MySQL SELECT COUNT (*)

You'll want to change your Order By statement to 'ORDER BY CountSteps DESC'. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: echo $query; yields SELECT servername, COUNT(steps) as CountSteps FROM monitoring WHERE steps =

Re: [PHP] PHP and MySQL SELECT COUNT (*)

Still no luck displaying the stupid servername. Any other things I can try? Micah Gersten [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You'll want to change your Order By statement to 'ORDER BY CountSteps DESC'. Thank you, Micah Gersten onShore Networks Internal Developer

Re: [PHP] PHP and MySQL SELECT COUNT (*)

On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: What I want to do is find the top 10 servers where the column steps = iisreset. The following code works great except that the page is not displaying the servername in the 'Server Name' column of my results (nothing

Re: [PHP] PHP and MySQL SELECT COUNT (*)

Do var_dump($i) in the loop to see if you're getting the data you want. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: Still no luck displaying the stupid servername. Any other things I can try? Micah Gersten [EMAIL PROTECTED]

Re: [PHP] PHP and MySQL SELECT COUNT (*)

Dan Joseph [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: What I want to do is find the top 10 servers where the column steps = iisreset. The following code works great except that the page is not displaying

Re: [PHP] PHP and MySQL SELECT COUNT (*)

var_dump($i); looks messy, but I can see the server names in there and they are the correct names. Micah Gersten [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Do var_dump($i) in the loop to see if you're getting the data you want. Thank you, Micah Gersten onShore Networks

Re: [PHP] PHP and MySQL SELECT COUNT (*)

What is the key for the server name? That's what you need when you output it. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: var_dump($i); looks messy, but I can see the server names in there and they are the correct names. Micah

Re: [PHP] PHP and MySQL SELECT COUNT (*)

On Wed, Sep 17, 2008 at 4:21 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: var_dump($i); looks messy, but I can see the server names in there and they are the correct names. Micah Gersten [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Do var_dump($i) in the loop to see if you're

Re: [PHP] PHP and MySQL SELECT COUNT (*)

var_dump looks like this: array(2) { [0]= string(9) wehost006 [1]= string(2) 72 } array(2) { [0]= string(8) H7848-49 [1]= string(2) 71 } array(2) { [0]= string(7) H7853-2 [1]= string(2) 70 } array(2) { [0]= string(7) H7842-2 [1]= string(2) 64 } array(2) { [0]= string(9) WEHOST005 [1]=

Re: [PHP] PHP and MySQL SELECT COUNT (*)

If by key you mean the column in the database, it's called: servername Micah Gersten [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What is the key for the server name? That's what you need when you output it. Thank you, Micah Gersten onShore Networks Internal Developer

Re: [PHP] PHP and MySQL SELECT COUNT (*)

That's your problem, you need to use mysql_fetch_assoc instead of mysql_fetch_row. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: var_dump looks like this: array(2) { [0]= string(9) wehost006 [1]= string(2) 72 } array(2) { [0]=

Re: [PHP] PHP and MySQL SELECT COUNT (*)

On Wed, Sep 17, 2008 at 4:30 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: If by key you mean the column in the database, it's called: servername Micah Gersten [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What is the key for the server name? That's what you need when you output

Re: [PHP] PHP and MySQL SELECT COUNT (*)

I meant key in the array that was returned by MySQL. I answered you in my other post. The array was numerically index based instead of column based. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: If by key you mean the column in the

Re: [PHP] PHP and MySQL SELECT COUNT (*)

That was it!!! Thank you all so much for your help!!! =D Dan Joseph [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 4:30 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: If by key you mean the column in the database, it's called: servername Micah Gersten [EMAIL

Re: [PHP] PHP and MySQL SELECT COUNT (*)

Dan Joseph schreef: On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]wrote: ... $i[servername] Try: $i['servername'] notice the ' and ' around the name. I've heard you can do w/o those, but I've had issues in the past where it didn't work. ITs also good practice to use

Re: [PHP] PHP querying mysql db for data limited to the last month

Vinny Gullotta wrote: So I have this code I'm working with (pasted below) that queries a mysql db table called timetracking. The goal of the page is to search the db for all data based on a certain engineer, sorted by product and it takes pre-defined values based on actions performed, sums

Re: [PHP] PHP querying mysql db for data limited to the last month

Sorry, I took that stuff out because it was making the page not load and so I figured it was wrong. I guess I should have posted the whole thing, but since it didn't work I left it out. Micah, thank you very much for the idea, it is working great!!! Micah Gersten [EMAIL PROTECTED] wrote in

[PHP] PHP querying mysql db for data limited to the last month

So I have this code I'm working with (pasted below) that queries a mysql db table called timetracking. The goal of the page is to search the db for all data based on a certain engineer, sorted by product and it takes pre-defined values based on actions performed, sums them based on product and

Re: [PHP] PHP querying mysql db for data limited to the last month

1. To get last months date, you can use strtotime(1 month ago) instead of mktime. 2. I don't see anywhere in the code where you are limiting by date. Try using and . Between is tricky on dates. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny

[PHP] PHP + PDO + MySQL + Stored Procedure + PREPARE = Problem

Hi all, I've found a bug when working on a PHP script using a PDO connector. When I made a Store Procedure using the PREPARE statement something messed up the result im my PHP script. Please go to my blog http://huzed.com/zed/?p=21 and see code. Tanks for help. ZED -- PHP General

Re: [PHP] PHP 6: Mysql with iso-8859-1 chars outputting utf-8: Could not convert binary string to Unicode string

This is a question from a guy who does NOT really do Unicode very well... If everything else in your entire system is iso-8859-1 (aka Latin1) why are you making your output be utf-8? Seems to me that that is where the conversion is probably taking place... On Sun, April 29, 2007 11:07 am,

Re: [PHP] PHP 6: Mysql with iso-8859-1 chars outputting utf-8: Could not convert binary string to Unicode string

the field values, as I understanded from the above explanation. Did I understood it wrong? Thanks, Rangel - Original Message - From: Richard Lynch [EMAIL PROTECTED] To: Rangel Reale [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Wednesday, May 02, 2007 6:53 PM Subject: Re: [PHP] PHP

Re: [PHP] PHP 6: Mysql with iso-8859-1 chars outputting utf-8: Could not convert binary string to Unicode string

On Wed, May 2, 2007 5:32 pm, Rangel Reale wrote: You are right, I really don't know Unicode very much! :P What I was trying to understand was, because unicode.runtime_encoding = iso-8859-1, I tought that all internal operations were done in this encoding, and only when outputting

[PHP] PHP 6: Mysql with iso-8859-1 chars outputting utf-8: Could not convert binary string to Unicode string

Hello! I have a MySQL database where all tables are in the latin1 character set, with accented (Portuguese) characters. In my php.ini I have ; Unicode settings ; unicode.semantics = on unicode.runtime_encoding = iso-8859-1 unicode.script_encoding =

[PHP] php and mysql date mapping question

Hi all, I am in the process of creating a national events directory where people can enter their events (car boot sales, evening classes etc) and specify whether those events are one-ff events or repeating (daily, weekly etc) affairs and people can search for those events by postcode, date range,

Re: [PHP] php and mysql date mapping question

Dave Goodchild wrote: Hi all, I am in the process of creating a national events directory where people can enter their events (car boot sales, evening classes etc) and specify whether those events are one-ff events or repeating (daily, weekly etc) affairs and people can search for those events

Re: [PHP] PHP and mySQL dates

On Wed, September 13, 2006 5:56 am, Dave Goodchild wrote: Hi all. I am building an online events registry and have mapped out all the dates between Oct 1 2006 and Dec 31 2030, stored in the database as timestamps incremented by 86400 to give daily slots. I have output the values using the php

[PHP] PHP and mySQL dates

Hi all. I am building an online events registry and have mapped out all the dates between Oct 1 2006 and Dec 31 2030, stored in the database as timestamps incremented by 86400 to give daily slots. I have output the values using the php date function and all is well. Users can enter either one-off

RE: [PHP] PHP and mySQL dates

[snip] Hi all. I am building an online events registry and have mapped out all the dates between Oct 1 2006 and Dec 31 2030, stored in the database as timestamps incremented by 86400 to give daily slots. [/snip] I do not really understand the purpose of mapping all dates between Oct 1 2006 and

Re: [PHP] PHP and mySQL dates

Thanks. I have been so up close and personal with this that I can't see the wood for the trees. Of course, so obvious. Thank you - you have made me very happy. -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk

RE: [PHP] PHP and mySQL dates

No problem, now I will go and make my girlfriend happy :) -Original Message- From: Dave Goodchild [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 13, 2006 6:27 PM To: Peter Lauri Cc: PHP General Subject: Re: [PHP] PHP and mySQL dates Thanks. I have been so up close and personal

Re: [PHP] PHP and mySQL dates

Good luck with that. -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk

Re: [PHP] PHP and mySQL getting smashed...

versions of PHP/MySQL that make this answer a no-go. Tread carefully. But it's at least an on-topic answer, even if an incomplete and maybe downright bad answer. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP] PHP and mySQL getting smashed...

I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what to do to make the mysql connections more efficient, or anything in general. No bandwidth issue here, just the server getting killed. Thanks

Re: [PHP] PHP and mySQL getting smashed...

) may help. Also, optimise your tables and use the explain command to see how efficient your queries are. -- http://www.web-buddha.co.uk dynamic web programming from Reigate, Surrey UK (php, mysql, xhtml, css) look out for project karma, our new venture, coming soon!

Re: [PHP] PHP and mySQL getting smashed...

perhaps post some code so we can look at how you doing your queries... HTH Angelo Zanetti Z Logic www.zlogic.co.za [c] +27 72 441 3355 [t] +27 21 469 1052 [f] +27 86 681 5885 Dave Goodchild wrote: I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what

RE: [PHP] PHP and mySQL getting smashed...

[snip] I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what to do to make the mysql connections more efficient, or anything in general. No bandwidth issue here, just the server getting killed. [/snip] Without seeing any code or table information my bet

Re: [PHP] PHP and mySQL getting smashed...

On 17/05/06, Dave Goodchild [EMAIL PROTECTED] wrote: I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what to do to make the mysql connections more efficient, or anything in general. No bandwidth issue here, just the server getting killed. ...I may be

Re: [PHP] PHP and mySQL getting smashed...

Jay Blanchard wrote: [snip] I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what to do to make the mysql connections more efficient, or anything in general. No bandwidth issue here, just the server getting killed. [/snip] Without seeing any code or table

[PHP] PHP based MySQL report generators?

Has anyone encountered an open-source PHP-based report generator for MySQL? I haven't been able to find one yet. We have several people in our company that need to create reports from a master database (consisting of several tables). Ideally I'd like a similar functionality that MS Access

Re: [PHP] PHP and MySQL and resouce limits

. Inspect it carefully. Use the mysql monitor to run it. Can MySQL, without PHP in the picture, run that query in practical time/memory constraints? How many rows does it actually return? How much data in each row? Dollars to doughnuts sez your query isn't doing what you think it's doing

[PHP] PHP and MySQL and resouce limits

I don't get it... I have been upping my memory limit for PHP. 32megs now... and am making calls to a database on a different server. I see the loads run up on the other server as it cruches the numbers.. and PHP is in the process of creating a single little page with about 40 numbers on it,

Re: [PHP] PHP and MySQL and resouce limits

John Hinton wrote: I don't get it... I have been upping my memory limit for PHP. 32megs now... and am making calls to a database on a different server. I see the loads run up on the other server as it cruches the numbers.. and PHP is in the process of creating a single little page with

[PHP] Php with mysql

Hi friends, I am Rittwick Banerjee Some one gave me an idea about that past php code that is : $sql = SELECT `User_name` AND `User_pass` FROM `user` WHERE `User_name` = '$_POST['user_id']' AND '$_POST['user_id']' ; but I found that it still not working ... Plaese give me

RE: [PHP] Php with mysql

`User_name` , (replaces AND) `User_pass` FROM `user` WHERE `User_name` = '$_POST['user_id']' AND '$_POST['user_id']' -Original Message- From: Rittwick Banerjee [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 09:01 To: php-general@lists.php.net Subject: [PHP] Php with mysql Hi friends, I am

RE: [PHP] Php with mysql

To: php-general@lists.php.net Subject: [PHP] Php with mysql Hi friends, I am Rittwick Banerjee Some one gave me an idea about that past php code that is : $sql = SELECT `User_name` AND `User_pass` FROM `user` WHERE `User_name` = '$_POST['user_id']' AND '$_POST['user_id

RE: [PHP] Php with mysql

[snip] $sql = SELECT `User_name` AND `User_pass` FROM `user` WHERE `User_name` = '$_POST['user_id']' AND '$_POST['user_id']' ; [/snip] echo $sql; //to see the query and check the syntax $sql = SELECT `User_name` AND `User_pass` FROM `user` WHERE `User_name` = ' . $_POST['user_id'] . ' AND ' .

[PHP] PHP 5, mySQL and Win XP. I NEED HELP

a instal of the latest mySQL and PHP 5 on my computer. I have made the following changes to my php.ini file extension=php_mysql.dll extension_dir = c:\php\ and i have put the php_mysql. and libmysql.dll in c:\php\ and in c:\windows to Now i try this in my php-file $con

Re: [PHP] PHP 5, mySQL and Win XP. I NEED HELP

of the latest mySQL and PHP 5 on my computer. I have made the following changes to my php.ini file extension=php_mysql.dll extension_dir = c:\php\ and i have put the php_mysql. and libmysql.dll in c:\php\ and in c:\windows to Now i try this in my php-file $con = mysql_connect(localhost

Re: [PHP] PHP 5, mySQL and Win XP. I NEED HELP

Hi, If you are using localhost, i dont think u need to specify the port number. Localhost would be enough. Also pls check the user privileges and all in the database. ..Deep.. --- Oscar Andersson [EMAIL PROTECTED] wrote: I have made a instal of the latest mySQL and PHP 5 on my computer. I

[PHP] PHP 5, mySQL and Win XP. I NEED HELP

I have made a instal of the latest mySQL and PHP 5 on my computer. I have made the following changes to my php.ini file extension=php_mysql.dll extension_dir = c:\php\ and i have put the php_mysql. and libmysql.dll in c:\php\ and in c:\windows to Now i try this in my php-file $con

Re: [PHP] PHP 5, mySQL and Win XP. I NEED HELP

hey On 5/5/05, Oscar Andersson [EMAIL PROTECTED] wrote: I have made a instal of the latest mySQL and PHP 5 on my computer. I have made the following changes to my php.ini file extension=php_mysql.dll extension_dir = c:\php\ and i have put the php_mysql. and libmysql.dll in c:\php

[PHP] PHP 4.3/MySQL phpinfo()

I have installed FC 3 with Apache and MySQL. When I run phpinfo(), I do not see MySQL listed as a database nor can I connect via php. Does something have to be specially done with the FC 3 install? Todd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] PHP 4.3/MySQL phpinfo()

On Tuesday 05 April 2005 23:35, Todd Cary wrote: Does something have to be specially done with the FC 3 install? I kindly redirect you to google for LAMP which is short for Linux Apache MySQL PHP I have also learned to setup this kind of system on Fedora Core 3. While you CAN rely

RE: [PHP] PHP 4.3/MySQL phpinfo()

Todd Cary mailto:[EMAIL PROTECTED] on Tuesday, April 05, 2005 2:35 PM said: I have installed FC 3 with Apache and MySQL. When I run phpinfo(), I do not see MySQL listed as a database nor can I connect via php. Does something have to be specially done with the FC 3 install? Other than

Re: [PHP] PHP/5.0.3 MySQL 5.0.2 Stored procedure (OUT)

Curt Zirzow wrote: * Thus wrote Ian Porter: Hi, I am just wondering how to obtain the result from a mysql procedure OUT parameter within PHP e.g. MYSQL create procedure test_out(OUT testvar int) BEGIN select max_connections into testvar from mysql.user limit 1; END PHP $query

[PHP] PHP/5.0.3 MySQL 5.0.2 Stored procedure (OUT)

Hi, I am just wondering how to obtain the result from a mysql procedure OUT parameter within PHP e.g. MYSQL create procedure test_out(OUT testvar int) BEGIN select max_connections into testvar from mysql.user limit 1; END PHP $query = 'call test_out('.$test_val.')'; $query_handle

Re: [PHP] PHP/5.0.3 MySQL 5.0.2 Stored procedure (OUT)

* Thus wrote Ian Porter: Hi, I am just wondering how to obtain the result from a mysql procedure OUT parameter within PHP e.g. MYSQL create procedure test_out(OUT testvar int) BEGIN select max_connections into testvar from mysql.user limit 1; END PHP $query = 'call test_out

[PHP] PHP based mysql search tool

I am looking for a full featured search tool I can plug into a couple of databases via a php front end. I currently have some of the text indexing done and have some basic search setup, using mysql queries like select from table where match 'search term' against column; But am looking for

Re: [PHP] PHP any Mysql connection- new b

On Sat, 8 Jan 2005 16:10:47 + (GMT), babu [EMAIL PROTECTED] wrote: Hi all, I am using php 3.0 and mysql and win xp. i want to add users to database through php page. adduser.php html FORM METHOD=post ACTION=add.php Real Name: INPUT TYPE=text MAXLENGTH=70 NAME=real_name SIZE=20Br

[PHP] PHP any Mysql connection- new b

Hi all, I am using php 3.0 and mysql and win xp. i want to add users to database through php page. adduser.php html FORM METHOD=post ACTION=add.php Real Name: INPUT TYPE=text MAXLENGTH=70 NAME=real_name SIZE=20Br Username: INPUT TYPE=text MAXLENGTH=70 NAME=username SIZE=20Br Password: Input

[PHP] PHP 5 MySql 4.1 issue - can't connect to mysql.sock

I am familiar with MySql, Linux and database programming in general, but I have not used PHP very much. On my server, I had an application running just fine under PHP 4.1 and MySql 3.23. For various reasons, I needed to move to MySql 4.1. When I did so, the PHP application was broken. I poked

[PHP] PHP info: MySQL client API version: 3.23?

In the phpinfo() output, the MySQL client API version is shown as 3.23.49. Shouldn't this be upgraded to 4.1 (generally available/stable)? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PHP info: MySQL client API version: 3.23?

from one of my machines: [root]# rpm -qa|grep mysql php-mysql-4.3.2-14.ent mysql-server-3.23.58-1 libdbi-dbd-mysql-0.6.5-5 mysql-devel-3.23.58-2.3 mysql-3.23.58-2.3 My phpinfo client API shows: 3.23.58 Which would be because that is the version of mysql that I am running. My mysql, mysql-server

Re: [PHP] PHP info: MySQL client API version: 3.23?

that is internal to PHP itself. So if you upgrade your mysql, it will show you a different version when you run your phpinfo. Here is an rpm -qa result from one of my machines: [root]# rpm -qa|grep mysql php-mysql-4.3.2-14.ent mysql-server-3.23.58-1 libdbi-dbd-mysql-0.6.5-5 mysql-devel-3.23.58-2.3 mysql

Re: [PHP] PHP info: MySQL client API version: 3.23?

, it will show you a different version when you run your phpinfo. Here is an rpm -qa result from one of my machines: [root]# rpm -qa|grep mysql php-mysql-4.3.2-14.ent mysql-server-3.23.58-1 libdbi-dbd-mysql-0.6.5-5 mysql-devel-3.23.58-2.3 mysql-3.23.58-2.3 My phpinfo client API shows: 3.23.58

Re: [PHP] PHP info: MySQL client API version: 3.23?

John Nichel wrote: Steve Buehler wrote: My phpinfo client API shows: 3.23.58 Which would be because that is the version of mysql that I am running. My mysql, mysql-server and mysql-devel are all 3.23.58. Only my php-mysql module is 4.3.2-14 No, this is not the case. If you install with RPM

Re: [PHP] PHP info: MySQL client API version: 3.23?

Olaf van der Spek wrote: But why is the bundled client not upgraded? Aren't 4.0 and 4.1 clients backwards compatible with 3.23 server? Why they didn't upgrade the bundle to include the 4.0 release, I don't know. However with the password 'issues' between 4.1 and earlier versions, I'm sure

Re: [PHP] PHP info: MySQL client API version: 3.23?

if you upgrade your mysql, it will show you a different version when you run your phpinfo. Here is an rpm -qa result from one of my machines: [root]# rpm -qa|grep mysql php-mysql-4.3.2-14.ent mysql-server-3.23.58-1 libdbi-dbd-mysql-0.6.5-5 mysql-devel-3.23.58-2.3 mysql-3.23.58-2.3 My

Re: [PHP] PHP info: MySQL client API version: 3.23?

John Nichel wrote: Olaf van der Spek wrote: But why is the bundled client not upgraded? Aren't 4.0 and 4.1 clients backwards compatible with 3.23 server? Why they didn't upgrade the bundle to include the 4.0 release, I don't know. However with the password 'issues' between 4.1 and earlier

Re: [PHP] PHP info: MySQL client API version: 3.23?

Olaf van der Spek wrote: snip Isn't that only an issue for 4.1 clients and = 4.1 servers and not for the 'other way around'? I was actually asking because I have a 4.1 server and I couldn't use PHP to connect, because it doesn't support new passwords. It works both ways. You can make your 4.1

Re: [PHP] PHP info: MySQL client API version: 3.23?

to compile it from source and use PHP5. I don't think php4 supports 4.1 (mysql vs mysqli). -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] php with mysql ( support data manipulation or not )??

Hi , Regarding to php with mysql , if the php with mysql implement data manipulating like (insert , update , delete ..etc) or just implement the query operation only ??. Best Regards,, ayman amin Egypt - Cairo

RE: [PHP] php with mysql ( support data manipulation or not )??

[snip] Regarding to php with mysql , if the php with mysql implement data manipulating like (insert , update , delete ..etc) or just implement the query operation only ??. [/snip] You can do any SQL operation with PHP and MySQL. -- PHP General Mailing List (http://www.php.net/) To unsubscribe

[PHP] PHP and MySQL Installation on Apache for Windows

Does anyone know how to get PHP to detect MySQL after it has been installed and is running on an Apache 1.3.1 server for Windows? Any help would be greatly appreciated.

[PHP] PHP + Multiple MySQL-4.0.20

specifically, phpMyAdmin-2.5.6 says cannot load MySQL extension, please check PHP Configuration. Documentation I haven't a clue as to how to resolve this. My guess is, like the MySQL RPM, uninstall it and do a non-RPM install... If I get the source and run configure... it seems like

Re: [PHP] PHP + Multiple MySQL-4.0.20

specifically, phpMyAdmin-2.5.6 says To get more detailed information as what is happening try this: php -d display_errors=On \ -d display_startup_errors=On \ -d error_reporting=E_ALL \ -r mysql_connect() cannot load MySQL extension, please check PHP Configuration. Documentation

[PHP] php/apache/mysql on ntfs

hi... we are upgrading test servers to xp home and want to know if its possible to run php/apache/mysql and all that sort of stuff on ntfs or does the servers have to run fat32?? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Fw: [PHP] php/apache/mysql on ntfs

does anybody have any idea why this message keeps coming up every time i send a msg to the list?? im sort of confused now - Original Message - From: [EMAIL PROTECTED] To: Andy B [EMAIL PROTECTED] Sent: Saturday, April 24, 2004 7:17 AM Subject: NDN: [PHP] php/apache/mysql on ntfs Sorry

Re: [PHP] php/apache/mysql on ntfs

what FS it is anyway, since it's not for them to worry about ... Rene According to historical records, on Sat, 24 Apr 2004 07:18:40 -0400 Andy B wrote about [PHP] php/apache/mysql on ntfs: hi... we are upgrading test servers to xp home and want to know if its possible to run php/apache/mysql

Re: [PHP] php/apache/mysql on ntfs

Apr 2004 07:28:07 -0400 Andy B wrote about Fw: [PHP] php/apache/mysql on ntfs: does anybody have any idea why this message keeps coming up every time i send a msg to the list?? im sort of confused now - Original Message - From: [EMAIL PROTECTED] To: Andy B [EMAIL PROTECTED] Sent: Saturday

Re: Fw: [PHP] php/apache/mysql on ntfs

* Thus wrote Andy B ([EMAIL PROTECTED]): does anybody have any idea why this message keeps coming up every time i send a msg to the list?? im sort of confused now I've gotten so used to them now, that I consider them receipts that my messages have been posted to everyone :) Curt -- I used to

RE: [PHP] php and mysql help

PM To: Jay Blanchard Subject: RE: [PHP] php and mysql help Please remove my address from any future correspondence about PHP. Jay, you are confusing persons at a university with persons who may have a Clue [TM] David (also recipient of this message) -- PHP General Mailing List (http

RE: [PHP] php and mysql help

Why are you sending this to me? You're at Stanford, you can probably figure out the unsubscribe link and stuff -Original Message- From: David A. Stevens [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 12:41 PM To: Jay Blanchard Subject: RE: [PHP] php and mysql help Please remove

[PHP] php and mysql help

Hello i need help with mysql_create_db i found the solution once but cant remember what it was if someone could tell me the proper way to create a database with php and mysql i would be greatly thankfull. Thank you.

Re: [PHP] php and mysql help

* Thus wrote webmaster ([EMAIL PROTECTED]): Hello i need help with mysql_create_db i found the solution once but cant remember what it was if someone could tell me the proper way to create a database with php and mysql i would be greatly thankfull. You just need to issue a create database

RE: [PHP] php and mysql help

[snip] Hello i need help with mysql_create_db i found the solution once but cant remember what it was if someone could tell me the proper way to create a database with php and mysql i would be greatly thankfull. Thank you. [/snip] http://www.php.net/mysql_create_db You're welcome. -- PHP General

[PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T

Hi, I have a table where a users details are entered for the products he bought, the only part that is repeated is the order_id, I basically need to only get the order per person, and paginate for all the customers eg: if user tom bought 3 items in the database it would be entered as: order_id

Re: [PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T

Try this: SELECT COUNT(*), order_number FROM . $prefix . _purchases GROUP BY order_number as your query. Shaunak - Original Message - From: Ryan A [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 09, 2004 8:36 PM Subject: [PHP] php with mysql COUNT, DISTINCT syntax

Re: [PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T

this: SELECT COUNT(*), order_number FROM . $prefix . _purchases GROUP BY order_number as your query. Shaunak - Original Message - From: Ryan A [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 09, 2004 8:36 PM Subject: [PHP] php with mysql COUNT, DISTINCT syntax

[PHP] PHP and MySQL date

Hi all, I'm making a site and need some tables from wich I can extract date, time and/or date/time later with PHP and I neved had very clear the way the possible formats work with each other so my question is what is the best (or recommended) method to store dates and/or times in a MySQL DB

  1   2   3   >