10,940 Topics
 | |
| | Must need coffee or something :/ Cant figure this out. I have a table with following info: [CODE][B] unique_id block_id column_id order_id user_id[/B] 1 block-1 column-2 0 1 32 block-2 column-3 0 7 7 block-1 column-1 0 2 8 block-2 column-2 0 2 10 block-6 column-2 1 1 11 block-7 … |
| | Im just wondering if its possible to set values automatically. For example theres data in my database that have dates of birth and some of them have all info filled in like 1953/12/25 and then some have just 1953. Is it possible that i can use some sort of code …  |
| | Hello, I'm trying to write a sql statement that would update a record only if a particular row column is empty; else, insert a new record. Is this doable? Currently, I have this update statement: [CODE]//query for additional cars 1 $mysql_query=("UPDATE additional_cars SET clientID='$edit_clientID', registeredstate='$edit_registeredstate', dhtmlgoodies_category='$dhtmlgoodies_categoryupdate', dhtmlgoodies_subcategory='$dhtmlgoodies_subcategoryupdate',caryear='$edit_caryear', servicearea='$lastservice', currentmileage='$edit_currentmileage', todays_date='$date2', … |
| | i have no idea where to start but; i'm looking for a way to change all emails from [email]suppliers@test.domain.com[/email] to [email]title@test.domain.com[/email] in a MySQL DB. DB Name: simons_directory Table: listing Fields: title, email caveats - title has words with spaces, if possible to remove the spaces so "My Business Name" … |
| | Hi all, I want to sort some sql results by a certain list. I don't want it sorted alphabetically or anything. I want to specify a certain list. eg "order by `office` = 'president', 'vise President', secretery'" ect. Is there anyway to do this? I didn't type this example exactly … |
| | Hi, how do I add (using SQL) string that has the char ' ? I have many words that look like this- dsf'dfdf or dfsdf' but when I'm trying to add them the query command thinks that the ' is the end of the string and then messes up everything … |
| | Hello all, I'm trying to build a forum site. The code below works fine but I dont know how to catch it from the address bar. I'm having trouble finding tutorials to help me with this. viewtopics.php [CODE] echo "<tr bgcolor='#6698FF' ><td><a href='viewcomments.php?id=".$rows['topic']."'> ".$rows['topic']."</a></td><td>".$rows['username']."</td><td>".$rows['timestamp']."</td></tr>"; [/CODE] Address Bar [CODE] http://localhost/testsite/viewcomments.php?id=Cowboys%20Dancehall [/CODE] … |
 | Hello everybody. I've created a PHP page that adds a new record to a table. I want to know what's the ID of that created record in that table. For example: [CODE]mysql_query("insert into tableName(field_A,field_B) values('valueA','valueB')");[/CODE] |
| | |
| | I installed mysql on ubuntu 10.10 using the terminal screen but when i give in the command %mysql -u root -p .it gives me the following error( as attached in the screenshot)..Please tell me as to how can i access my mysql account and create databases etc. |
 | Hi All, In windows on easyphp we open the mysql console from the browser by typing [url]http://127.0.0.1/home/[/url] In ubuntu when I do the same thing, it does not happen. I installed LAMP server using the following command sudo apt-get install tasksel sudo tasksel and then it is interactive When I … |
| | how to create stored procedure with phpmyadmin i tried this codes,its syntex error [CODE]1 DELIMITER $$ CREATE PROCEDURE `TestProcedure`() Begin select * from testtable; End $$ DELIMITER $$ or CREATE PROCEDURE `TestProcedure`() Begin select * from testtable; End [/CODE] i having mysql 5.1.41 version in my hosting regards rajan |
| | I have 2 tables: Users and Log I want to select ALL users from Users who are not in Log having already received a msg_id matching 'x' What I have so far is this: [CODE] SELECT * FROM users AS USR WHERE USR.user_id=2 NOT IN ( SELECT * FROM msg_log … |
| | hi all, i am writing store procedure so please send me steps to follow that increase the performance |
| | Hey, I created a simple user register script which later stores the data in a mysql database. What I did initially was that a small code would count the number of rows in the database and then automatically increase the variable by 1 to set the user id. For example … |
| | Hi,I have 6 checkboxes. name,father name,city,state,dob,education What i am trying 1)if user check name,father name its shows only checked item [B]name[/B] [B]father name[/B] Mr. a Mr.abs Mr. B Mr.bcd ([B]table structure like that[/B]) 2)if user check name,father name,city its shows only checked item [B]name[/B] [B]father name[/B] [B]city[/B] Mr. a Mr.abs … |
| | I wrote this code in php, it's purposes is to update the user record in mySQL database. There's already a script view.php which displays all records in the database, in the view file there's a edit link which sends the user id information to edit.php via get method. on the … |
| | Well i somehow failed to use the search on this site. How do i connect to an online mysql database via VB.NET? I did lot's of search the past few days Could not find my answer. |
| | [B]Hi all i am writing a software for a department store, how can i package LDF and MDF of its database and .exe of its windows form application design? i want to have one .exe file and give just it to department store's manager? could you please help me asap:) … |
| | Hi.. I am frequently using XAMPP's phpmyadmin for MYSQL database. I want to install original Mysql database from their developer's site([url]http://www.mysql.com[/url]). I am very confused that I found 6 types softwares. Which one should I install? I also need to access the software using GUI.. Any body can help me? …  |
| | I was following a tutorial and i copied word by word i don't know why i get the error. Error >> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/*****/public_html/download/url/search.php on line 36 [CODE]<?php $results = $_GET['results']; $terms = explode(" ", $results); $query = "SELECT * … |
 | I am trying to figure out the best way to figure out "age" of a particular item. I currently have fields in a mySQL databases that are stored as datetime formats and I need to display (in PHP) the relative age of those dates in terms of years, months, and … |
| | I have a query which generates a soccer standings table and am trying to create a different version which will only include the 6 most recent games for each team. An example of the output of my current query can be seen [URL="http://www.margate-fc.com/content/test/standings.php?season_id=104"]HERE[/URL]. The full query is below and I … |
| | Is it necessary to install mysql workbench in order to run database based php web apps? |
| | I am new to using sql .i have two table expense statement and revenue statement such as revenue statement accountname debit A 100 B 200 expense statemnt accountname credit X 300 Y 400 is there anyway i can join these two table like this, if so can someome tell me … |
| | I want the query to retrieve topics but if the topic repeats I only want one result to show up, no duplicates. I also want it to return username and timestamp. Here is what i have now but I get an error. [mysql_fetch_array() expects parameter 1 to be resource]. Anybody … |
| | i want to be abale to update the filed 'activated' to 0 when the 'expireDate' is before today. can you show me how to do it with a trigger? (i want to do this after the user insert the row) |
| | I wrote this code called delete.php, i have another script called view.php which displays all the users in the database and displays a link to delete that particular record using the get method. In the delete.php file it retrieves the id through get method from the view.php file and deletes … |
| | I'm trying to figure out the best way to replace apostrophes in various user input which is all formatted first using [B]mysql_real_escape_string[/B]. Of course this replacement should take place after all input has been sanitized and anything funny removed. :) Any help would be awesome! |
| | Ok I am stumped. I am inserting the data fine into the table and database so i know its not the config.php nor opendb.php. I used a code like this before and it work, i've only altered the $sql, the td's, and the $rows[]. Table name is hotspots (all lower …  |
The End.