Date: 03/31/06 (PHP Community)    Keywords: sql

One would think this is a simple routine. In fact, I used the idential type of routine (while(list() = each()) to assign the very same associative array I'm calling in this method. For the life of me, I cannot figure out why I'm not even getting in the while loop... This is simple, so why am I getting this output? (see below code)....

//get_sql_insert_string() generates an insert string for the fields ONLY.. tables and criteria still need to be assigned
	function get_sql_insert_string() {
		$field_str = "";
		$value_str = "";
		echo "testing associateive array with value... " . $this->fields['hex_id'];
		while (list($key, $value) = each($this->fields)) {
		echo "why am I not getting in this loop????";
			if (!in_array($key, $this->get_sql_exclude_fields())) {
				$field_str .= "'" . $key . ", ";
				$value_str .= "'" . $value . ", ";
			}
		}
		return " (" . substr_replace($field_str, '', -2) . ") VALUES (" . substr_replace($value_str, '', -2) . ") ";	
	}

Source: http://community.livejournal.com/php/432866.html

Date: 04/02/06 (Apache)    Keywords: php, mysql, sql, apache

I'm new to this community and to Apache. I'm basically trying to install Apache in conjunction with PHP and MySQL, using an online manual about the topic. When it comes to the part about Apache, it only tells me to install Apache according to the instructions on the site, but I couldn't find any installation instructions on the site or in the files I downloaded from the Apache's main site. I found a file titled INSTALL, but it doesn't have an extension and my OS (Windows XP) does not recognize it. I'd appreciate all your suggestions, comments and help as to what I need to do.

Source: http://community.livejournal.com/apache/31570.html

Date: 04/03/06 (PHP Community)    Keywords: php, mysql, database, asp, sql, linux, hosting

I want to ask you guys out there for some suggegtions/advice on hosting companies. I have very specific needs:

I need a host that:
1) Is reliable and has good, quick customer service
2) Supports PhP on a windows server - I need to run ASP and PhP
3) Provides at least one SQL Server not mySQL) Database if not more
4) Lets me run my own mail server (not sure if this is done through hosting or domain registration)
5) Preferably lets me add sub-domains for little to no extra cash

Right now I have Enterhost and they are awful (don't support PHP, charge out the ass, their logs don't work, you can't have sub-domains or dedicated IP's and every time I ask them for something they say no). I'm looking at maybe HostExcellence? I need something with practically no downtime, as it is for a money-making site.

On the same subject, is it possible to move files over to the new host and access it through only the IP address before switching my domain name servers? I want to get everything moved and tested on the new server and make sure all the DB calls work before it goes live. Not sure if I could do that without hostin a second, 'testing only' domain temporarily, as I've never done a large-scale transfer like this.

Any advice (besides 'Just switch to a Linux server') is helpful.

Source: http://community.livejournal.com/php/433400.html

Date: 04/03/06 (MySQL Communtiy)    Keywords: php, mysql, html, sql

One of my projects has recently started listing results multiple times. The persons in charge of the servers say they have not updated the MySQL server or made any changes. In some cases I can accommodate for this by adding DISTINCT to the query. But on other pages, this is not helping.

From an email I just sent to my super':
"There is something up with our SQL server. I just looked at the View Profile page which I know I haven't touched in months and its also showing the profile page twice. In the PHP and HTML, the content is only there once and is called only for the results of the query. For some reason the query is suddenly calling two results of one row."

I am clueless about it. For over a year these things were working fine and only sending one result. Suddenly its sending two or more results for the same row.

If you guys have any idea why the server behavior and query results would change, or an hints at MySQL idiosyncracies, let me know. Thanks.

MySQL 4.1.11-Debian_4sarge2-log. PHP call used in the View Profile: $Result = mysql_db_query($host, $user, $password);

Source: http://community.livejournal.com/mysql/91645.html

Date: 04/03/06 (Web Development)    Keywords: php, mysql, database, asp, sql, linux, hosting

OK, so I know this is a weekly occurance here, but I want to ask for some suggegtions/advice on hosting companies. I have very specific needs:

