11,093 Topics
 | |
| | Hi all, I am trying to output data from a MySQL database from the column, 'category', however what I have at the moment isnt working. Any suggestions please? [CODE]$catrow = mysql_query("SELECT category FROM tuck"); $cate=array(); while($category = mysql_fetch_assoc($catrow));{ $cate[]=$category; } echo $cate[0]; echo $cate[1];[/CODE] Thanks |
| | Hi, the problem is that my scrip stops if a duplicate key is found and i would like to know how to handle duplicate inserts into database and if founded ignore and don't insert the data or handle the type of error. [CODE=C#] try{ cmd.CommandText = "Insert into subscritor ..... … |
| | I have an html file that is supposed to do a search and return of a database I have created in phpMyadmin but is giving me nothing but one error after another!!:'( This is the html form[CODE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Directory List Request</title> … |
| | I am working on an Android app for a company. Their website is hosted on godaddy and all of the info I need for a "news" section are in their MySQL database. What is the best way to show the latest news in the app? I figure the easiest way … |
| | I have two tables Banks(Bank_id, Bank) FX (ID, Bk_id, currency, trans, value) Banks and FX are innerjoined on Banks.Bank_id=FX.Bk_id. in the original table in database: [CODE]Code: ID Bank Transaction type Currency Value 1 X Buy EUR 1 2 X Sell EUR 2 3 X Buy USD 3 4 X Sell … |
 | Hi guys! Please - tell me -how to perform the following task. There is a table- [CODE] table SUBJECT ( SUBJ_ID NUMERIC not null, SUBJ_NAME VARCHAR(100), HOUR NUMERIC, SEMESTER NUMERIC );[/CODE] I need to count the number of items. studied in each course. I had already counted number of subjects, … |
| | Hey all, my first post in this brilliant website, got a lot of ideas from here. So I'm a student and currently we are learning a bit of php and right now I'm stuck. I have a database with URL adresses, there is 3 fields, id, name and adress. I … |
| | I am trying to write a PHP script to connect to a database I have created in WAMP Server 2.0 but no matter what I do I keep getting the same error message: Parse error: parse error in C:\wamp\www\database.php on line 5 I have looked at this for over an … |
| | Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\AppServ\www\eUTM\login\logincheck.php on line 13 here is the code: <?php //login check require_once("dbconn.php"); $con=connectdb(); $idpengguna=$_POST['idpengguna']; $katalaluan=$_POST['katalaluan']; //login PELAJAR from table pelajar $pekerja_query="SELECT * FROM pengguna where idpengguna = '$idpengguna' AND katalaluan = '$katalaluan'"; $pekerja_result=mysql_query($pekerja_query,$con); $pekerja_row=mysql_fetch_array($pekerja_result); if(!$nama_id && !$katalaluan) { $err=1; … |
| | I need to know how to sort my authors into their respective categories I have a mysql table with the authors details and another with the categories this is my code to get the info from the tables (i realize I spelled category wrong in my database) [CODE]$sql = 'select … |
| | I am running an automated script that generates a CSV file from a query every 24 hours which works well, but I must use root login. As soon as I change it to the user login (who has the same rights to the schema as root) it gives me the … |
| | Hi, Dear frnds ,i am new to this site. could any one help me i want to know the Requirements of hardware for MYSQL - thans®ards sureshbabu |
| | i've successfully developed a page where i can echo a `$_SESSION['SESS_MEMBER_ID']` and display the member id of a person who is logged in. however i need to display all the data of two mysql databases that are relational. $sql = "SELECT * FROM `members`.`players` WHERE `member_id` = 3 LIMIT 0, … |
| | I have created a login system with some validation which all works fine, however I want to be able to create a session when the user logs in and then store this session information in a table that I have allready created. The table has the following values id ip_address … |
| | First the table [CODE]create table customer( no int NOT NULL auto_increment, cust_id varchar(15) NOT NULL, cust_name varchar(50), cust_address text(150), cust_phone int, cust_email varchar(30), PRIMARY KEY(no));[/CODE] Then the trigger [CODE]DELIMITER | CREATE TRIGGER trig BEFORE insert on customer FOR EACH ROW BEGIN set new.cust_id=concat(new.cust_name,new.no); END; DELIMITER |[/CODE] Then the insert query … |
| | Please help.. i need a script for this problem. i have 2 different departments, one is accounting and the other is payment. it should be the accounting page will create a transaction and when the transaction has been done, the webpage of the payment department will automatically show that there … |
| | Date: January 22, 2011 Hi, Need some help to solve this error. Nothing similar in the forum, IMHO. [B]Environment:[/B] [QUOTE]phpMyAdmin – 3.3.9 with this info: # Version MySQL client: 5.0.51a # Version MySQL: 5.0.45 # Server: Localhost via WAMPSERVER 2.1 # PHP 5.2.6 # Apache 2.050 [/QUOTE] [B]TABLE [/B] DROP … |
| | Hi Guys I am new to PHP and slowly learning. I have a piece of code that I need some help with. I am trying to take user input and use it to query data from a table in MYSQL. I know all my connections are working because I can … |
| | Hey Guys, Struggling a bit here trying to get my head around something. I'm not a PHP expert, but I feel I've come a long way in the 6 months or so I've been learning it. Anyway, I thought I would pluck up the courage to build my own custom …  |
| | Hi there, I am having a Javascript problem and any help would be apprecated. I am trying to test the input for if length = 1 then add on a 0 as this would mean if the user wanted £1.20 if would come out as £1.20 and not £1.2 as …  |
| | hi, I want to import a text file which delimited by tab to mysql. 1) using phpmyadmin => results ( exceed time limit even i've extend) 2) open using excel file save to .csv but still couldn't save all the record 3) using ms access with odbc connection => almost … |
| | I have created my personal login system. I am kinda newbee here. When user log in it creates cookie as 'user'. I've seen some sites to which creates password cookies too. So i need to verify both the cookies in mysql database every time with the every page loads? And …  |
| | I've been trying to get this code to work for hours can anyone spot the mistake i made? its a code to edit the contents of a database field calling it by its primary key. my error code is Parse error: syntax error, unexpected T_VARIABLE in E:\xampp\htdocs\php\databaseview\records.php on line 103 …  |
 | When is it appropriate to use InnoDB table types? What about for a forum such as this one with huge post and thread and memberlist tables? I was reading on dev.mysql.com that it is more efficient than MyISAM for large table types? Is this always the case? Would it make … |
