Date: 12/07/08 (MySQL Communtiy)    Keywords: html, sql, google

Heyo. I'm putting together a user search function and I would like to include a Facebook-style name recognition system that understands name synonyms. A search for Will would also return Bill and William, for example. To some extent I could see a Soundex search kinda accomplishing this, but I'm wondering if anyone has any really good ideas as to how to implement this. At the moment I'm trying to find a sql dump of name synonyms which I would use for cross-references.

Anyone done this before and have some words of wisdom?

*update*

I've found this: http://answers.google.com/answers/threadview/id/778986.html

... which is definitely helpful.

I created a SQL file and posted about it here: http://danconnor.com/wordpress/?p=138

I'm still open to suggestions though!

Source: https://mysql.livejournal.com/132846.html

Date: 01/30/17 (HTML Help)    Keywords: mysql, sql

Things have been progressing recently. Been able to push my spirit to move forward and troubleshoot some errors involving form input of data to mysqli and now it's a bit progressing. I'm really looking forward to finish my project. Hopefully next month i would be able to finish it all and maybe publish it for beta. I think I need a definite "MUSTS" lists of task so i would know and scratch it off if it's done and do what needs to be done next. Will do that later, I think.
Meanwhile, I also saw a posts of for rent in quezon city area.. One I would describe is if I am going to base the photo, the place is cool to hangout with, and not just an ordinary place to stay or rent to. There's a patio, a hangout area and I think it would give you a HOME type of vibes or vibration-..ish?..... There's a street, as it says, or foodtrip street area nearby- 'the strEAT' why not name it like that? lol  and nearby University of the Philippines Diliman.

Source: https://htmlhelp.livejournal.com/2507088.html

Date: 05/28/10 (Asp Dot Net)    Keywords: sql

Hi everybody!
This is the question about how to use DataRelation object.
Let's say I have 2 tables:
SELECT customerId, customerName FROM customers
and
SELECT orderId, customerId, orderName FROM orders
which are related by customerId.

Assume I have method

getDataSet(sqlTextArray)

which returns me the DataSet based on array of queries sqlTextArray

So, then I can write:

String q1 = 
   "SELECT c.customerName, r.orderId, r.orderName "+
   "FROM customers AS c, orders as r "+
   "WHERE (c.ustomerId = r.customerId) ";
String[] q = new String[] { q1 };

DataSet d = getDataSet(q);
DataTable t = d.Tables[0];
for (int i=0; i < t.Rows.Count; i++) {
   String s = t.Rows[i]["customerName"] + ", " + 
      t.Rows[i]["orderId"] + ", " + t.Rows[i]["orderName"] + ".";
   Console.WriteLine(s);
}

String[] q = new String[] { 
   "SELECT customerId, customerName FROM customers", 
   "SELECT orderId, customerId, orderName FROM orders" 
};
DataSet d = getDataSet(q);
d.Relations.Add(new DataRelation("customer2order",
   d.Tables[0].Columns["customerId"],
   d.Tables[1].Columns["customerId"]));

Source: https://aspdotnet.livejournal.com/104432.html

Date: 02/17/09 (Asp Dot Net)    Keywords: database, asp, sql, web

Hi,
What I am trying to do this time is create an asp.net listbox from
an SQL Server 2005 result set (done) which then users can sort the
records to form the running order within the same Listbox and then
submit all the records including the new running order back into
the database. Each record has already been automatically assigned
a running order number based on their position in the old website.

I am looking for suggestions on the quickest and *easist* way to do
this, examples would be much appreciated. My web application is asp.net
written in C#.

Any help is appreciated.

Source: https://aspdotnet.livejournal.com/103147.html

Date: 11/28/08 (Asp Dot Net)    Keywords: database, sql

I keep getting an error the error 1) in my code, I am using a xsd file to call stored procedure and
access the database. This worked fine under Windows 2000 using visual basic express 2005. I am now
on a XP Machine using VS 2005 and i can get it to work. The error occurs at this point 2) and the
code that defines that dataaccess is listed as 3). So what am i doing wrong then all suggestion
accepted.

1) Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

2) content_page = dataaccess.GetContentPages()

3)

Dim content_page As Object
Dim page As Object
Dim page_number As Integer
Dim page_content As String

' call out the pages from the database
Dim dataaccess As DataSet1TableAdapters.pagesTableAdapter = New DataSet1TableAdapters.pagesTableAdapter
content_page = dataaccess.GetContentPages()

' Loop through the record set
For Each page In content_page
' assigned the page and content values to variables
page_number = page
page_content = page

Source: https://aspdotnet.livejournal.com/101914.html

Date: 09/11/08 (Asp Dot Net)    Keywords: php, sql

I have wrote small script to create container-class based on SQL query (or CSV list of vars)

http://akb.awardspace.com/build_class_based_on_sql.php

Wrote primarily for myself, but everybody is welcome to use it.

Source: https://aspdotnet.livejournal.com/100912.html

Date: 04/19/09 (PHP Development)    Keywords: php, mysql, database, sql

[solved, thanks to synergetic]

HiGuys,

Needing a bit of help with MySQL queries. Hopefully someone has the answer, or a pointer at least :)

Say I have a page displaying an item, www.domain.com/item.php?id=12 and at the bottom of that page i want to have a Previous link and a Next link which will link to the previous and next item in the database, how do i call the item numbers? I don't want to just do $id - 1 or +1 becausethe next item might be number 14 for example, not 13.