I need a host that:
1) Is reliable and has good, quick customer service
2) Supports PhP on a windows server - I need to run ASP and PhP
3) Provides at least one SQL Server not mySQL) Database if not more
4) Lets me run my own mail server (not sure if this is done through hosting or domain registration)
5) Preferably lets me add sub-domains for little to no extra cash

Right now I have Enterhost and they are awful (don't support PHP, charge out the ass, their logs don't work, you can't have sub-domains or dedicated IP's and every time I ask them for something they say no). I'm looking at maybe HostExcellence? I need something with practically no downtime, as it is for a money-making site.

On the same subject, is it possible to move files over to the new host and access it through only the IP address before switching my domain name servers? I want to get everything moved and tested on the new server and make sure all the DB calls work before it goes live. Not sure if I could do that without hostin a second, 'testing only' domain temporarily, as I've never done a large-scale transfer like this.

Any advice (besides 'Just switch to a Linux server') is helpful.

Source: http://community.livejournal.com/webdev/311542.html

Date: 04/05/06 (PHP Community)    Keywords: php, xml, database, asp, sql, java

Hi guys,
I was just fooling around with AJAX for the first time and it's working fine so far, but of course some problems are around.

My question is, is there some possibility to insert PHP code in Javascript?
I have my JavaScript file, and now I need to tell it somehow which ID to select from the database.

function showFan(str) {
var url="getFans.php?id=" + Math.random() + "&q=" + str
xmlHttp=GetXmlHttpObject(stateChanged)
xmlHttp.open("GET", url , true)
xmlHttp.send(null)
}

The second line is the one that bothers me. There should be the SQL table variable after the id=, like this; getFans.php?id=$country. The +Math.random() stuff is from the tutorial, no idea what it does, and the rest of the line is also from the tutorial, they used ASP there but I have no clue about asp. So can anyone help me out with and and tell me what PHP code I need to have in my getFans.php in order to make this work? My getFans.php is just a file with the usual database connections and printing stuff, nothing else.

Thanks is advance :)

Source: http://community.livejournal.com/php/434515.html

Date: 04/05/06 (MySQL Communtiy)    Keywords: mysql, database, sql, postgresql

Hello all.
Sorry if this question is offtop question.
I have dump of PostgreSQL database and now I want to use it with MySQL.
Can You help me with converting it?
Does anyone now how to do it? Or I should do it by hand?
Thanks.

Source: http://community.livejournal.com/mysql/92257.html

Date: 04/06/06 (C Sharp)    Keywords: software, asp, sql, microsoft, google

Hi,

I'm kind of new here and wasn't sure of where to post this since it pertains to Microsoft Visual Studio .NET 2003 itself and neither C# not ASP.Net

The project I'm working on requires me to work a lot on.pc and .pkg files (ProC and PL/SQL packages)

Now Microsoft Visual Studio .NET 2003 recognizes neither and I spent a long time on google trying to find out how to make it treat these files like C and SQL files respectively - basically do the necessary colorization - but with no result.

I finally found the solution after looking around in my machine's registry.

-

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1\Languages\File Extensions\

That's where you need to add an extra key in the registry if you need your VS to recognize new file types.

Use the value from the existing file type whose formatting you want the new file type to have.

-

Works beautifully!

Just thought I'd post it here in case anyone else finds it useful. Posted to both aspdotnet and csharp. Do let me know if this is against community rules and I'll take it off.

Source: http://community.livejournal.com/csharp/56217.html

Date: 04/06/06 (Asp Dot Net)    Keywords: software, asp, sql, microsoft, google

Hi,

I'm kind of new here and wasn't sure of where to post this since it pertains to Microsoft Visual Studio .NET 2003 itself and neither C# not ASP.Net

The project I'm working on requires me to work a lot on.pc and .pkg files (ProC and PL/SQL packages)

Now Microsoft Visual Studio .NET 2003 recognizes neither and I spent a long time on google trying to find out how to make it treat these files like C and SQL files respectively - basically do the necessary colorization - but with no result.

I finally found the solution after looking around in my machine's registry.

-

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1\Languages\File Extensions\

That's where you need to add an extra key in the registry if you need your VS to recognize new file types.

