10,940 Topics
 | |
| | Is it possible to copy a mysql database to an excel worksheet writting PHP code.. please help with code. |
 | I am new to SQL .. [code]SELECT status FROM statuses ORDER BY date;[/code] I know this will order by date but i want to alter the table and rearrange them by datestamp.. Is it possible to alter like that ? |
| | Hi!This is my 1st thread. I wanted to ask that I have a common table for clients.If client is given quotation, hes status is 1, if given invoice, hes status is 2 and so on. If i want to display only the clients who have received the invoice, I fire … |
| | I git this warning>> [CODE]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files (x86)\EasyPHP 2.0b1\www\HotelCalifornia\sites\reserve_room.php on line 85 Unknown column '' in 'where clause[/CODE] This is my code>> [CODE] <?php $user=$_GET['username']; $Custno=$_GET['Custno']; $RoomNo=$_GET['RoomNo']; $username="jasmine"; $password="price"; $db=mysql_connect("localhost" , $username, $password); mysql_select_db("hotel_cali", $db); $sql="SELECT Email FROM customer … |
| | hello guys.. I am new to php. May I ask if it is possible to store a mysql result into a single cookie..(the mysql result has multiple rows..).if it is possible, how to do it.. thanks in advance  |
| | 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 'reasons = '', birthplace = '' dob_month = 'January', dob_day = '' at line 8 Hello aLL I am developing an online registration form that … |
| | I have table names 'payroll' with following data month , pay January , 1200 March , 1500 December , 2000 I want the following result Janury , 1200 February , 00 March , 1500 April , 00 May , 00 June , 00 July , 00 August , 00 September … |
 | Hi all, I am transitioning a bunch of data from html (yuck!) to some sort of separated schema. I was going to use xml: [code] <events> <event> <title> <date> <speaker> <description> </event> </events> [/code] but now I am wondering if I should use a real database instead. Can anyone comment …  |
