Hello everyone.
I am new to MySQL and am trying to setup a shopping cart using MySQL and
PHP.
They are files that I found online for free from Rosenet Internet
Services.
The problem is that when I try to add a category for a product I get this
in
return:
Warning: mysql is deprecated;
It means something is out of date...looks like you need an update of
something...
This is the line 7 that it is talking about How do I know what is out of
date and how to fix it? Are there any utilities out there for updating
scripts or do I need to manually go into each .php file and
This is not a Mysql issue but an PHP one. The function you are using
(mysql_db_query ?) is deprecated and should therefore not be used. Try
modifying your PHP script to use
mysql_select_db(test);
mysql_query(select * from tablename);
.. instead of
mysql_db_query(test,select * from tablename)
Hi,
Warning: mysql is deprecated; use mysql_select_db() and mysql_query()
instead in (rootPath here)\cart\admin\addcategoryresponse.php
on line 7
[snip]
What does depricated mean? I have searched the manual and the
resources
online but cannot find anything about it. Does it mean that
It means something is out of date...looks like you need an update of
something...
This is the line 7 that it is talking about How do I know
what is out of
date and how to fix it? Are there any utilities out there for updating
scripts or do I need to manually go into each .php file
.. if mysql_db_query is what you're using.
Actually below is waht I am using...
mysql($DBName,INSERT INTO Category VALUES('$Category',''));
After your response, I changed it to...
mysql_select_db($DBName);
mysql_query(INSERT INTO Category VALUES('$Category',''));
Works like a charm...
I
I just started going into some of the other files that will need updating
and I have run into another little prob dealing with the same thing
Here it is, maybe you can shed some light on it for me.
$result=mysql_db_query($DBName,SELECT Date,BuyerID,OrderNumber FROM
Buyers);
The $Result
mysql_select_db($DBName);
mysql_query(SELECT Date,BuyerID,OrderNumber FROM Buyers)
How do I assign the variable to both of those lines that make
up the DB
call???
Unless you're planning to use several databases, you only have to use
mysql_select_db($DBName); once, normally where you