10,932 Topics
 | |
 | Hello everybody, I wrote a file using AJAX this is the code I wrote: File.js [CODE]var http = createRequestObject(); function createRequestObject(){ var request_; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ request_ = new ActiveXObject("Microsoft.XMLHTTP"); } else{ request_ = new XMLHttpRequest(); } return request_; } function getInfo(){ http.open('get', 'GtCht.php'); …  |
| | <form action="book_dive.php" method="post"> <input type="submit" value="Submit"> <table border="1" width="75%" cellpadding="2" cellspacing="2"> <tr> <td align="center">BOOK</td> <td align="center">DATE</td> <td align="center">TIME</td> <td align="center">LEAVING FROM</td> <td align="center">BOAT</td> <td align="center">DEPTH</td> <td align="center">DIVE SITE</td> <td align="center">MIN QUAL</td> </tr> <? include("conn.php"); $res=mysql_query("SELECT * FROM dives"); if(mysql_num_rows($res)==0) echo "No data in table"; for($i=0;$i<mysql_num_rows($res);$i++) { $row=mysql_fetch_assoc($res); //mysql_fetch_assoc STORES A … |
| | I made a query that joins 3 tables. Products, parts, and sales invoice tables. The thing is, the common key between the 3 tables is the sales invoice number, but when I try to execute the the query it displays duplicates. One example is when I make a query on … |
| | Hi Everybody! How to upload a image / pdf file in mysql table blob column with ASP pls help me HemantK |
 | Hi everyone I'm looking for advice on building up a database. Any sort of general do's and don't s. The one and only thing that I realize is that putting ALL my info into one table is not a good thing. This is the first database I'll be creating so … |
| | I need a very strong PHP, MySQL programmer for a large Web development job. The freelancer will be required to work at the client site ONLY in the western Chicago suburbs. The project will begin in 2008 with the following high level criteria: 1) The main focus of the project … |
| | Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of anything table - this foreign key is automatically generated and the key field in the 'foreign' table. So I have the following situation (kind of): Table Observation [INDENT][B]Time_Stamp[/B] - [I]primary … |
| | |
 | I'm trying to keep all my dates and times to a standard GMT (UTC) time when I store it into the database. When I pull the data however, I want to be able to do the timezone adjustment within the query. I've tried something like this with no luck: [CODE] … |
 | Ok, I thought I had gotten all the answers I needed and marked my thread as solved. But now I am having problems trying to put the code into use. I tried to insert the data from my form into my data base and got an error message. I obviously … |
| | html page <form method="get" action="sort2.php"> <table> <tr> <td>id</td><td><input type="text" name="id"></td> </tr> <tr> <td>From</td><td><input type="text" name="from"></td> <td>To</td><td><input type="text" name="to"></td> <td><input type="submit" name="submit" value="submit"></td></tr> </table> </form> sort2.php <?php $id=$_REQUEST['id']; $to=$_REQUEST['to']; $from=$_REQUEST['from']; $link=mysql_connect($hostname, $username, $password); mysql_select_db($dbid) or die("unable to connect"); $query="(select name,id from member where id=(select day,time from attend where day between '$from' …  |
| | hi i have a form where the user will enter the data based on the user input i want to retrieve data ex 1st textbox one get the standard (class of the student) 2nd & 3rd textbox get the range (ex rank 1 to 10) when the user clicks submit...i … |
| | Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity … |
| | Hi all, I'm currently finally starting mysql and am have difficulty getting it up online. what i've done so far is correct but only for this error: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'www.dteeducation.ie' (61) in /usr/www/users/adv123site/home/youruser/public_html//settings/database.php on line 10 Cannot connect to database, check if username, … |
| | Hi, I am trying to create a 'simple' admin page where certain (authorized) people can update data in the database or add new info to it. The issue i've run into is after i created the form and have all the fields how do i tell which one(s) the user … |
| | hi i have two different table,i want to select the name and id(primary key) from the first table..based on the id..i want to select the rest of the data in the second table... the below query is showing error,plz do tell me the bug. $query="select id,name from table1 where id='$id' … |
| | i currently have a database that someone else created a while ago and i have been tasked with speeding up the data entry and search functionality. currently the database is one table with the following field names: bid_id = primary key date_num = date of project proj_nm = name of … |
| | hi i have a table where dates and other info are getting inserted... i have a form where the user can select a start date end date.. based on the start date and end date ..i want to retrieve all the content stored between these dates..... |
| | I'm trying to learn php/mysql Read "php and mysql for dummies" and keep getting stuck. Can you get me through this? Regards, Kris [email]m31342@hotmail.com[/email] |
| | Am trying to develop a front-end to Mysql database. I do not intend to use it for web purposes so I do not need PHP. which slanguage can I use? |
| | Hello! I have a query with multiple table joints and where clauses. Tables are huge and query runs for a very long time. I need to run another query, which is exactly the same apart for one Where clause (first time price = "P", second time price = "S"). I … |
| | Hi, I am using a JSP from to collect data from user and then inserting those values into a table in MySQL.But it is returning 'null' always.I am able to query the DB and view the entire table and everything else is fine. But the INSERT is not working somehow!!! … |
| | I really don't have the patience for this but I'm trying to learn php/mysql and really could use some tutors. The online tutorials are a fair introduction. But I've got a big project I need to make progress on quickly. If anyone here would be willing to give me some … |
 | Example: Navigate: PHP Code Library > PHP > Sub1 > Title V Any ideas, tutorials no how to do that using php & mysql ? each category should be able to have items and more categories under it. It should use a single table to store all the category titles. … |
| | Hi Everybody, i found out that to create a trigger i have to remove the BEGIN and END and it works, but as i put an IF STATEMENT inside like this one: CREATE TRIGGER status_history_upd AFTER UPDATE ON projects FOR EACH ROW IF NEW.project_status != OLD.project_status THEN INSERT INTO project_status_history … |
| | Hi, Im only used to basic sql queries. wonder if anyone can help with the below - or at least get me pointing in the direction of the correct resource to solve. I have a table, with fields a,b,c,d,e,f I need to run a query that shows from the above …  |
| | [B]Warning[/B]: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [B]/home/content/r/a/e/raeyshe/html/fanlisting/admin.php[/B] on line [B]36[/B] [code]<? // select all unapproved members $result = mysql_query ("SELECT * FROM $table WHERE apr!='y'"); [COLOR=darkred][B]if ($row = mysql_fetch_array($result)) { [/B][/COLOR] do { // display all unapproved members ?>[/code] Line 36 is in bold, … |
| | I've two tables where their composite keys are foreign keys that references each other. table1 (projId, userId, name, add) table2 (projId, userId, status, responseDate, reason) I need to retrieve table1(name,add) and table2( status, responseDate, reason) with projId only.. my query is [CODE]Select ap.name, ap.add, p.status, p.responseDate, p.reason from table1 ap, … |
 | hi... i have setup the mysql replication but i dont know for some reason its not replicating the data.. i may be missing some configuration.. please help me... to do the same.. Thanks in advance.. Pooran Jaiswal my.cnf entries on slave server [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old … |
| | My hosting server is located in Texas and when I use the localtime() function, I get Texas local time rather than Massachusetts local time (where I currently reside). I want to standardize all my time information so that when I store it into the MySQL database, I store GMT rather … |
The End.