PHP-MySQL: POST issue

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UPDATE COmmand post comparing 2 columns in 2 mysql tables

my queryis : select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1; But how should I update them? i used update statetment : Update from client Set item =1 where m.name=p.name and item_count=1 AND item>1 Is this wrong?

2. Emergency UNIX and Linux Support

Migration of website... PHP/Mysql -which path for DB.php

Hi, I have two websites: website1.com and website2.com I didn't write either but have successfully moved all the files from website1.com to website2.com I (thought) I installed all the correct php modules and website2 is mostly up and running. However, my boss found that when we go to a...

3. Shell Programming and Scripting

syntax issue mysql in bash script

I'm running mysql in a bash script mysql <<EOF query EOF one query is like this: UPDATE $dbname.$prefix"config" SET value = $var WHERE "$prefix"config.name = 'table colname'; with variable but it's giving an error i'm not sure what to put for "$prefix"config.name the table...

4. Programming

LEFT JOIN issue in Mysql

I have a data table as follows: mysql> select * from validations where source = "a03"; +------------+-------+--------+ | date | price | source | +------------+-------+--------+ | 2001-01-03 | 80 | a03 | | 2001-01-04 | 82 | a03 | | 2001-01-05 | 84 | a03 | | 2001-01-06...

5. Linux

mysql server start issue

Hi, I have installed mysql in linux box as mysql-5.0.77-4.el5_6.6.. I would like to start the server. But there is no mysql file in this location /etc/init.d/ Please advice how to start the server now !! Thnaks, Mani

6. Web Development

Strange Mysql issue

Hi all, I recently changed the name of my hostname from 'abc123' to 'abc456' (as an example). I then added a user in my mysql database with the new host and removed references to the old users and hostname. The strange thing is though, a process using the database still uses the old...

7. Programming

derefencing issue with perl and mysql

I've tried every type of dereferencing I can think of but I still can't get to array data. #!/usr/bin/perl use DBI; use DBD::mysql; use DBI qw(:sql_types); $hostname = "localhost"; $database = "c2"; $username = "user"; $password = "password"; $dbh =...

8. UNIX and Linux Applications

mysql query browser issue

Hi, I'm new to mysql, I've installed MYSQL on our unix server and started MYSQL on this server. I've now downloaded MYSQL Query Browser, when I try to connect to MYSQL server, I get the following error "could not connect to the specified instance" - MySQL Error Number 1130. From the...

9. UNIX for Dummies Questions & Answers

mysql issue

I have a lot of files getting this on a new install of phpmysql 4.3.4 any ideas what would be causing this... Fatal error: Call to undefined function: mysql_connect() in /home/httpd/vhosts/ucandevelopments.com/httpdocs/includes/functions/database.php on line 19

LEARN ABOUT PHP

mysql_create_db

MYSQL_CREATE_DB(3)							 1							MYSQL_CREATE_DB(3)

mysql_create_db - Create a MySQL database

SYNOPSIS

       Warning

	      This  function  was deprecated in PHP 4.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
	      sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide  and  related  FAQ  for  more
	      information. Alternatives to this function include:

		     omysqli_query(3)

		     o PDO::query

       bool mysql_create_db (string  $database_name, [resource	$link_identifier = NULL])

DESCRIPTION

       mysql_create_db(3) attempts to create a new database on the server associated with the specified link identifier.

	      o $database_name
		- The name of the database being created.

	      o $
		link_identifier  -The  MySQL  connection.  If  the  link  identifier is not specified, the last link opened by mysql_connect(3) is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	Returns TRUE on success or FALSE on failure.

       Example #1

	      mysql_create_db(3) alternative example

	       The  function  mysql_create_db(3)  is  deprecated. It is preferable to use mysql_query(3) to issue an sql CREATE DATABASE statement
	      instead.

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }

	      $sql = 'CREATE DATABASE my_db';
	      if (mysql_query($sql, $link)) {
		  echo "Database my_db created successfully
";
	      } else {
		  echo 'Error creating database: ' . mysql_error() . "
";
	      }
	      ?>

	      The above example will output something similar to:

	      Database my_db created successfully

       Note

	       For backward compatibility, the following deprecated alias may be used: mysql_createdb(3)

       Note

	       This function will not be available if the MySQL extension was built against a MySQL 4.x client library.

       mysql_query(3), mysql_select_db(3).

PHP Documentation Group 													MYSQL_CREATE_DB(3)

UNIX for Dummies Questions & Answers