10,946 Topics
 | |
| | 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 … |
| | I want that mysql data will be in one row but it doesn't, in my case data echoes in a right down side :( [URL="http://lashatt.comoj.com/php+mysql.php"]http://lashatt.comoj.com/php+mysql.php[/URL] [IMG]http://lashatt.comoj.com/mysqlproblem.JPG[/IMG] [CODE=php]<?php $user="a7247794_a724779"; $password=""; $database="a7247794_testdb"; mysql_connect("mysql5.000webhost.com",$user,$password); @mysql_select_db($database) or die( "Unable to select database"); if (isset($_POST['saxeli'])) echo "saxeli {$_POST['saxeli']}"; $a = $_POST['saxeli']; $query = "INSERT INTO … |
| | First of all i'd like to say hello to everybody. I've been working upon a script and i seem to be facing a problem with a mysql_query. Here it goes: I have 2 tables on my data base and there are some html forms through which tha data is entered …  |
| | i am writing a program and i need to increment a table row. How would i increment a table row on the click of a button? |
| | First of all i'd like to say hello to everybody. I've been working upon a script and i seem to be facing a problem with a mysql_query. Here it goes: I have 2 tables on my data base and there are some html forms through which tha data is entered … |
| | Hi All, I have made a dynamic form details content table where the data is storing by comma separated values.All the form fields are stored as dynamic in the table. Fields : [CODE]n1_First_name,n2_bank_aaccount,piriod_to,n5_comments_by,n6_like,n7_comments[/CODE] Data: [CODE]nil@nil.com,test1,4-May-2010,test2,no,abc nil@nil.com,test1,4-June-2010,test2,no,abc[/CODE] Now as you see this field "piriod_to" refers to 4-May-2010 and 4-June-2010.....till now its … |
| | I am new to this so please excuse any errors but does anyone know why... I have a function which is called and 3 arguments passed [CODE] identifychannel(centre_code, company_class, stock_type) [/CODE] the function tests centre_code to return channel and where appropriate 'else' tests another argument. problem is this... If I … |
| | Hi, I have tried to Google this but cant find anything. I want to use a select AS statement to select multiple columns. i.e. [CODE]Select unitno country price AS propertyref[/CODE] is this possible using multiple columns AS one reference? many thanks |
| | I am creating a website that is going to allow customer's to view photography on the site and purchase it when selected for download. I have created all the php and mysql to be able to display the data correctly. But... to display the search results or recordset, how do … |
| | i have a register and a log in page and it will not work. Here is the script for the register:[CODE]$myusername=$_POST['user']; $mypassword=$_POST['pass']; $cleanpwd=md5('$mypassword'); $myusername = stripslashes($myusername); $cleanpwd = stripslashes($cleanpwd); $myusername = mysql_real_escape_string($myusername); $cleanpwd = mysql_real_escape_string($cleanpwd); $sql="SELECT * FROM $tbl_name WHERE email='$myusername' and password='$cleanpwd'"; $result=mysql_query($sql); $count=mysql_num_rows($result); if($count==1){ setcookie('username', '$myusername'); setcookie('password', '$cleanpwd'); … |
| | Hi, I have a successfully working system at the moment where a user can choose a file and upload it to my MYSQL database as a BLOB, but before the image gets saved as a BLOB I want to resize it. I have been giving this a try by using … |
 | Im new at PHP but learning fast, I need help on getting the mysql result into the $imagedir value [CODE]//Select Query for images from db $query="SELECT id, fld_imagename FROM tbl_banner"; $result = mysql_query($query) or die(mysql_error()); //Loop to get path from query while($row = mysql_fetch_array( $result )) { $mydir = "imge_uploads/".$row['fld_imagename']. … |
| | i have two tables like this i want retrive cname from person where cid duplicated at per_db and did at per_db=$value i want sql statment return "wael" from person person cname | cid ----------- gamal | 1 wael | 2 samy | 3 ------------- per_db cid | did ---------- 1 … |
The End.