| | Hello, I am trying to get the MySQL id field to auto update itself when an item is deleted. However the below doesnt work. When a user searches by name, then I need to grab the id of that name before I delete it and minus 1. [CODE]$name = $_POST['name']; … |
| | i am trying to register 2 sessions. one is supposed to get the id of the user logging in, the other is supposed to get the persons username. here is the login page: [CODE]<?php session_start(); include "dbconnect.php"; $myusername=$_POST['user']; $mypassword=$_POST['pass']; $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = … |
| | Here is the query: [code]mysql_query("UPDATE il_pageparameters SET totalvisitor_to_refer=$totalvisitor_to_refer, referer_page_url='$referer_page_url', message='$message', rewardmessage='$rewardmessage', background_image='$bg', poweredby='$rg', istoshowrm=$istoshowrm, msg1='$msg1' WHERE id=$configid;");[/code] I have tried echo'ing the output: [code] echo "UPDATE il_pageparameters SET totalvisitor_to_refer=$totalvisitor_to_refer, referer_page_url='$referer_page_url', message='$message', rewardmessage='$rewardmessage', background_image='$bg', poweredby='$rg', istoshowrm=$istoshowrm, msg1='$msg1' WHERE id=$configid;"; [/code] Run the echo'd output manually in phpmyadmin and it works fine. … |
| | hey friends...i request you all to pls help me out...im damn confused... im planning to make a website by March,2011 in which i will be using HTML/JSP and Mysql as d/b. however, i have a few doubts abt. Mysql.... 1) on the mysql site, there are many packages available to … |
| | I am new to SQL and databases in general. My problem is that I am trying to create a table that will store information about users in each row based on the date of that activity. So I need to create a table with 365 columns representing with one representing … |
| | Hi there, I am looking for some help on PHP/MySQL please :) I have a site where you add an item via a form which is then put into a mysql data base. I was wondering if there was anyway so that on this inital form there could be a … |
| | Hello, I am using a code to generate an id for a table.But it is giving 'Conversion from type dbnull to type integer is not valid' exception. Now I know that this is due to the table being an empty set.But it works properly if there is already a row … |
| | I have an html form which has 2 fields realuser and useremail it then submits on the php page .i have a database table named auth .my database has 3 fields i.e realuser,useremail and details ,in which i have filled "details" field already and rest 2 fields are blank.i have … |
| | How would i upload image files to a database and then display them using [CODE] <?php $query = "SELECT * FROM members WHERE email='$username' AND id='$id'"; $result = mysql_query($query); $row = mysql_fetch_array($result); ?> <img src='<?php echo $row['pic']; ?>'> [/CODE] and also, what kind of field should i use in the …  |
| | Good evening: I need assistance getting data formatted properly when it is pulled from my database. The database pulls everything correctly, so let's assume the following table: $results = $db->query($sql); [code] +----+--------------+--------------+-----------+ | id | name_of_item | cost_of_item | item_type | +----+--------------+--------------+-----------+ | 1 | product01 | 20 | 1 … |
| | the following should return 1 row [code] $search= "Timothy"; $query4 = mysql_query("SELECT * FROM test1, test2, combination WHERE test1.IDONE = `combination`.IDONE AND test2.IDTWO = combination.IDTWO AND test1.NAME LIKE '%$search%'",$this->connect) or die(mysql_error()); [/code] instead it returns zero. the query should take values from all three tables according to the where clause. … |
| | Hi, I'm wondering if anyone can help me with a query? I have 3 tables in phpmyadmin, vehicles, drivers, and bookings. I need to make a booking in the bookings table (primary keys are DriverID, VehicleID, BookingDate) this will ensure its a unique booking and the DriverID, VehicleID need to … |
 | There are lots of stand alone programs (sqlitespy, sqlitestudio, etc) that give you nice spread-sheet style access to tables: [url]http://www.yunqa.de/delphi/lib/exe/detail.php/products/sqlitespy/sqlitespy.png?id=products:sqlitespy:index&DokuWiki=2oa8egb90q7fck3t3q2uk9nv61[/url] but does anyone know of a web based way to do this? Thanks, David |
