10,942 Topics
 | |
| | I'm trying to make a postback script which works with a CPALead widget, however it does not seem to work. I do not think my code is wrong (which I have attached at the bottom) so I was beginning to think this was not possible due to the fact that … |
| | Recently I have been working with Mysql and PhpMyAdmin a lot on Ubuntu, and I have stumbled across a very annoying error, or set of errors. I keep on getting a bunch of random loosely related error messages. These are the errors I get. When I try to log in … |
| | [B]Hi guys, Well I just reinstalled vBulletin 3.8.6, on top of the other. I tried to make a new THREAD, after posting it says:[/B] ___________________________________________________________________ Database error in vBulletin 3.8.6: Invalid SQL: UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts); MySQL Error : Unknown column 'newposts' in 'where clause' …  |
| | 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) |
The End.