Date: 03/12/07 (WebDesign)    Keywords: php, database

does anybody know of a good 'letter to the editor' script or have any ideas?

i'm helping a political advocacy group who'd like to help people email local newspapers and/or congress people with letters, etc

i found local ink:
https://sourceforge.net/projects/localink/

and i have everything set up but i have no idea how to add newspaper/zip code information into the database correctly. i tried with phpMyAdmin adding it in manually and that didn't work either.

any ideas? would appreciate any help in the right direction with somebody who's done something like this before, either with local ink or something else.

thanks so much!

Source: http://community.livejournal.com/webdesign/1231367.html

Date: 03/12/07 (PHP Community)    Keywords: php, database

does anybody know of a good 'letter to the editor' script or have any ideas?

i'm helping a political advocacy group who'd like to help people email local newspapers and/or congress people with letters, etc

i found local ink:
https://sourceforge.net/projects/localink/

and i have everything set up but i have no idea how to add newspaper/zip code information into the database correctly. i tried with phpMyAdmin adding it in manually and that didn't work either.

any ideas? would appreciate any help in the right direction with somebody who's done something like this before, either with local ink or something else.

thanks so much!

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

Date: 03/17/07 (PHP Community)    Keywords: php, mysql, browser, database, sql

I can't seem to figure out this problem for the life of me.

The error is this: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /opt/lampp/htdocs/_projects/medievalbattles/current/v8_r3/httpdocs/access.php on line 139

LIne 139 is: $servername = $row["alt_name"];

Even if I comment out this entire portion of code, the error still exits (even after cleaning my entire browser cache and restarting my computer five times). I've tried cleaning my Smarty template cache, but that didn't help.

	// was inevitable to requery this. maybe use memcached?
	$count = 1;
	$sql = "SELECT alt_name, databasename FROM ".$_MB->db_name.".servers";
	$res = mysql_query($sql, $_MB->connection) or die(mysql_error());
	while ($row = mysql_fetch_assoc($res))
	{
		$server_name = $row["alt_name"];
		$server_database = $row["databasename"];

		$sql2 = "SELECT serverstart, tickstart, serverend, round FROM ".$server_database.".game_info";
		$res2 = mysql_query($sql2, $_MB->connection) or die(mysql_error());
		$row2 = mysql_fetch_assoc($res2);
			$time_data[$server_name]["serverstart"] = $row2["serverstart"];
			$time_data[$server_name]["tickstart"] = $row2["tickstart"];
			$time_data[$server_name]["serverend"] = $row2["serverend"];
			$time_data[$server_name]["round"] = $row2["round"];

		$count++;
	}

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

Date: 03/18/07 (PHP Community)    Keywords: mysql, database, sql

I have the following piece of code:

$sql = "SELECT id, alt_name, databasename, gametype FROM ".$_MB->db_name.".servers";
$res = mysql_query($sql, $_MB->connection) or die(mysql_error());
$row = mysql_fetch_assoc($res);
$_SMARTY->assign("server_list", $row);

It is supposed to return whatever rows are in the servers table, but for some reason it only returns the first. I've executed the SQL statement via MySQL directly and it acts as it should. Any ideas why it's acting wonky?

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

Date: 03/18/07 (PHP Community)    Keywords: mysql, browser, database, sql

this might be way too much info, but please bear with me! the end result is, i need to do a query that joins tables that exist in different databases on different servers. how do i do that?

anyway, i'm building a site for a real estate guy who's hosted through 1and1. they only allow you to have 100mb of data per database. he's given me ~500mb of property data and ~100mb of property tax data. i split up the property data and kind of spanned it across five db's, then put the tax data in a sixth. each database you create with 1and1 gets dropped on a random server. i'm able to search property data by checking db1, then db2, and so on... and appending the results. i connect to them all like so

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

Date: 03/19/07 (PHP Community)    Keywords: php, mysql, database, sql, hosting

