10,938 Topics
| |
Hai all, I have create a web page in php. I am retrieving the values from mysql database and showing as grid view on page. I want to take a print on paper upto only datagrid. What to do..? Please help anyone with code.... | |
I have mySQL 5.1 installed on a Windows Vista machine. I'm really curious as to where the file lives that holds the databases I created. I'm assuming it's in the mySQL install directory but I just don't know where (C:\Program Files\MySQL Server 5.1\?). Does anyone know? | |
Hey, I have the following query which I would like to insert into another table which I guess would demand some kind of loop or such. The query: [CODE]$colname_GetName = "-1"; if (isset($_SESSION['MM_Username'])) { $colname_Name = $_SESSION['MM_Username']; } mysql_select_db("db_name"); $query_Recordset = sprintf("SELECT * FROM Table WHERE UserName = %s", GetSQLValueString($colname_GetName, … | |
Hi, Everybody! I have one problem, I want to use same sql query in MySql and SqlServer. In case of Sql Server generally you have to write query in this way- select * from databasename.dbo.tablename but in case of MySql you have to write query in this way- select * … | |
| |
Hi. I am working on a php-mysql project. My table contains a field called "ID", which i have declared as teh PRIMARY key. but what i want is, that when the user tries ot insert record B into the table, an **ERROR message** should be displayed, showing that a record … | |
here is my problem i have a data base and i have one table named request_recommend(requestid,status,for_email,sender_email,receiver_email) and one named connections(mail,connected_mail,type_of_con,comment,dateOfJoin) and i want to create a trigger who does not allow to create request_recommendation tuple if the writer and the recommended is not connected i really do not how to … | |
Hello, I have this piece of code. [code=java] private Vector getColumn(ResultSet rs) throws SQLException { Vector row = null; ResultSetMetaData rsmd = null; boolean moreResults = rs.next(); if (moreResults) { row = new Vector(); rsmd = rs.getMetaData(); do { switch(rsmd.getColumnType(1)) { case Types.VARCHAR: row.addElement(rs.getString(1)); System.out.println(rs.getString(1)); break; case Types.INTEGER: row.addElement(new Integer(rs.getInt(1))); … | |
Hi! I want to know that how can i use buttons to update ( edit or delete) records from the php form directly into the database... Thanks | |
hi, i am a novice and have recently started practicing some php tutorials. there is this bit of code that involves HTTP authentication which makes sense up until this part: [CODE] // connect to database $dbc = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // grab the user entered log-in data $user_username = … | |
Hello, I have this piece of code. Help with Code Tags java Syntax (Toggle Plain Text) [code=java] private Vector getColumn(ResultSet rs) throws SQLException { Vector row = null; ResultSetMetaData rsmd = null; boolean moreResults = rs.next(); if (moreResults) { row = new Vector(); rsmd = rs.getMetaData(); do { switch(rsmd.getColumnType(1)) { … | |
Hi,all Here is the sql sentence i wrote on my php file. But when i test with it nothing show up which there should have some results?? My idea is :get the sw and ne point, choose every value live inside the rectangle in my database [CODE=php]//zips is my table … | |
this is the link i got it from: [URL="http://www.learnphponline.com/scripts/email-activation-for-php-forms"]http://www.learnphponline.com/scripts/email-activation-for-php-forms[/URL] this is the error im getting please also consider im n ew and dont know how to find the manual maybe it is a common known thing or something im asking anyways i wouldnt know waht to look for either its … | |
Hi there what i'm trying to do is: return a car manufacturer from a MySQL database and have the text returned a hyperlink to the car manufacturer website. The below just returns the manufacturer without a hyperlink: [B]$row['manufacturer'][/B] Would i make a row in the database called 'carmakeurl', store the … | |
i got this error: [code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\db.php on line 13[/code] my php code is this: [code=php] <?php //Database Info $dbhost="localhost"; $dbuser="root"; $dbpass="something"; $dbname="somedb"; $table="users"; //Connect to Database $con=mysql_connect($dbhost, $dbuser, $dbpass); mysql_select_db($dbname, $con); $user=$_POST['user']; $pass=$_POST['pass']; $query = "SELECT * FROM $table … | |
Howdy, I am trying to write a simple program in java that creates a database with some tables and adds some data, but I keep gettin this error: [CODE]java.sql.SQLException: No database selected[/CODE] I am posting the code below, it's really easy to understand. Please HELP!!! I am new at mySQL … | |
basically i want to be able to display an image from a mySQL database using PHP. I heard about this BLOB binary stuff & decided it was too complicated. How would i store a url so that i could access and display it directly in PHP. For example, would i … | |
Hi to all I need some help to write a java program to parse 2 text file one containing the details of the database and the other the data that will be used to insert in the tables of the database A sample for the first file : schema : … | |
Hi all ! I have been assigned a task to implement an insert query into table a [i] only if [/i] a record doesn't exist in table c. I have been scratching my head for past 2 days and even my best friend [i] google [/i] didn't help me much, … | |
I have been trying to format a date that I receive from a value in a mysql database. The format in mysql is as follows. 1986-08-02 I want to convert that to Aug. 2, 1986 I tried the date function in php and it was not working for me. Anyone, … | |
I apologize beforehand if this topic is in the wrong place. Quite honestly I am desperate for help. I have a project for school involving Firefox and making an extension that is a visual database. My professor suggested I use SQL Lite to make the database. I am so beyond … | |
hello i got this error while taking a backup in mysql usung mysql administrator Error Performing Backup: Could not open file for writing backup. what does it mean how can i get rid of it the error at last table to be backedup | |
I'm trying to create a form that updates a MySQL record when the user clicks a LINK, not a button. I don't want to open another page for this. There really isn't a need for me to post my code right now, as I'm trying to figure out how to … | |
hi all i would like to create a registration and login and selection database, css, mysqladmin. need lots of help.. thanx something like this for example.. I am/We are a: Man Woman Couple (man and woman) *Interested in meeting: a Man a Woman a Couple (man and woman) a Group … | |
I am new to PHP. I have a MySQL database with a column of URL's. I have a PHP script that randomizes the URL's and echoes the result to the browser. I just need a need a way to turn the randomized URL into a clickable link. I would imagine … | |
Dear Masters, I have a problem on comparing data. I have two databases that have a similar (if not same) tables, but holds different data, and I want to merge the two tables. But can't seem to figure the easy way to do that, again and again I use script … | |
Hi i'm trying to write a simple SQL command to use within PHP. I want to select the whole table, sort by one of the columns, then only display the top 100 rows. Without the[B] WHERE rownum <=10[/B] it works fine. But it displays the whole contents of the table … | |
i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ? [code]$query = "SELECT * FROM `users` WHERE … | |
how can i find size of my database what is the max table size in mysql is table size shown is in terms of kb or mb in mysql by default actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb … | |
hi im a newbie at this but im getting a error message that says: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pickurau/public_html/classes/Lib/Query.php on line 27 and line 27 starts with the if(!mysql_affected_rows() || mysql_num_rows($this->rs) < 1) return false; does anyone know how can i fix … |
The End.