10,940 Topics
 | |
| | hi.. i am newbie on learning web dev and still find the best resource for my study .. can anybody give a mysql manual that contains all mysql syntax and the syntax usability :) thanks all, please reply |
| | Hi Everyone I'm hoping someone could help me out please. I have a database of names and email addreses with the following columns: user_id (auto increments) user_name user_email user_email_sent Basically I have a form (for myself) that returns all the rows in the database and next to each row I … |
| | I use wamp as my server. I used mysql-connector-java-5.1.5-bin.jar It worked ok/ But I set up same in another computer it gives an error saying ([I]In Jcreator[/I]) [B]Error: Error reading C:/Program Files/java.../ mysql-connector-java-5.1.5-bin.jar ; Error in opening zip file[/B] What is this error & what can I do? Plz help. … |
| | Hi folks, I'm wanting to add tables to my current database that will be based on a CRM idea but tailored to my specific needs. Are there tutorials or places I can look online that go into building database structures for different needs? I'm a newbie, so some of the … |
| | [CODE]################################### #Email Extractor v1.0 ################################### %3C?php ############################################################### # Email Extractor v1.0 ############################################################### # Created By Garibay ############################################################### $the_url = isset($_REQUEST['url']) ? htmlspecialchars($_REQUEST['url']) : ''; ?%3E %3C?php if (isset($_REQUEST['url']) && !empty($_REQUEST['url'])) { // fetch data from specified url $text = file_get_contents($_REQUEST['url']); } elseif (isset($_REQUEST['text']) && !empty($_REQUEST['text'])) { // get text from … |
| | Hi, Assume, I have table which consists of 5 values, say C:/Testing/test1/ C:/Testing/test1/test2/ C:/Testing/1/ C:/Testing/ C:/1/ I want to query the database table to get the values starts from 'C:/Testing/' and '/' as a escape character. ie, I want to get only two things, C:/Testing/test1/ C:/Testing/1/ Both starts with 'C:/Testing/' … |
 | how to do this? like ive seen some HARSH codes with things i dont understand in themm like information.schema and datetime whats the simple way to add a column to a table if it doesnt exist? and what the heck how to not add it if it already exists ? … |
| | OK! This will probably reveal my IQ , but here goes. I am new to PHP and MySQL--I am learning from a ton of books--and I am struggling with many-to-many relationships. All of the books make a lot of assumptions. I get the concept just not the mechanics. Say I … |
| | Hello guys I am a freelance web designer. I work with the following technologies..... PHP, MySQL, ASP, ASP.NET, SQL Server 2000. Doing research in Web Technologies... most of it related to security. Hoping to give and receive knowledge from all of you. Take Care. Regards Praveen Balla |
 | I have Visual Basic 8.0 and Use Mysql 5.0 Database Table Test: Field type ID Integer (PRIMARY KEY) Name Char(10) Adress Char(15) City Char(15) ID Name Adress City 1 Andre Street 1 New York 2 John Street 2 Amsterdam 3. Joyce Street 3 Londen I have create a index on … |
