Thanks, again, Elizabeth! Makes sense. I hadn't started the documentation
yet because I was trying to get a working understanding of things first by
going through a tutorial. I realize now that my tutorial was for an earlier
version of PHP and MySQL, so things like this are going to be a problem
Tim wrote:
> I spoke to soon. Your tip did manage to get the MySQL section to show up in
> the output of phpinfo(), and the connect command doesn't throw an error
> anymore, but now I get the same Undefined Function error on the line to
> create a db:
>
> mysql_create_db("dbName") or die(mysql_err
I spoke to soon. Your tip did manage to get the MySQL section to show up in
the output of phpinfo(), and the connect command doesn't throw an error
anymore, but now I get the same Undefined Function error on the line to
create a db:
mysql_create_db("dbName") or die(mysql_error());
Why would it be
That was it! Thank you so much!
I'm working through a tutorial/book, and the text didn't even mention this!
Wow, good tip for newbies!
Thanks again!
Tim R.
"Elizabeth M Smith" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>> However, the results of my phpinfo() do not show a My
> However, the results of my phpinfo() do not show a MySQL section (I don't
> know if there should be one, I'm new to this).
Mysql should show up - one piece of information that I DON'T see that is
probably the most important - is your php.ini being loaded? You should
see a section in the top o
perhaps u not configure the user first>??
SSL not read as localhost
- Original Message -
From: "Adam Madsen" <[EMAIL PROTECTED]>
To:
Sent: Thursday, April 26, 2007 10:16 AM
Subject: [PHP-WIN] Re: MySQL + SSL with PHP on windows
> I have been having the same issu
I have been having the same issue.
Using PHP 5.2.1 mysql or mysqli I can not connect to a remote Mysql server
using SSL
I can get it to work on a mysql command line client just not with PHP.
Has anyone ever had this working on an IIS box?
Adam Madsen
--
IT Director Transwest Gr
if you are using Apache Web server, you don't have to put in windows
system directory.
You can put php.ini and libMySQL.dll in your apache bin directory. eg.
c:\apache\bin\php.ini libMySQL.dll. If you don't copy libMySQL.dll to
bin directory. Apache can't load your Mysql DLL (php_mysql.dll).
Make sure you have correct extension_dir value in your php.ini
Sincerely,
Rosty Kerei
[EMAIL PROTECTED]
""Beau Newcomb"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I've tried everything the faqs say and I'm still unable to get mysql
> support
> in PHP5..
>
>
>
> I've added H:
Well I ended up with a slightly different way to do it but it seems to work
for me.
Don't know if anyone else will find it useful but here is the code.
//Use windows netstat to check for port 3306 (MySQL)
//If it is not in the list then run MySQL
exec ('netstat -a -n', $reply, $error);
$reply = im
Hi
http://forums.mysql.com/read.php?11,6400,6701#msg-6701
MySQL 5.0.0
PHP 4.3.10
Regards
BrAiNs
http://ctek.ath.cx
"Karsten Scherer" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi there!
i am getting mad while trying to get this stuff running.
on my system are:
Apache 2.0.52
P
Make sure you copied the libmysql.dll from your php folder to your system
folder as well
"Patrick Roane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I am trying to est. a connection to mysql via PHP5 on
> my win XP and I keep getting the undefined function
> error. By the way I
Patrick Roane escribiÃ:
I am trying to rename my table, but I get a syntax
error.
ALTER TABLE myblobs RENAME myBlobs;
Can anyone tell me where the problem is here? I went
to the mysql ref. site and I think this is the right
way to do this.
thanks-
=
Patrick Roane
Web design and development
ww
hi,
Mysql 4.1.8 now support another authentication protocol and you need to
upgrade to php 5 and activate mysqli extension (not mysql) and use
mysqli_connect and change all mysql_* function to mysqli_*
another way to fix the problem is to allow previous protocol but I
forgot the way how to do th
Hello Mikea.
You have to know that i am new to php, too. And i am also struggling to
understand the code. Well, i would suggest you take something
less complex to start up. But if you still want that code for the
beginning.. make sure the database xy (that part is missing in the
code) has a table a
This is an applic that I got off the internet that I am trying to install.
An example of the code follows.
if ($action=="memberlist") {
/* get the total number data and find out what the grand total is */
$sql = "select id, title, price from ad_details where member_id=" .
$_SESSION['login_id'];
, October 21, 2004 7:49 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Re: MySQL Errors
hello mikea,
looks like there is something missing in your sourcecode, which you
should have provided. do you give any arguments to
mysql_fetch_array() ? Do you check if it is not false?
your code should look like this
hello mikea,
looks like there is something missing in your sourcecode, which you
should have provided. do you give any arguments to
mysql_fetch_array() ? Do you check if it is not false?
your code should look like this:
$sql = "SELECT * FROM example";
$result = mysql_query($sql,$db);
if ($result) {
"Susilo" <[EMAIL PROTECTED]> a écrit dans le message de
news:[EMAIL PROTECTED]
> Does Everybody now what is SQL Expression to get part of the string in
> DATE VARIABLE ?
>
> e.g : 11/12/2004
>
> and become to only string '2004' in Table Viewing.
http://dev.mysql.com/doc/mysql/en/Date_and_time_fu
Forgot to add, I have php5 in c:\php5 and php4 installed in c:\php4,
could that cause problems? I configure IIS properly, but could other
installation cause problems?
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> Are you trying to use dl() to load the library? It's probably easiest to
just
> uncomment the line in php.ini for mysql.
No. I just have in php.ini a line with "extension=php_mysql.dll"
> Strange... I would have thought you needed libmysql in php\ext, but I
checked
> out my configuration (pr
Ciprian Constantinescu wrote:
Where can I download a working "libmysql.dll" to use on WindowsXP? I
have a version that doesn't work. All I get is "Unable to load dynamic
library 'C:\php\ext\php_mysql.dll' - The specified procedure could not be
found".
Are you trying to use dl() to load the libr
Tony Devlin wrote:
How can I setup a query to select from a database ONLY the last 5 inserted
rows. OR atleast the last 5 starting from this date back, but only select
the last 5 in order.
If anyone has any suggestions I'd appreciate them.
Thanks,
Tony
I would set up a timestamp column in
Did you try from the root? Is the driver in services? Check and seeif
you can't start if from services... Go to /mysql/bin and uninstall the
driver then reinstall it. http://www.mysql.com/doc/en/Installing.html
Shadow
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: h
You can install a firewall and block all requests on the mysql port (default
is 3306) and, in mysql.. you can set the users to be only from
localhost...
"Rahman Haqparast" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi.
> I wanted to know if there is a way to limit access to
of course this is a php newsgroup :)
try DAYOFMONTH
DAY is only available in mysql 4.1.1
"Disko_kex" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi
SELECT RegDate FROM table WHERE month(RegDate) = '10' // this is
working
SELECT RegDate FROM table WHERE day(RegDate) = '2' // w
Try to make a many-to-many design :
Create a table 'images_img' with id_img, name_img, accession_img ... for the
images
Create a table 'categories_ctg' for the categories with id_ctg, name_ctg,
description_ctg ...
Create a table for unifing this two imgtoctg_itc with id_itc, idimg_itc,
idctg_itc
I
I asked this question in a forum last week and finally got a helpful
answer. I'm new to databases and I knew how to upload an html file
through a typical ftp client but I couldn't get my head around the
concept of uploading a MySQL database. I'm using phpMyAdmin to manage
MySQL.
BTW, TFM was no he
i think u shld refer this to mysql mailing list ([EMAIL PROTECTED] /
[EMAIL PROTECTED]) .
-Original Message-
From: Rui [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 02:02
To: [EMAIL PROTECTED]
Subject: MySQL: some script I must do
First of all, I must thank all the people w
mysqlgui-win32-static-1.7.5-2 - This is GUI for MySQL administrationCS
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
You could do it through regedit.
If you have to logon to the network, go to HKEY_CURRENT_USER > Software >
Microsoft > Windows > Current Version then check in Run and RunOnce to see
if MySQL is there. If it is delete that entry (make sure you know you're
deleting the right one though!)
Now do this
is mysql running on port 10106? I run mine on the default port but I don't
think it was that one!
Have a look in the configuration files.
"Marco Lanini" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
> i have a little big problem with my configuration.
>
"Sviss Cobazor" <[EMAIL PROTECTED]> wrote:
> Hi NG.
>
> Now I've read page up and page down in the MySQL online manual about how
to
> use the auto_increment. But I didn't find anywhere how to reuse a deleted
id
> created by auto_increment.
>
> Say I have a table [users] with 4 columns:
>
> | ID |
"Sviss Cobazor" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Now I want to delete user with ID = 2.
> Now I create a new user, he will get ID = 4.
>
> How can i reuse the ID 2 for creation of new users?
I am not familiar with MySQL specifically but in my
> Hey there!
>
> you must delete the my.ini or something like that and then it works!
eh? my.ini holds your special mysql configuration and you shouldnt just
go and delete it, and for certain it wont magically start mysql if you
delete
the file
/Martin
>
>
> "Brad Thomas" <[EMAIL PROTECTED]>
Hey there!
you must delete the my.ini or something like that and then it works!
"Brad Thomas" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > Warning: MySQL Connection Failed: Can't connect to MySQL server on
> > > 'localhost' (10061) in c:\program
> > Warning: MySQL Connection Failed: Can't connect to MySQL server on
> > 'localhost' (10061) in c:\program files\apache
> > group\apache\htdocs\db_connect.php on line 3
This error means the MySQL server isn't running.
Try starting the server and try again.
--
PHP Windows Mailing List (htt
"blind leading another blind" ;-)
Hi, i am a not-a-total-newbie myself - so here comes nothing...
See if you get the same result (errors) when you use the local computer's
real IP address or the localhost IP "127.0.0.1" instead of "localhost" in
your mysql_connect().
Don't ask me if this solve it
"G Schneider" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> What do you do if the only root user has removed all his own privileges?
>
> How do you rectify the situation without reinstalling MySQL?
>
> Thanks,
> - Jefferrs
MySQL keeps its own privileges data
This was fixed. I needed to use the update statement instead of insert.
Jordan
"Jordan Arendt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> I'm struggling with some php code. I'm trying to insert some info into a
> mysql DB. I beleive I'm failin
http://www.anse.de/mysqlfront/
one of the best!
"George Pitcher" <[EMAIL PROTECTED]> wrote in message
006d01c10eac$dc4b2300$[EMAIL PROTECTED]">news:006d01c10eac$dc4b2300$[EMAIL PROTECTED]...
> Hi all,
>
> My first posting to php-anything.
>
> I have php, apache and mySQL set up on my NT box. Do
Also the excellent book by Paul DuBois: MySQL
Alain
On Sat, Feb 10, 2001 at 10:26:14AM -0800, Paul Trapnell wrote:
> MYSQL TUTORIALS
>
> http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html
> (by Graeme Merrall)
>
> http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/
MYSQL TUTORIALS
http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html
(by Graeme Merrall)
http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/
(by Israel Denis & Eugene Otto tutorial)
http://www.webmasterbase.com/article.php?aid=228&pid=0
(by Kevin Yank)
http://www.
43 matches
Mail list logo