Use the value from the existing file type whose formatting you want the new file type to have.

-

Works beautifully!

Just thought I'd post it here in case anyone else finds it useful. Posted to both aspdotnet and csharp. Do let me know if this is against community rules and I'll take it off.

Source: http://community.livejournal.com/aspdotnet/60864.html

Date: 04/06/06 (Asp Dot Net)    Keywords: database, sql

We're transitioning from one content manager to another adn I've been assigned to figure out how the database in teh old CM worked. Looking through I see that it has binary data stored in the database. Thing is though I don't know how to actually extract the binary data and view it. I was looking online for information and it seems very complex and/or convoluted. Does anyone know of any good tutorials or methods of doing this? Its SQL Server 2000 SP3.

Of course if they just gave me access to the source code my life would be 10X easier, but apparently they want me to make this into a "learning experience."

Any help is greatly appreciated.

Source: http://community.livejournal.com/aspdotnet/60435.html

Date: 04/06/06 (PHP Community)    Keywords: database, sql

I'm having a weird problem with PDO on Fedora Core 5. I'm trying to connect to a sqlite database using PDO and it's just bombing out. I have a sqlite2 database, but apparently FC5 only supports sqlite3 databases (via PDO). So the following code just stops working. No error, no output, just fails silently.

$dbh = new PDO("sqlite:$db_path");

Now granted it SHOULDN'T work because it's a sqlite2 database and the sqlite: command is for sqlite3 databases, shouldn't it give me an error about that? Alternately is there a way to tell what version a sqlite database is that's on the disk? Like if it's a sqlite2 database use this command instead:

$dbh = new PDO("sqlite2:$db_path");

That way my code can be intelligent enough to know what type of DB it is?

Source: http://community.livejournal.com/php/435381.html

Date: 04/07/06 (MySQL Communtiy)    Keywords: mysql, database, sql

Jay Pipes (co-author of Pro MySQL) is in town and will speak about "MySQL Performance Tuning Best Practices". This is the workshop he'll be giving at the MySQL Users Conference, so if you can't go don't miss this meetup! There will be FREE pizza and soda.

We will have giveaways of Pro Mysql and gift certificates for free Apress books, and other swag like T-shirts, buttons, etc. RSVP for a headcount of soda and pizza at http://mysql.meetup.com/137/events/4875276/ (you will have to register; sorry.... :( )

Description of the workshop: Learn where to best focus your attention when tuning the performance of your applications and database servers, and how to effectively find the "low hanging fruit" on the tree of bottlenecks. It's not rocket science, but with a bit of acquired skill and experience, and of course good habits, you too can do this magic! Jay Pipes is MySQL's Community Relations Manager for North America.

We will be meeting on MIT campus, close to the Kendall stop on the Red Line (subway). There is also plenty of free parking -- you can park in ANY MIT lot after 3 pm, even if it says "parking by permit only". We are in building E51, room 372.

If you join the meetup, you'll get these messages automatically and great things like 30% discounts on O'reilly books, discounts to conferences, etc. It's OK to repost/forward this message.

Here is the URL for the MIT Map with the location of this building:
http://whereis.mit.edu/map-jpg ?selection=E51&Buildings=g o

This map shows the MBTA Kendall Stop:
http://whereis.mit.edu/map-jpg ?selection=L5&Landmarks=go
(the stop is in red on that map, and you can see E51 in the bottom right)

Here are the URL's for the parking lots:
http://whereis.mit.edu/map-jpg ?selection=P4&Parking=go
http://whereis.mit.edu/map-jpg ?selection=P5&Parking=go

Pizza and soda will be served, so please RSVP accurately.

When:
Monday, April 10, 2006, 7:00 PM 2006-04-10 07:00:00
Where:
MIT Building E51, Room 372
Wadsworth and Amherst Streets
Cambridge , MA 02117

Source: http://community.livejournal.com/mysql/92621.html

Date: 04/11/06 (PHP Community)    Keywords: php, mysql, database, sql

I'm trying to parse PHP code that is echoed from a MySQL database. Right now, it just prints the php code onto the page--how exactly would I parse this code to actually run? For example, my function would be:

