7,368 Topics
|
|
Hey guys, I need a "little" help with a query. I'm trying to pull information regarding referrals from search engines which grab the keywords. For example, two people search for [b]foobar[/b] and another searches for [b]barfoo[/b]. I would need the results returned similar to this: [code] Hits | Page URL … |
|
Hi Guys, Im having problems with some mysql select statements. I have a database containing 7 tables in the following format: [U] Adverts [/U] Field Type Null Default advert_id int(11) No 0 frequency int(11) No 0 [U]keywords[/U] Field Type Null Default key_id int(11) No 0 keyword varchar(20) No [U]keywords_to_adverts[/U] Field … |
|
Dear folk, what should I use for [COLOR="Red"]Price[/COLOR] Field in Data base I have used BigInt But I know I could do it with Decimal , I ned to do it without any Limitation of the size of the digits and the numbers after dot ( . ) so what … |
|
I was wondering how to store this date into the database: Friday, August 28, 2015 and this time: 8:00PM I have one field that collects the date and another for the time.. Im looking to store them in this format, 0000-00-00 00:00:00.. Is there some way to turn this date … |
|
i was just doing a simple thing in C#, just trying to put the values feeded in the text boxes in sql database. i am giving the code below the code executed perfectly but when i went to look into the table data there was no data inserted...... pls HELP...!!! … |
|
Would anybody happen to know which of these ways is the better way to run your queries?? Would it be better to have all your SELECT queries before the actual <html> code starts, or would it be just fine throughout the page in the <body> tags?? Is one slower than … |
|
i want to insert new row in second table and this table connected to first table. How can i do that? |
|
I having a requirement to store the image in mysql and also retrive the image and display in the browser. Please help me. how to do |
|
hi how to combine three tables in a single query.please send a sample code thanks |
|
|
Bit of a php and sql issue, so thought I'd try here... for a registration form, I have created an sql file such as... [icode]firstname varchar(30) not null[/icode] ...etc...for all the fields, which I then import to the database. But then the form also has 15 checkboxes where the user … |
hi i want to join four tables.i used left join.thougn value are there in my db all the datas from seekers_qualification, seeker_target tables are getting displayed as Null.but there is no Sql error [code=sql]SELECT seekers.firstname, seekers.middlename, seekers.lastname, seekers.totalexperience, seekers.mobile, seekers_qualification.qualification, seeker_target.jobtitle, seeker_target.ann_salary, seeker_target.state, seeker_target.relocate FROM seekers LEFT JOIN ( SELECT … |
|
I have an invoice type of system and am having troubles trying to update an item.. I have 3 tables that deal with the orders.. Here they are: [code] CREATE TABLE `dw_orders` ( `order_id` INTEGER unsigned NOT NULL auto_increment, `customer_id` INTEGER unsigned NOT NULL, `order_date` DATETIME NOT NULL DEFAULT '0000-00-00 … |
|
I'm trying to figure out a way to get this if statement to work.. [code] $array = $_POST['field']; foreach ($array as $key => $value) { if ($value does not exist in database) { $query = "INSERT INTO..."; elseif ($value >= 1) { $query = "UPDATE... "; } else { $query … |
|
I'm looking to have people register times (like 2:34, 2:35.04, etc.) into my database. Do you use integers values or something else? Thanks! |
|
Hi All, I need a hlp how to connect Mysql wit outlookexpress, so that i hav to retrive data from mysql to outlook express. Regards, Sugan |
|
You need a column type which will be able to store time and date in the range 1900-01-01 - 2199-12-31. Which column should we choose for this range ? |
|
Which keyword should be used in a SELECT statement to retrieve only parts of the result set? |
|
Your operating system and/or filesystem places a limit on the size of files. You need to create a table that is greater than the maximum file size. How can we resolve the problem ? |
|
I am currently working on a small game, and couldn't get my head around if this could be done within mysql easily or even at all. Within the map there can be creatures in different areas, and to limit them, I used a pool to seed the creatures that could … |
|
Hi, I just started using phpMyAdmin. I need to create a table with all the dates of the year. The date will be the primary key and for each date there will be five time fields. Is there any way to do that with one SQL query? Thanks in advance. |
|
Hi, I have one query. Can we use empty resultset objetct for checking any condition. supose in my query: [B]rs= st.ExecuteQuery("select * from user where userid=1 and eventid =4");[/B] which result in [B]empty resultset [/B]. so can i use [B]rs[/B] for following use as: if(rs==null){ do some operation }else{ do … |
|
On of my database stooped working. [QUOTE] mysql> check table invoice; +-------------------------------+-------+----------+----------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------------------------+-------+----------+----------------------------------------------------------------------+ | billing_db.invoice | check | Error | Incorrect information in file: './billing_db/invoice.frm' | | billing_db.invoice | check | error | Corrupt | +-------------------------------+-------+----------+----------------------------------------------------------------------+ 2 rows in set (0.00 … |
|
i have just had to go into the backend of an old site to fix the mysql db as some had deleted the wrong db. i have got most of it working again now but did not know what this line of code is doing. [CODE]$sql = "SELECT id,thumb,image,designer,title,(total/freq) AS … |
|
[code=php] <?php $result = mysql_query("INSERT INTO ".UPREFIX."items` VALUES ( '', '".$item_name."', '".$item_descr."', '".$item_action."', '".$item_rarity."', '".$item_value."', '".$item_folder."', '".$item_image."', '".$item_cat_id."', '".$item_visibility."')"); ?> [/code] I didn't know if this would be php or MySQL. I'm getting returned the following error: You have an error in your SQL syntax; check the manual that corresponds … |
|
Hi, I have "Balance" table that is shown below. Table :Balance todaysDate/openBalance/closeBalance ------------ --------------- -------------- 2008-07-24 250000 100000 Above record will be inserted into next row as it is at 10:00pm. How do i do this? Thanks |
|
have had to move some file across from one server to another and i am now getting access denied for user. it also says it could not connect to the server. i have changed the site path so it is now the address where the files have benn moved across … |
|
I am trying to find a way to calculate a running total of a field in my database, and while I have found a lot of good solutions, such as [URL="http://www.daniweb.com/forums/thread127644.html"]http://www.daniweb.com/forums/thread127644.html[/URL], they all require that I have a column which is ordered in the way that I want it to … |
|
I am stuck between deciding between MySql and Oracle, The reason being, I want to know how long it will take for MySql to reash the level of the current Oracle, if its gonna take more than a year....I guess Oracle is worth the money else not. Any views on … |
The End.