| | hello people . i am writing a login system for administers , so i made the login page with this code : [CODE] <?php ##################################################### # created by : Awah Mohammed # # date : 23/12/2010 at 23:15 pm # # haha , i like writing such stuff in my … |
| | Hi, I am having an issue saving images to a MYSQL database as a BLOB, I have been for a few days now, I have used several different tutorials and even though the code works with no errors returned, nothing actually get put in my database. Here is my form … |
| | Hi I am pretty new to all this so bear with me. I have created some forms on dreamweaver which I want to populate mysql database when completed. I have created a table using phpmyAdmin through godaddy. I have created a record set which links to each form field. I … |
| | Hello every one! I'm developing one simple site, and I need to make an "archive" script. My MySQL Table looks like: [CODE] | id | title | content | is_deleted | pub_date | [/CODE] *pub_date is in PHP time() format. Example: 1258150430 So, what I want to make is an … |
| | [CODE] #include "includes.h" MYSQL *con; con=mysql_real_connect(con, server,user, password, database, 0, NULL, 0); //mysql check: int act; int reb; reb=mysql_query(con,"SELECT * FROM cq_rebirth"); act=mysql_query(con,"SELECT * FROM cq_action"); if(act !=0 || reb !=0){ cout << mysql_error(con); return 1; } [/CODE] Error: Commands out of sync; you can't run this command now i …  |
| | Hi There I've been hammering my head with this for quite a while, and every solution I've tried didn't work, so I was wandering if you could help me with this. I've got a small div that is displayed for each record existing in the database, in order that, later, … |
| | Hi! I use a paginate feature on my website, it works great on the front page, but when I use it in the comment section I get this: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/56/6296656/html/comments.php on line 77 code: [CODE] $query = "SELECT where … |
| | |
| | Im not even sure if these are called variables. But I am trying to call information from the database a different way than I usually do. This is what is not working: [CODE]$id = mysql_real_escape_string($_GET['id'], $con); /* once the file is imported, the variables set above will become available to … |
| | Hi All: I have 2 php files feeding one MySql record. I have an INSERT query in file1.php working fine, it then sends me to a highly animated form file2.php that calls a processor.php file. The processor.php file needs to update the mySql record. I have [U]tested[/U] the processor file … |
| | I am currently trying to set up my Database for a small store. I would use something like Zen-Cart but I dont think that is necessary at this level. What I am stumped on is what cell setting within my products table would I put the actual paypal code in … |
| | Hi: I'm having an issue posting to MySQL using the animated_form.html below. My objective is to have 4 db entries posted to MySQL when the user clicks on the <a href="javascript: submitform()"><input alt="Show Results" id="btn_results" src="a_data/form_btn_show_results.png" type="image"></a> image. The form uses jquery and it produces 0 results in MySQL. Using … |
| | Hi, i am trying to connect to MySQL database [ICODE]mysql[/ICODE] using JAVA .. using code given below, [CODE]import java.sql.*; public class dbExample{ public static void main(String[] args) { System.out.println("Listing all table name in Database!"); Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String db = "mydb"; String driver = "com.mysql.jdbc.Driver"; … |
| | Okay, So I want an array to get userinformation by the username that is provided. But in the other tables, it only has a ID field to link with... [CODE]$sql = "mos_users.id as userid, block, username, email, lastvisitDate, firstname, lastname, avatar, cb_age, userip FROM mos_users, mos_comprofiler, mos_comprofiler_plug_iplog WHERE mos_users.username = … |
| | Hello, I made a PM system but the thing that makes it read isn't working. Can you take a look at it anybody? [code] $postid = $_GET['postid']; mysql_query("UPDATE pm SET read=1 where id=$postid") or die(mysql_error()); [/code] And it gives this error: You have an error in your SQL syntax; check … |
 | Hello )) Please tell me - How to receive surnames of students and their mark in all subjects? in this form -[CODE] SURNAME1 1hismark1 1hismark1 1hismark1 1hismark1..... SURNAME2 2hismark1 2hismark1 2hismark1 2hismark1.....[/CODE] I use this database - [CODE] table STUDENT ( STUDENT_ID NUMERIC not null, SURNAME VARCHAR(60), ); table SUBJECT … |
| | Hi,I,m taking mysql database backup through code behind,by using process.start method.It's taking backup but the problem is that after execution of process.start method,it's showing one command prompt for 2-3 seconds and executing.I dont want to show that command prompt.Please help me how can i do that?  |
 | Hi pals, I try a code in my Dev -C++ Environment v 4.9.9.2 in Windows XP. I save file as "satwant_mysql.cpp" in E:/C++/ Directory.... [CODE] #include <mysql/mysql.h> #include <stdio.h> int main(){ MYSQL mysql; MYSQL_ROW row; MYSQL_RES *result; unsigned int num_fields; unsigned int i; mysql_init(&mysql); if (!mysql_real_connect(&mysql,"localhost","root","","MyDatabase",0,NULL,0)) { fprintf(stderr, "Failed to … |
| | hello i have this in my code [CODE]$providers_offer=strip_html_tags($_POST['services_offer']); mysql_query("UPDATE providers SET providers_offer='$providers_offer' WHERE user_name='$_SESSION[provider]' ") or die(mysql_error());[/CODE] simple update on my data. my problem is if i type a data in my services offer. with this kind of characters ( sample's ) i got a syntax error on updating or … |
| | I have the database movies (movie_id INT, actor VARCHAR(80)) and i want to answer to this question ’Six degrees of separation’: Given two actor names, determine their ’degree of separation’, defined as 1 follows: Two actors ’A’ and ’B’ are 1-degree away if they played in at least one movie … |
| | I am new to php (sorry). I cannot figure out how to make 'field_4' below display as a click-able URL. It is stored in my mysql db in a varchar field. Any help would be great, thanks. [CODE] $result = mysql_query("SELECT * FROM units ORDER BY `field_1`, `field_2`"); echo "<table … |
| | [CODE] global $db; $tracks = ""; $sql = "select description from movies where movieid=".$movieid." and mp3link IS NOT NULL"; $db->query($sql); while ($db->next_record()) { $tracks .= "<p>" . $db->f("description") . "</p>"; } echo $tracks;[/CODE] This is a code I'm using to get all records from a database with a certain ID … |
The End.