regarding my previous problem, i called 1and1 and they said there's no way to get my databases on the same server. whatever process creates your databases through their control panel actually goes out of its way to distribute them on different servers. the only way around this - to exceed the 100mb limit or have multiple db's on the same server - is to rent your own server on a dedicated hosting plan for a minimum of $99/month. no thanks!

so i'm going to switch hosts. i need a host that doesn't limit database sizes beyond overall storage limits, and allows ssh access even with their cheap accounts. cron jobs would be nice but aren't necessary. php5 and mysql and a few gb's of storage.

i don't want to use dreamhost because i've heard too many bad things.

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

Date: 03/19/07 (C Sharp)    Keywords: database, sql

Hello!
I've got a problem. I was sent to another part of my plant and there is no networking between some offices. So I had to make my database local and keep it in MS Access. But as I used to create applications in c# ( using SQL Server 2000) you can imagine what i feel...
I faced the problem of multisearching  ( search by different parameters up to 25 and we don't know exact quantity of them). I didn't have such problems yet ( cause i got stored procedures on my server) and i didn't care for the quantity of parameters (fields for search). But now... How to organize multisearching  if  my database is storing in Access?

In short, could you help me with any information..As I feel

Thanks beforehand

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

Date: 03/24/07 (PHP Community)    Keywords: database

I've been testing out image uploading and resizing on the fly tonight..
While I have the page able to pull the image name from the database. It seems like the script I've found can't display the picture, as a variable, the 'imagejpeg' shows the image fine but how do I end the script so that I can have the sized image name in a variable.




        $gvsql = "SELECT * FROM image_gallery WHERE gid = \"$gid\" 
                             ";
        $gvresult = @mysql_query($gvsql,$conn) or die("Couldn't execute query.");
 
        while ($gvrow = mysql_fetch_array($gvresult)) {
         
                         $img = $gvrow['image_name_resize'];
                                 
                                        }
                                       
        $filename = '/home/benjamin/www/dev/upload/';

        $width = 300;
        $height = 300;

        header('Content-type: image/jpeg');

          $filefile="$filename$img";
        list($width_orig, $height_orig) = getimagesize($filefile);

        $ratio_orig = $width_orig/$height_orig;

        if ($width/$height > $ratio_orig) {
           $width = $height*$ratio_orig;
        } else {
           $height = $width/$ratio_orig;
        }
        $image_p = imagecreatetruecolor($width, $height);
        $image = imagecreatefromjpeg($filefile);
        imagecopyresampled($image_p, $image, 0, 0, 0, 0, $width, $height, $width_orig, $height_orig);
        imagejpeg($image_p, null, 100);
        imagedestroy($image_p);
?>

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

Date: 03/27/07 (Security)    Keywords: database

Senators are told FBI's misleading reports on surveillance are due in part to transferring information between databases--by retyping it manually.

Source: http://news.zdnet.com/2100-1009_22-6170995.html

Date: 04/04/07 (Web Development)    Keywords: database

First off I'll post a screenshot of the database relationships:




In short, Category contains subCategories which contains Products.

What I want to do is create a query that will list the CategoryName along with the total number of Products associated with that Category (through the SubCategory). I'm not sure how to do this. When I just add the Product table to the query in design view I get a join error. Can anyone point me in the right direction?

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

Date: 04/05/07 (Web Development)    Keywords: php, mysql, database, sql

here is the site

So basically I am designing a database which lists a client_name, client_description, and then a list of images associated with that particular client. This is all stored in a MySQL database. I am not sure how to handle the images though. Each client will have around 6 images. I currently have it set up where every client has its own folder of images and the PHP just reads every image from that folder and displays it.

Would it be a better idea in terms of best practices to instead have an Images Table that keeps track of every image and what client it is associated with?

Not sure, Mike

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

Date: 04/11/07 (PHP Community)    Keywords: php, database

I had a big long report that I printed to the screen. It was a foreach loop that went through an associative array of database results and put them in a table. It looked crappy at first. This is what I had at the beginning:

foreach($foo as $a => $b)
{
    print '