10,940 Topics

Member Avatar for
Member Avatar for alittle

I keep getting this error message 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 's Hits and had 24,000 listener sessions; over 30 days. Get 5 commercials a day' at line 7 <!DOCTYPE …

Member Avatar for alittle
0
248
Member Avatar for cubalibras

Hello all, I'm having a bizarre problem with the most basic of logins. I'm using a function to pass two parameters, just email and password but it just will not work and I can't understand why. I ran the query in the database and it returned a COUNT value of …

Member Avatar for cubalibras
0
146
Member Avatar for Stealthbird97

Ok, What i need is a Login script that will verify the information that is on a MySQL database. What people will do is sign up on a website and their Login information will be stored on the database. Then they will be able to login to a special members …

Member Avatar for Maligui
0
129
Member Avatar for mrbarbarik

Hi, I'm just want to ask if it's possible if I want to update multiple record with same condition at the same time. For example, I have a table named *userTable*, it has two field, *year* and *status* fields. On year *field*, it has value of years and on *status* …

Member Avatar for debasisdas
0
218
Member Avatar for confstu

Hello, a noob in web programming here. Doing some course related database, would appreciate any help :), I want to ask whether any of you can help me on how to retrieve get data from mysql using php function, but separate each data from mysql one by one, cause i …

Member Avatar for confstu
0
241
Member Avatar for hsthompson

Hi. I'm Mike, a developer in Los Angeles, working for a small company. Quick question: I want to write something that's potentially a contract job posting (at the company I work for), but really the project isn't defined well enough yet for me to be comfortable handing it off, saying …

Member Avatar for hsthompson
0
234
Member Avatar for rev_ollie

Hi, I have been looking at a few tasks I want to do using a MySQL DB and Python. Therefor I'm spending some time looking at the MySQLdb module for Python and how I can use it. I've worked out a few bits but I want to be able to …

Member Avatar for rev_ollie
0
8K
Member Avatar for cscheck

I need a bit of help understanding what I should do here. I have an .php page called view that has the following drop down form code in it. $sql = "SELECT DISTINCT dept FROM sw_lic WHERE dept != ''"; // (1) $result2 = mysql_query($sql); echo "<form action='NB_sw_lic/filter_view.php?$nt' method='POST'>"; // …

Member Avatar for fobos
0
242
Member Avatar for gacoekchip.pokher
Member Avatar for SunnySideUp

Hi, I am looking for a procedural PHP script that would allow me/my users to upload video content in a number of popular formats. I would also like all the information to be linked into a MySql database as well. I already have a upload script for uploading documents but …

Member Avatar for phpapprentice
0
1K
Member Avatar for moblyft

I have two pages one called upload-file.php, this page uploads the image into the database and my folder. My PHP page looks like this. if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $insert=mysql_query("insert into match_item_image set item_id='".$_SESSION["session_temp"]."', image='".$name."', adid='$adid'") or die(mysql_error()); $cc=mysql_insert_id(); echo "success".$cc; My other page consist of a javascript function which displays …

Member Avatar for rotten69
0
320
Member Avatar for gacoekchip.pokher