So before the links are displayed, i need some way of saying the id is 12, look at what the next number is in the id column and select that one. So it's not just a prev/next page link, but prev/next item in the DB link.

Hopefully my laymans terms aren't too confusing!

Any ideas? :)

many thanks,

Paul

Source: https://php-dev.livejournal.com/81861.html

Date: 03/10/09 (PHP Development)    Keywords: php, mysql, database, sql, web

[solved, thanks to thenetimp]

(x-posted to php)

Hey guys,

I'm coding an image gallery to use on my PHP site and need a bit of help with a couple of features I want to code into it. I was hoping someone here could either give me some pointers or send me to a website that will help with either explainations or code snippets :)

1. Firstly, thumbnails. I have created an admin panel where I upload the images and can set various things like the category, title etc, and all that is stored in a MySql database, and the file uploaded to a general directory. But i'd also like to create a thumbnail of the image as it uploads. I've found several scripts that make thumbnails from images already in a directory, but i'd like it to happen as I upload the image. Is that possible? Without having to use some all-in-one image gallery script heh. I'd also need it to resize the image proportionally so that images aren't just squashed into a 100x100 square shape.

2. Secondly, I'd like to "tag" images like with LJ entries, so that on the front end when a picture is being viewed, the list of tags is shown and can be clicked on to show other image thumbnails with the same tag. But i'm not really sure how to go about this... I was just going to have a table field called img_tags and store them all in that per image, but then is that efficient? searching for matches within a db field? any tips or suggestions?

3. oh and as an extra thought, how can i then take those tags and make a tag cloud maybe?

All and any help would be most appreciated! :)

paul
x

Source: https://php-dev.livejournal.com/81475.html

Date: 02/17/07 (PHP Development)    Keywords: php, mysql, browser, css, html, database, sql, web, linux, apache

Schedge, an Austin based company, is reinventing scheduling.

We are looking for an experienced Lead PHP developer.

Have you developed enterprise scale PHP applications?
Have you worked with technologies like AJAX and MVC?

Then this might be the position for you!

You'll be responsible for leading the development efforts of the core application. The position is contract-to-hire with the option of equity in the company.

Key Areas of Responsibility:
* PHP Application and database development
* Work with Designers and other Developers to build complex user interfaces and data interactions
* Write/Update functional specs

Required Experience:
* Enterprise scale PHP experience
* MVC (Model-view-controller) design experience
* Basic DOM Scripting experience
* Basic (X)HTML & CSS experience
* MySQL
* Multi-browser development
* Apache Webserver

Preferred additional experience:
* Experience with the CakePHP (or similar) PHP framework
* Flash or Action Scripting experience
* MySQL clustering
* Code development for Linux servers

You'll be a good fit if:
* You “get the Web”, and understand it’s full potential.
* Work efficiently and get it right, not just "good enough"
* Can set and execute priorities individually and in a group
* Effectively communicate to people of varying levels of technical expertise

Please note: This is a 100% telecommuting position but the ideal (but not required) candidate would be located in Austin, TX and available for weekly meetings.

If you feel you are a good fit for this position please send your resume and rate per hour to jobs@schedge.com

[cross posted] My apologies if you receive this post more then once.

Source: https://php-dev.livejournal.com/75751.html

Date: 01/03/07 (PHP Development)    Keywords: php, mysql, sql

Ищу людей для создания на общественных началах PHP BBMMOG. Понимаю, что это велосипед, который не гоже изобретать. Но важна не только цель, но и процесс!!!

Приветствуются: графика, вебдезайн, идеи, желание создать свой игровой мир и управлять им.
Предполагаемые направления:

Source: https://php-dev.livejournal.com/75394.html

Date: 10/14/05 (Web Hosts)    Keywords: sql, web

Free webspace to anyone that knows how to design and wants to build a personal / photographic website.

Just go to the site jenepher.com/x and fill out the form. I will send you your log in information after I set up your FTP account. If you have any questions just email them to me at bratusek@jenepher.com

-20 Mb of space
-unlimited bandwidth
-no pop ups
-no cgi
-no sql

Source: https://webhosts.livejournal.com/31628.html

Date: 10/15/04 (Elite PHP Development)    Keywords: php, mysql, database, sql, java

I was lookin around and found this tonight. Very much kewlness, I am hopeing to join in on the fun in the development community so I can add in my ideas to make PHP even better.
This is a little bit of information I picked up on Creating Custom Exceptions and sending data to the parent class from a function in a subclass. Very spiffy.

query("SELECT NOW()");
var_dump($result->fetch_row());
}
catch(ConnectException $exception) {
echo "Connection Error\n";
var_dump($exception->getMessage());
}
catch(QueryException $exception) {
echo "Query Error\n";
var_dump($exception->getMessage());
}
/* Handle exceptions that we weren't expecting */
catch(Exception $exception) {
echo "Who was that masked exception?\n";
var_dump($exception->getMessage());
}

$result->close();
$my->close();

?>

very spiffy, and I will be posting something using the new MySQLi class. Maybe a whole class system for the generation of graphics pulled from a database. Possibly attach that to a javascript paint proggy, or even better a flash paint proggy..... hmmm the posibilities are endless, but i have to get back to my money making... Gotta love it, but it would be so much more fun if i had a project that really challenged my knowledge and abilities, but well get to that someday.
-=Levi=-

Source: https://php-elite.livejournal.com/504.html