10,938 Topics
 | |
| | How am i supposed to insert a word into a blank row? [CODE]$sql = "INSERT INTO ue-userfile WHERE id='$imageid' AND userid='$userid' (`albumname`) VALUES('$newalbum')";[/CODE] ? [CODE]$sql = " INSERT INTO `ue-userfile` ( ``, ``, ``, ``, ``, ``,``,`albumname` ) VALUES ('{$albumname}')";[/CODE] ? God damn annoying to not find any solution on … |
| | Ok, so what im trying to make is an authentication system that gives the user the pin. I have all currently generated pins setup in a mysql database that looks like this.. [img]http://img847.imageshack.us/img847/3621/databaset.png[/img] So now i need to display them, and then after its displayed on the page, i want … |
| | Hi I would be greatfull is somebody could help me. Ok vut a long story short I am trying to create a website which has the facility of a database driven banner system, on either left and right hand side of any page. the purpose of this is so that … |
| | [CODE]<?php $login = $_POST['login']; $nickname = $_POST['nickname']; $senha = $_POST['senha']; $email = $_POST['email']; $conexao = mysql_pconnect("localhost","rodrigue_incub","xxx24df") or die (mysql_error()); $banco = mysql_select_db("rodrigue_incubadora"); //Utilizando o mysql_real_escape_string voce se protege o seu codigo contra SQL Injection. $login = mysql_real_escape_string($login); $nickname = mysql_real_escape_string($nickname); $senha = mysql_real_escape_string($senha); $email = mysql_real_escape_string($email); $consulta = mysql_query("SELECT * … |
 | hi guys, I am developing a website, and it needs people to upload images. I can write code for single upload but not multiple, please help. Thanking you in advance! |
| | Hi, how can we reduce the time of query execution time? I m using mysql. I have to execute one query which select data from lot of tables . It takes more time to execute. Please give me good suggestion for this....... |
| | Hi, i'm trying to update a mysql table with values, and i get this error: Error: 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 'WHERE StockID= 23' at line 1. Here is my … |
| | hi I'm need changes in my code. I'm display records by search. but i want to export those search records into excel, PDF, and word format. I'm creating only export to excel format. but it exports all rows in entire table. i need only that searching records to export. See … |
| | Hi I am trying to display the records Horizontally from my 3 different table 1. place table - n number of place 2. Item name 3. Item in different place i want to display the above report as in the attachment. please help me to resolve the issue [CODE]<table width="100%" … |
| | Hi all been working on this for a couple of days. I want to upload 4 image names to the mysql database and upload the images to a folder on the local server. I also want to display my images that goes with the text data. So far I can … |
| | I restart a project of mine which use mysql, I used xampp in the past to test the code on the mysql server so I update to lasted version but a piece of code that is identical and was working, I now get an error in [U]the class check in … |
 | I am very new to php and mysql. I have read and re-read many forum posts on this subject, but I just cannot figure this out. I have been at it for almost two weeks now. This is my hope: Load images and captions from a database into an html …  |
 | I hope I can explain this. I have a table which contains a field named ID. This is set as PRIMARY. Because users registered on my site and after that deleted their accounts (so a lot of rows got deleted, too) the table rows now are jumping, for example, from …  |
| | I'm trying to create a form where I can type in a piece of news as I would normally type and include links in the form [CODE]<a href="www.google.com">google</a>[/CODE] and have it preserve the formatting and display the link as a link when echoing back. My problem is that despite a … |
| | New to PHP and need some help with this. I'm creating a test, but I'm getting all of my questions randomly from my database. For example, if this is my table: ID S Q1 A1 A2 1 C Why A B 2 F When A B I know that I … |
| | Hello! please i need help with this,after sumiting my form i get this error message on line 111 any help i will appreciate, thx [CODE]<?php session_start(); include("../Connections/recruit.php"); echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; //check certification $certification = $HTTP_POST_VARS['certification']; if($certification != "accept") { echo(" Your application has been terminated as a result of … |
| | I have the following code. [CODE]$result = mysql_query("SELECT * FROM topics LEFT JOIN quiz ON topics.managerId = quiz.managerId WHERE quiz.userId = '$userId' AND userId= '$userId' AND $egroup = 1 GROUP BY topics.title")or die(mysql_error()); while ($row = mysql_fetch_array($result)){ echo "{$row['quizId']} <br />\n"; echo "{$row['title']} <br />\n"; echo "{$row['passState']} <br />\n"; } … |
| | please tell me how to convert a sql file which contain a table into .csv file in sql please tell me whether there is any c program to do this conversion or any other program insql for doing this |
| | Hi I am trying to write a stored procedure which will execute a query and if resultset is not empty results will be inserted into a table passed as the second parameter to the procedure. Below is what I wrote but I am having error with declaring the cursor, any … |
| | I've just removed and reinstalled mysql on my Amazon EC2 server. When I went to change the root password on the new install: sudo /usr/bin/mysqladmin -u root password 'MYNEWPASSWORD' I get an access denied error: error: 'Access denied for user 'root'@'localhost' (using password: NO)' Has it held onto the old … |
| | Hey everyone, PHP and MYSQL newbie here.....can really use your help right now. I implemented a Submodal into my script, and finally got it to submit "User Notes" into the database. Unfortunately with each new submission, the text that is submitted overwrites the previous submission. I was told to use … |
| | I was wondering if anyone could point me what coding feature I'm talking about that can fulfill this role. - So I need to update data values from many users at the same time at a specific X amounts of time or specific hours of the day. What programing process … |
| | Hi, Hoping someone can help with a query I'm stuck on. I've got a field (sm_contact1number) containing phone numbers. Some of the data has been imported via Excel and its stripped some of the 0's out of the start of telephone numbers, so 0121 3324234 now looks like 121 3324234.. … |
| | I need a pvp system and tutorial please XD it is simple... just a turn based pvp system help pls :P |
| | Can you all tell me the difference in these 2 codes? I'm trying to learn JQuery and ive seen this code below in the tutorials. [CODE] $DB->Query("Select * FROM time"); [/CODE] I'm use to coding queries like this. [CODE] $res = mysql_query("SELECT timestamp, name FROM time ORDER BY timestamp DESC"); … |
| | Hi, When a SELECT query is executed does MySQL store the resultset in some table? If it does, is there a way to find out that table and access it later before the session is closed? thanks, |
| | Hello folks, I'm having a bit of a nightmare getting a particular query to work the way I want it to. I have two tables; One for a catalogue, another for customer orders (which will always be items from the catalogue) What i'm trying to achieve; A query that will … |
| | hi all, for example. this is my mysql query result. A | B | C --------- a1| a2| a3 b1| b2| b3 c1| c2| c3 d1| d2| d3 i want to print the result like columnwise as following. a2|b2|c2|d2 Any suggestions please....  |
 | How can i select a data (any location) from Google map and also i want to store that data in database in order to list that contents in another page... Please provide me the idea,explanation and code.. Thanks |
 | Dear all! I have a final year project on Google maps. The aim of the project create a map for a farm land in a city and to read the data to be displayed on the maps from a database. But the thing is I need someone who has done … |
The End.