Hi all, Help me please. i have two table: outbox and contact. condition outbox table befor query/ insert. CREATE TABLE outbox ( id int(11) NOT NULL, phone_number varchar(30) NOT NULL, message varchar(200) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; Contact table: CREATE TABLE contact ( id int(11) NOT …

Member Avatar for pritaeas
0
238
Member Avatar for imarc

Hello all! I have hit a small bump in my development of a program I am working on. Basically what I need to happen is this; for each item in the listview it executes a SQL query to input values into a database. In this case it pulls the quantity …

Member Avatar for imarc
0
290
Member Avatar for moblyft

I have two pages one called upload-file.php, this page uploads the image into the database and my folder. My PHP page looks like this. if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $insert=mysql_query("insert into match_item_image set item_id='".$_SESSION["session_temp"]."', image='".$name."', adid='$adid'") or die(mysql_error()); $cc=mysql_insert_id(); echo "success".$cc; My other page consist of a javascript function which displays …

Member Avatar for Taywin
0
231
Member Avatar for showman13

Not sure the best way to ask this question, but here goes... I have a Database table that has a column called pos_id that is an auto increment field, and I have used it as a tracking device for the next position number in a company forced matrix system... Now …

Member Avatar for showman13
0
830
Member Avatar for modesto916

Hi, I'm writing a small C program to clean the radius radacct table, removing ended sessions records and inserting on a separated database. The problem is that MySQL C API doesn't have an easy way to insert the result of a query on another database/table directly, you have to build …

Member Avatar for modesto916
0
2K
Member Avatar for stupid guy

hi all, I am new to php and have started some coding.I want to insert values in one table1 and update values of table2. It worked for me last day..but today it doesnt work.I have hardly changed any code.i guess except fr deleting some comments in code..u plz tell me …

Member Avatar for gacoekchip.pokher
0
152
Member Avatar for iguanairs

I am trying to display my vbulletin usergroup ids for each user who posts an ad in my photopost classifieds. in doing this I can execute my code based on that usergroup id. I have been working on this for 3 days now and I just can't get it to …

Member Avatar for pritaeas
0
118
Member Avatar for tyson.crouch

Hey Guys, I've got a question that's gotten me stumped. Granted, i've been away from MySQL and daniweb for well over 18months, i've picked up pretty much where i left off back then, and am just filling in the blanks as i go along. **My question is:** i have a …

Member Avatar for tyson.crouch
0
124
Member Avatar for LastMitch

Hi I'm having issues with **get_magic_quotes_gpc()** function. I download this **Ajax File and Image Manager** from this site: http://www.phpletter.com/DOWNLOAD/ I install it on tinymce & fckeditor to test it out. They both work. I try to link the images and it didn't work and I also realizes the links are …

Member Avatar for LastMitch
0
265
Member Avatar for memccool

Ok so I have a script that I am writing and I have encounted a problem. I can not get the information from a dropbox to submit into mysql data base here is my script. <form action="work.php" method="post"> <table> <tr> <td>Email:</td> <td><input type="text" name="Email" tabindex="1" /> </td> </tr> <tr> <td>Messgae:</td> …

Member Avatar for broj1
0
295
Member Avatar for nova37

hello i want to add search functionality to my website . my task is to get input from user then check it if its domain like google.com then (do work 1).... else if keyword like news etc then search database so i made search.php mysql_query("SELECT * FROM `table` WHERE `title` …

Member Avatar for gabrielcastillo
0
207
Member Avatar for mevoohafez

I tried to insert data using the following code, but I really I don't know how can I get result and what is the problem in my code, I tried to build firstly my form then I write the insert query and send it to a new form , any …

Member Avatar for Squidge
0
317
Member Avatar for ceinoris

Hello i can not figure out how to take images from my database to jQuery gallery. User uploaded images in the data base. Images are sorted by date. And how I can do, what all imges goe's in the jQuery gallery, besause now i can get all imges in one …

Member Avatar for AleMonteiro
0
277
Member Avatar for opman234

Please help me. I want to connect to mysql using the connection string from connectionstrings.com. It gives me error that: format θƒ the initialzation string does not conform to specification starting at index 13. Please help me.... •̸ŤђαϞĸs ĩ̷̊ñ advance

Member Avatar for gusano79
0
96
Member Avatar for LRNPHP

Hi There, I'm busy developing a PHP / MySQL billing system for our company but can't seem to get the following working for me. I need to have 1 page that will display the extensions billing period / month for local, national and international calls and it needs to be …

Member Avatar for pritaeas
0
502
Member Avatar for Paul7575

Hi there, Can anyone help? Why is the following code displaying "P1P2P3..." etc, instead of "P1 , P2, P3 ,.." etc. ? Thanks Paul <!--Conect to database--> <?php include "connects/patientconn.php"; ?> <?php $query = "SELECT `Patient I.D.` FROM `patient`"; $result = mysql_query($query); while($patient = mysql_fetch_assoc($result)) { $pt = implode(" , …

Member Avatar for broj1
0
70
Member Avatar for jadzrev13

Hi Everyone, I am a beginner in PHP and would need your help with this. I get this problem: Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in database.php on line 207 Here is my code: include("constants.php"); class MySQLDB { var $connection; //The MySQL database connection var …

Member Avatar for ryantroop
0
339
Member Avatar for adishardis

I'm trying to get a flot graph to show my jsonencoded array seen below: [["aa",71],["ab",69],["ac",66],["ad",61],["ae",79],["af",78]] In the array the first is what i want on the xaxis and the second is the corresponding value. Right now my flot graph outputs an empty chart and I'm thinking that the array need …

Member Avatar for adishardis
0
1K
Member Avatar for logicaweb

I'm trying to make multiplication in web shop that will show real price: **discount * tax * product price * 1 piece= real price** But I just don't know how to do it, I try 1 million things, spend about 48h just to make it, but, without success, no matter …

Member Avatar for logicaweb
0
324

The End.