10,945 Topics
 | |
| | Hello, When I run this query then i am getting **SELECT * FROM upload where cas_no=''104-55-2''** Why I get backslash in my query ? Otherwise query is ok. and URL value is exact value. www.abc.com/upload_reportt.php?cas_no='104-55-2'.... so what happen with my sql query? <?php session_start(); include(functions.php); ?> <body bgcolor="#F5F5DC"> <a href="logout.php"><h3 …  |
| | I need help on my update statement, the condition is , i have to update the status . the table name is leave_request , it contain leave_req_id, date_applied,emp_id,leave_type_id,leave_period_id,leave_status and the default for leave_status is 'Pending' the problem is, choose approve, and on the database should change the leave_status into 'Approve' …  |
| | Im trying to get transaction details of a paypal account, which I was successful in doing so, but I get this long (what i assume is an array) but I need to insert the details into a mysql database. I've tried several foreach methods but apparently I am doing something … |
| | I am a new PHP developer, I run a LAMP server but use Win 7. For the PHP Developers out there, is it much more helpful to have a local WAMP server? I can see how it would be nice to be able to develop without uploading every four seconds … |
| | I installed Xampp and have the apache, FTP and MySql server running. Initially i was getting an error:- ## error :- ## MySQL said: Documentation 1045 - Access denied for user 'root'@'localhost' (using password: NO). Connection for controluser as defined in your configuration failed. phpMyAdmin tried to connect to the … |
| | Hi all, i manage to write this query to select data from 2 different tables, here is it $query ="SELECT * FROM illness,symptoms WHERE symptoms.sympId = illness.illId"; am trying to echo the result of the query, here is my script if($med == !'') { $query ="SELECT * FROM symptoms,illness WHERE …  |
| | I need help in using a variable passed in a hyperlink query string to do PHP query of a MySQL database. I want use the variable to query the database and return the unique row field data to display in a table The hyperlink is: [CODE]http://www.site.com/bios.php?pc=ab [/CODE] After connecting to … |
| | arent those two the same function? and i want to ask, can i use 2 query statement in 1 while? `while($row = mysql_fetch_array($result))` i want to add another one beside that, it will be like this `while($row = mysql_fetch_array($result) && $row1 = mysql_fetch_array($result1))` is it valid? |
 | 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 … |
The End.