10,940 Topics

Member Avatar for
Member Avatar for mrhankey

hi, looking for some tips, using dreamweaver as my tool and wondering if someone could help. i basically have 2 tables. 1 which is partsused and the other stocklevels. the stocklevels contains stock details and also if it is in the van or unit. on my page i have an …

Member Avatar for facarroll
0
1K
Member Avatar for ray@lauray.net

I'm using Microsoft tags to get the cell phones unique "did' number loaded into a htm form field. The customer is then asked to enter thier email address on the form. The form is then submitted to be added to our customer mysql database. If it's new it is added …

Member Avatar for ray@lauray.net
0
243
Member Avatar for Sorcher

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 …

Member Avatar for Sorcher
1
79
Member Avatar for G&G Designing

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 …

0
69
Member Avatar for mhaselip

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 …

Member Avatar for mhaselip
0
129
Member Avatar for Helinxed

[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 * …

Member Avatar for karthik_ppts
0
269
Member Avatar for moerpheus

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!

Member Avatar for nagarjuna.king
0
242
Member Avatar for Mr.Ram

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.......

Member Avatar for mwasif
0
801
Member Avatar for azhpool

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 …

Member Avatar for ddymacek
0
3K
Member Avatar for vboopathicse

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 …

Member Avatar for vboopathicse
0
161
Member Avatar for rpv_sen

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%" …

Member Avatar for rpv_sen
0
2K
Member Avatar for bow103

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 …

Member Avatar for bow103
0
377
Member Avatar for Deathmachine

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 …

Member Avatar for Deathmachine
0
165
Member Avatar for Ootred

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 …

Member Avatar for cereal
0
392
Member Avatar for RobotFX

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 …

Member Avatar for debasisdas
0
86
Member Avatar for karl.jackson87

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 …

Member Avatar for urtrivedi
0
203
Member Avatar for cleecaldwell

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 …

Member Avatar for P0lT10n
0
161
Member Avatar for bluetoot

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 …

Member Avatar for satyajit das
0
397
Member Avatar for facarroll

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"; } …

Member Avatar for Mikav6
0
112
Member Avatar for raunakanand

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

Member Avatar for debasisdas
0
48
Member Avatar for alenD

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 …

0
75
Member Avatar for benkyma

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 …

Member Avatar for benkyma
0
136
Member Avatar for bizfreak22

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 …

Member Avatar for urtrivedi
0
437
Member Avatar for Deathmachine

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 …

Member Avatar for Deathmachine
0
77
Member Avatar for minart

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.. …

Member Avatar for minart
0
158
Member Avatar for omnee

I need a pvp system and tutorial please XD it is simple... just a turn based pvp system help pls :P

Member Avatar for omnee
0
52
Member Avatar for RazorRamon

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"); …

Member Avatar for P0lT10n
0
152
Member Avatar for alenD

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,

Member Avatar for b89smith
0
103
Member Avatar for raoot666

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 …

0
56
Member Avatar for DILO3D

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....

Member Avatar for IIM
0
113

The End.