10,940 Topics
 | |
| | 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 … |
The End.