| | The title is pretty self-explanatory. I'm working on a PHP engine, and I'm trying to implement a SQL query generator. The hardest part of this will be designing the system for using the SELECT command. Are there any practices that I should try to follow when designing this, or any …  |
| | Hello, So lately, I've been coming across this issue of mine and can't seem to find a solid way around this problem. My problem is due to the fact I'm using MYSQL C connector library. And, Attempting to gain all the Row's from my database and store them in a … |
| | i am using the following JQuery function to successfully POST data to the user_submit.php file, its just that the php file is unable to receive the data. [CODE] $(function() { $("#submit_js").click(function() { $.post("user_submit.php", { comment: $("#comment").val() }); }); });[/CODE] upon finishing the Firebug consoloe shows this: [CODE]<html> <body> Your vote … |
| | Hi, If you are a Joomla user and forgot your Administrator password then don’t think of re-installation. There is an easy way to change your Administrator Password. To get your password recovered you will need following things. Access to PhpAdmin If you are Cpanel user you will find the link … |
| | please help me with some codes to update about thousand record in the database.i.e. changing all one to two and moving all threes to a different table in the database. 2.Also a code to select all in a listbox |
| | Hey guys I'm having a bit of a problem with a database application i'm trying to design for organizing information from a non profit childrens hockey organization i'm with. Right now my problem is with 3 tables. I've got the application querying a list of games. And now i need … |
| | i have 2 database & need some code to solve this problem. table 1 (food_place) : fp_id | fp_name 1 | McD 2 | Burger King 3 | Pizza Hut -------------------------------------------- table 2 (promo) : p_id | p_name | p_pid 1 | Disc.10% | 1 2 | Free f. fries … |
| | How Many Databases are there? I know some of the databases, but i want to know many more databases, & what are they? |
| | CREATE TABLE message ( id bigint(20) DEFAULT '0' NOT NULL, inReplyToID bigint(20) DEFAULT '0' NOT NULL, createMonth int(11) DEFAULT '0' NOT NULL, createDay int(11) DEFAULT '0' NOT NULL, createYear int(11) DEFAULT '0' NOT NULL, boardID bigint(20) DEFAULT '0' NOT NULL, subject varchar(80) DEFAULT '' NOT NULL, authorEmail varchar(80) DEFAULT '' … |
 | Hello all, Not sure if this is the proper forum for this but first: I am using Visual Studio 2008 and MySQL Server Version 5.1.42 and Client Version 5.1.11 programming language C# issue: save button from windows form for record editing using databindings and textboxes... is there a way to … |
| | Hello guys. I am looking for a report/statistics generator for mysql. Basically i want a tool that can connect to a sql database and use columns in different tables to generate graphs, charts etc. It would be good if it has support for timestamps. Is there a tool like this … |
| | I have a mysql db with 3 tables (this is supposed to be a db for a dvd rental store) 1) MOVIE PK MovieID Title Type Year Producer 2) CLIENT PK ClientID Name Address City 3) RENT PK RentID Date FK MovieID FK ClientID Cost The exercise told us we … |
| | i write query like select * from pm_task_user_work LEFT JOIN pm_task_allotment ON pm_task_allotment.task_allotment_id=pm_task_user_work.task_allotment_id where pm_task_user_work.project_id='19' and (Select str_to_date(pm_task_user_work.task_user_work_link_time,'%Y-%m-%d') as MyDate from pm_task_user_work) BETWEEN '2009-12-15' AND '2009-12-15' order by pm_task_user_work.project_module_id,pm_task_user_work.task_user_work_link_follow It gives me Subquery returns more than 1 row ------------ 2> SELECT pm_task_user_work . * , str_to_date( pm_task_user_work.task_user_work_link_time, '%Y-%m-%d' ) AS … |
| | Hello, I am trying to compare a MySQL date to a user entered date in Perl. Basically, [code] while ( my @data = $sth->fetchrow_array() ) { print($data->{'day'}); if($data->{'day'} eq $userdate) { $conflict = 1; break; } } [/code] Being Perl code, I wasn't sure if posting in databases was inappropriate. … |
| | I have two servers and one of them have mysql db and one doesnt so is it possible to use mysql db in my other server while hosting my website on another. also if there is how would you do it with php. |
| | [code=php] <?php include 'config.php'; include 'opendb.php'; $result = mysql_query("SELECT * FROM 888db ORDER BY id") or die(mysql_error()); echo "<table border='0'>"; echo "<div id='bodyframe'>"; // keeps getting the next row until there are no more to get while($row = mysql_fetch_array( $result )) { // Print out the contents of each row … |
 | this is not a web design question, i'm actually using it in vb.net but they don't have a database forum in the software development section. what i am doing: i have two tables. customer and customer_phones my visual basic program has a search for customer option, which returns the customers … |
 | Hi All Friends, I Have a Problem in My PHP Code that The $tree Array not Store Third Value(Parent ID). my Code is Display Below. The Below code Show Parent/Child Tree from MySQL Database.: dhtmlgoodies_tree.class.php [CODE]<?php /* This is one of the free scripts from www.dhtmlgoodies.com You are free to … |
| | Hey all you AJAX masters, Here comes a long post but I know someone out there knows what's wrong here.... I have no idea why the following script doesn't work but I think I have isolated the problem. I have an 'order form' page (that calls this script) that generates … |
| | Hi, I need some help searching for extended ascii characters. I keep track of scores for a game along with the user's name. The user can have a crazy name like "»LPk«FËNÎX§" but when he searches for himself it isnt found so he has to search for something like lpk% … |
The End.