10,938 Topics
 | |
 | Hi everyone, Trying to do a subquery to select the minimum price from table1, table what holds 15 million rows. I think that my approach is not the most suitable way of doing this. I want to select after oen_norm because oen_norm may have 1-10 rows per entry, but I … |
| | hi, i want to make a program where the csv file directly insert into the mysql database table. i found the code: [CODE]<?php include 'mysql-connect.php'; $rec=0; $handle = fopen ('datafile1.csv', 'r'); while (($data = fgetcsv($handle, 1000, ',', '"')) !== FALSE) { $rec++; if($rec==1) { continue; } else { $query = … |
| | hi everyone :) i know how to show all the records from database in an html table but how would i show specific category.for example i want to show records only with type T (type T is in database).im new with php and i dont know how to do it … |
 | Hello! I have a code here that has a dropdown box which is populated with data from mysql table, itinerary to be spicific (e.g. Tokyo- London, London - Tokyo, etc.). I also have a textbox that displays the block time (no. of hours required to travel a specific itinerary) of … |
| | Hello! This is my first post here, hehe. Seems to be a great site. Anyways, I'm quite new in PHP, but it's fun and I think I'm learning quite fast :) There's appeared a problem for me now though, and I can't see what the problem is...? I have made …  |
| | Hi! I referred to this forum thread when trying to build a MySQL search query for my site: http://www.daniweb.com/web-development/databases/mysql/threads/53025/mysql-select-rows-in-a-date-range But I just keep getting this syntax error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … |
| | Hi, I used fpdf lib to print pdf. And I want my php class be integrate in fpdf? Can anyone help me? |
| | as the thread name $query2= "alter table employee_leave_quota auto_increment= LAST_INSERT_ID()"; That is my query to reset auto_increment in my table, but it show error.. anybody know how to do it?  |
| | Hi every one, I have 3 table table temp: Name | Description A | Description A B | Description B C | Description C table temp1: Name | order A | 5 A | 4 B | 2 C | 3 table temp2: Name | Payment A | 3 B … |
| | Hi all, I have code as follows, to fetch rows from mysql table. Table it fetches is given below. I want to access now each cell in the table, how do I do that? For e.g, I want to multiply Rank for the Job "transform Brand image by 82% and … |
| | I want to creat a blog for my site, which is hosted on windows server. Can we host a wordpress site or blog on windows.  |
| | Please can someone show me how to retrieve database tables and add them as items to my JComboBox?.i have this app that i'm creating and it has a database which contains tables with their names and i want to add them as items into my JComboBox to aid file insertion …  |
| | Hello, I have got an error when i run this code.My query is updated but when I fetch the query then i got this error **mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\html-contact-form-captcha\update.php on line 44** please check the code is given below:- **** <!DOCTYPE html PUBLIC … |
| | Hi, I'm trying to write a program using mysqli, so I have created a login page. I've tried looking for how to get an Insert statement ran using MySQLi, object orientated style. So it looks like my query isn't working but I don't know why so I wondered if someone … |
| | hi, i write a code like this $user_id = $hd_cookie['user_id']; $user_password = $hd_cookie['auth']; $sql = "SELECT * FROM hd_users WHERE user_id='$user_id' AND user_password='$user_password'"; $r_user = mysql_query($sql); $num=mysql_num_rows($r_user); //line 24 it shows Warning Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\helpdeskfinal\includes\auth.php on line 24 when i print … |
| | so i have this mini project to make i'am thinking of making a website just like grooveshark basically what i want in my website would be :- A LIBRARY OF SONGS PLAYER ON WHICH ONE CAN LISTEN DIFFERENT SONGS USER CAN CREATE HIS PROFILE AND CAN MAKE HIS OWN PLAYLIST … |
| | Can somebody help me to create an appointment scheduler with php/mysql that automatically create appointments.  |
| | HI GUYS .. im trying to make foreign key relation between whishlist_tbl(foreign) table and account_tbl(primary key) table both are integer data container ## scenario ## i have user deatail table that is account_tbl and whish list table i.e wishlist_tbl i want that when user make a wish book then he … |
| | Hi I'm having issue with editing the **Input Type** in **2** different position. I want to edit and add input text in the img. I also want to edit and add input text in the content. What I want to learn is how to add **2** **Input Type** areas in … |
| | Hi, Can we call Mysql Storedprocedure in SqlDatasource. My Connection String is Works fine. If not Is any other alternate available? Thanks in Advance  |
| | I want to store a Vector<Vector<Object>> in mysql database. What is the best data Tpye that i can use in mysql and java to store and retrieve the datas.  |
| | Hi, I'm not new to SQL or PHP, or basic queries of SQL databases, but I'm creating a site that's going to be dependent on having a really accurate search feature. Basically, I'm just looking for some help on how I can get started, because there's a ton of information … |
 | mysql error 2003 can't connect to mysql server on 10.31.158.157 (10061) what to do please help me thankyou in advance |
| | I have been looking for hours on how to do this and haven't found a solution yet, hope someone here can help! Part of my problem is that I'm new to php and web dev, so I don't know what I'm looking for terminology wise. Goal: This is part of … |
 | I am having trouble with this code: <?php // Username $username = $_POST['name']; $email = $_POST['email']; // MYSQL $con = mysql_connect('host','username','password') or die(); mysql_select_db('db', $con); $var = md5($email); $result = mysql_query("UPDATE `table` SET `imageEs`='$var' WHERE user_username='{$_SESSION['sessid']}'") or die(mysql_error()); echo "Profile image updated. <a href='http://www.awsomechat.comuv.com/update_profile.php'>Go back.</a>"; ?> I am trying to … |
| | I am having trouble with this code: <?php // Username $username = $_POST['name']; $email = $_POST['email']; $default = "default image"; $size = 40; // MYSQL mysql_connect('host','username','password'); mysql_select_db('database'); $grav_url = "www.gravatar.com/avatar/" . md5( strtolower( trim( $email ) ) ) . "?d=" . urlencode( $default ) . "&s=" . $size; $sql = … |
| | I am newbie in php and i have code for retreving data from the website where the $id=id now i want to retreive the data based on the code Select * from users where cat1=cat1 and cat2=cat2 and also show the data according to the id in decrement order. i …  |
 | Hello. I'm trying to make a dropdown script to work and I'm stuck to a point where I feel the answer is simple ,but I simply can't see it . The script should display data from the MySQL Database when I choose the last option but I don't know how … |
| | I keep getting this error message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Hits and had 24,000 listener sessions; over 30 days. Get 5 commercials a day' at line 7 <!DOCTYPE … |
| | Hello all, I'm having a bizarre problem with the most basic of logins. I'm using a function to pass two parameters, just email and password but it just will not work and I can't understand why. I ran the query in the database and it returned a COUNT value of … |
The End.