10,940 Topics
 | |
| | Hi, If you see my other post about writing data to a file i am not doing that now i am using a database instead. Anyway .... Before i start i would like to say i am very very new to PHP and no very very little about MySQL writing. … |
| | Hi, I been having allot of help on here certainly from 'Josh Connerty', who has done a fantastic job of helping me. I am learning php and am enjoying it. So before i start a big thanks to Josh Connerty and this forum existing as it is a pleasure to … |
| | 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 … |
The End.