function image($imagename,$imagealign,$imagecaption)
{ echo "
$imagecaption"; }

And I want it to parse this out everytime I'd call the code, using (Keeping in mind that this is stored as text in a MySQL database--which plainly prints the italicized code rather than parses it)

Also, how do I get the filename of my current file? Say I'm at http://blahblahblah.com/blah/info.php and I want just "info.php" rather than "blah/info.php"--what code snippet would I use?

Thanks!

Source: http://community.livejournal.com/php/437965.html

Date: 04/12/06 (Apache)    Keywords: mysql, database, sql, google

Hi,

I have a problem connecting to a MySQL database through a perl script (using Per DBI drvier) running on Tomcat (tried XP and server 2000). The error that I get is: "Got an error: Bad ObjectDriver config: Connection error: Can't create TCP/IP socket (10106)" Everything works fine when I run the script from command prompt (bypassing Tomcat).  

I've Googled and googled all day and what I found was that a lot of people have this problem, but there don't seem to be any answers.  I'm wondering if anyone ever came across a similar problem and how they've solved it.  

Your help is very much appreciated!

Source: http://community.livejournal.com/apache/31793.html

Date: 04/12/06 (C Sharp)    Keywords: sql

There has to be a better way to do this...

private void btnMarket_Click(object sender, EventArgs e)
        {
            DataView dvRates = new DataView(dsHospRates.RateData);
            dvRates.RowFilter = "RateTypeID = 1 AND ProvID = " + cboName.SelectedValue.ToString();
            dgRates.DataSource = dvRates;
        }

        private void btnContract_Click(object sender, EventArgs e)
        {
            DataView dvRates = new DataView(dsHospRates.RateData);
            dvRates.RowFilter = "RateTypeID = 2 AND ProvID = " + cboName.SelectedValue.ToString();
            dgRates.DataSource = dvRates;
        }

        private void btnMarket2_Click(object sender, EventArgs e)
        {
            DataView dvRates = new DataView(dsHospRates.RateData);
            dvRates.RowFilter = "RateTypeID = 3 AND ProvID = " + cboName.SelectedValue.ToString();
            dgRates.DataSource = dvRates;
        }

Source: http://community.livejournal.com/csharp/57129.html

Date: 04/13/06 (Web Development)    Keywords: php, mysql, sql, web

Can anyone recommend a good web site for looking up MySql syntax and keywords? I am looking for something really straightforward like the php.net function search page. I thought there would be something like that at mysql.com but I cannot seem to find it.

Source: http://community.livejournal.com/webdev/313771.html

Date: 04/15/06 (Open Source)    Keywords: mysql, sql, web

Web 2.0 projects built on mySQL can also move ahead with confidence they’re ready as they move into transactions and as users "rush to the rail" to support them.

Source: http://blogs.zdnet.com/open-source/?p=620

Date: 04/17/06 (PHP Community)    Keywords: php, mysql, sql, hosting, apache

Hello,
I have just recently contracted a Virtual Private Server account with a large hosting company. So far everything has gone pretty smoothly. I installed mysql and PHP and everything is running as it should. However when I installed PHP there was an option screen for me to choose what I wanted to install PHP with. I remember specifically choosing mysql support. However now when I try to run some of my pages I get this error:
Call to undefined function: mysql_connect() in /usr/local/apache/htdocs/config.php on line 52

Which tells me that the mysql functions were not installed.

So to my question. How do I confirm that its not installed? If its not installed how do I install it?

Thanks.

Source: http://community.livejournal.com/php/439484.html

Date: 04/17/06 (Application Development)    Keywords: mysql, technology, database, sql

High-end database company Solid Information Technology will make open-source transaction engine for MySQL.

Source: http://news.zdnet.com/2100-9593_22-6061443.html

Date: 04/19/06 (PHP Community)    Keywords: php, mysql, database, sql

So I looked at PHP documentation and a bit at SQL documentation but couldn't find anything.

Is there a function to select the name of the primary key row in a table (MySQL database)?

Thanks
--Shamess

Source: http://community.livejournal.com/php/441320.html