| | Hi, I have created a system where users can follow another user, I am currently querying the table to display who is following who. I have two queries as shown below: [code=php] // followers query $query = "SELECT * FROM friends WHERE friFriend='$view'"; $result = queryMysql($query); $num = mysql_num_rows($result); // … |
| | My SQL isn't the best. Here's my situation: My table consists of three fields. I'll call them A, B, and C (for simplicity). For each A, there should be only one B-C combination. No matter how many times A is in the table, it should always have the same B … |
| | Can anyone help ? Im looking to find a MySQL query using regular expressions to allow me to remove any paragraph html tags within block quote tags. An example is : [CODE]<blockquote> <p>TEXT</p> </blockquote>[/CODE] Should be : [CODE]<blockquote> TEXT </blockquote> [/CODE] Thanks, |
| | Can anybody tell me what is wrong with these mysql statements? I believe the LIKE is what is incorrect. [CODE] $Find_Query1 = mysql_query("SELECT * FROM pages WHERE title='$Search' AND keywords LIKE '$Search' AND description LIKE '$Search' "); $Find_Query2 = mysql_query("SELECT * FROM pages WHERE title LIKE '$Search' AND keywords LIKE … |
| | Hi, I am trying to insert an image path name into mysql. I not sure how to insert the path only if the path name "image name" does not exist. Also, I get duplicate rows when uploading image path name, not sure why. Here is some code. Any suggestions would … |
| | [CODE] #include "SQL.h" const char * pQuery(const char * query,...) { va_list argptr; va_start( argptr, query); char buf[4096] = ""; sprintf(buf,""); int ret = vsprintf(buf + strlen(buf), query, argptr); strcpy(buf + strlen(buf), ""); va_end( argptr ); return buf; } [/CODE] [CODE] MYSQL * mysql; int main() { //loading the config … |
| | Hi I am running an jsp application thru which the values are saved in mysql. all values are saved twice.Pls help me how to avoid that |
| | So I'm creating a website for bar deals... I've tried for hours trying to get the url to take in more than one parameter with no luck, I don't know if my database isn't setup correctly or something but the url would look like this [url]http://www.site.com/?id=1&day=Monday[/url] and when those parameters … |
| | Another MySQL question I have (wish my SQL knowledge was better). I want to compare a column in one table to two columns put together in another table. For simplicity sake: Table A has columns X and Y, Table B has column Z. The values in X and Y put …  |
| | Hi All, I need some advise, pointers or ideas how I can tackle this problem of mine. I am running a front end php and backend mysql db. I could import my csv file from php to mysql db. However I was wondering if I could upload the csv file … |
| | Hi All I have creating a database table that will store configuration values so that php knows whether to show a field within a html form or not. I know that the PHP code connects to the table within the database as there are now errors when the webpage is … |
| | Hi there, I am having trouble with making an inner join whilst concatenating two of the fields. I can do both separately but have not yet mastered both at the same time. Here is what I have. It does work, however not in the intended way. It produces the only … |
| | I experiencing problem in executing query on between date command. I got wrong result. [CODE]SELECT approval_date FROM itemdetail WHERE approval_date BETWEEN '01/01/2011' AND '15/01/2011'[/CODE] My Record in Mysql Database: |Approval Date| 05/01/2011 10/12/2010 12/12/2010 15/12/2010 10/01/2011 |Result| Like above Need result |Approval Date| 05/01/2011 10/10/2011 Anyone could help me. how … |
The End.