10,939 Topics

Member Avatar for
Member Avatar for lloydsbackyard

how do retrieve the last record if its id or other fields are unknown...or simply i need to move the record pointer to the last record in a table...thanx a lot... SELECT * from stud_infos WHERE stud_id = 'HOW DO I DO IT?'

Member Avatar for lloydsbackyard
0
389
Member Avatar for extemer

well guys hello i am bit confuse on my way...i up to a project for my university and designing a database system for a school...the problem is i am uploading images and and i set the image type as blob in mysql db but one of friend suggest me that …

Member Avatar for debasisdas
0
96
Member Avatar for sherinpoulose

how to populate treeview from multiple columns of sql data table I have attached my sql table here.from that table,i have to populate a treeview of the below form; -outlook ---------overcast -----------------------------yes ---------rainy ----------------wind ----------------------strong ------------------------------no ----------------------weak -------------------------------yes ---------sunny ---------------humidity ------------------------high --------------------------------no -------------------------normal ---------------------------------yes. It is readable like this; if …

Member Avatar for debasisdas
0
171
Member Avatar for pickett65

I have a script that reads all rows from a database, and prints it out to an html table. The html table has an extra column for "status".In this column there is a form that is supposed to submit the dropdown field to the mysql database. I've got the set …

Member Avatar for pickett65
0
142
Member Avatar for observ

Hi, I am trying to update data from a column in a database using a php script. But for some reason it doesn't update the database, but i get no error feedback. So first i select a random entry from the database and i add it as a parameter to …

Member Avatar for Stefano Mtangoo
0
883
Member Avatar for heshanm

The below line generates this error. Can anyone gives me a solution Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\MySite\php files\approve_page.php on line 25 [CODE] $query = "UPDATE transaction SET approved_status='1' WHERE account_number='$account_number' AND tran_id='$_POST['tran_id']'"; [/CODE]

Member Avatar for heshanm
0
125
Member Avatar for dennysimon

hello all how to use mysqldump in my project I see an example : MySqlDump my_dump=new MySqlDump(); but it seem need some reference or something,and won't work without it what should I add to make it give no error' thank you denny

Member Avatar for thines01
0
54
Member Avatar for b89smith

I have a table with entries for different accounts and each account has different products listed in it with a date next to each entry. An example of the structure is below. Account | Product | Holding | Date A1 | Car1 | 2 | 2010-12-31 A1 | Car2 | …

Member Avatar for Ezzaral
0
172
Member Avatar for cjohnweb

Hello all, I've a seemingly simple question, but it's kind of got me thinkin there might be a "proper" way to accomplish my goal. My goal is a simple MySQL database schema install. In PHPMyAdmin I export a database, any database. I then save the file to the root directory …

Member Avatar for cjohnweb
0
285
Member Avatar for Coyx

Hi everyone, My second time back to Daniweb looking for assistance with PHP. :) Okay, here's my PHP, and I'll explain what it does. [CODE]dbConnect(); if ($userclient == '2438') { dbOpenDatabase($GLOBALS['res_2438_contacts']); } else { dbOpenDatabase($GLOBALS['db_contacts']); } /************************************************ * THE IMPORTANT BITS - CHANGE BELOW * ************************************************/ //Product ID for Safety …

Member Avatar for Coyx
0
233
Member Avatar for tatarao25

Hi all, [INDENT] i am facing a serious problem working with MySQL and Nhibernate 2.1.2.4.0 named queries. I have written a stored procedure and i am calling it in C# using a flat class to map the database fields. My problem is it seems to work fine with Mysql 5.1 …

Member Avatar for tatarao25
0
141
Member Avatar for silvercats

CREATE TABLE `employee`(`employee_no` CHAR(4) NOT NULL,`emp_name` TEXT,`employee_sal` INT NOT NULL,primary key (employee_no); << I typed this and it says there is an error (see below).I can't see what is it.000webhost.com Mysql server [CODE]Error SQL query: CREATE TABLE `employee` ( `employee_no` CHAR( 4 ) NOT NULL , `emp_name` TEXT, `employee_sal` INT …

Member Avatar for silvercats
0
82
Member Avatar for atfOnly

I don't know what's wrong with this code. I think this code should work. I'm about to store number of each query in array [CODE] $antecedent=array(); for($i=0;$i<=$index;$i++){ if(isset($period[$i])|| isset($gpa[$i]) || isset($antecedent[$i])){ echo $period[$i]."&nbsp;"; echo $gpa[$i]."<br/>"; $queryAntecedent=mysql_query("SELECT * FROM mytable WHERE study_period='$period[$i]' AND ipk='$gpa[$i]'") or die (mysql_error()); $antecedent[$i]=mysql_num_rows($queryAntecedent); }//endif }//endfor print_r …

Member Avatar for Insensus
0
99
Member Avatar for mcwebalizer

Of course, Yesterday I ask for help for my google map route creator. And of coure, I made my google maps route creator source. [code] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Google Maps</title> <script type="text/javascript" src="jquery.js"></script> <script src="http://maps.googleapis.com/maps/api/js?sensor=false"></script> <script type="text/javascript"> …

Member Avatar for mcwebalizer
0
1K
Member Avatar for oinkpink

Hi, i need help , i wanted images to be for instance 4 in row, before it goes on to the next row, and below the images i wanted a title there. This are my work so far, but i just cant get to what I wanted, i've been searching …

Member Avatar for oinkpink
0
4K
Member Avatar for mynameissiva

hi folks, Here i face problem in my webpage [servlet + mysql] Connection are working fine. But when running time it get download the page instead of display the content in the browser. I try myself so many time, cant sove it.. plz guys help me to overcome this problem. …

Member Avatar for mynameissiva
0
252
Member Avatar for mrbungle

So I have a text box in a form. The test box needs to take the value entered and insert it into a column within a row in MySQL. I know it's connecting to the MySQL online, I have a message box telling me so upon a successful connection. I'm …

Member Avatar for mrbungle
0
270
Member Avatar for lastgame2007

it doesn't have any error but also i does not update in my database? [CODE]<head> </head> <?php include('connect.php');?> <body> <?php mysql_select_db("dbusers",$connection); $result=mysql_query("UPDATE tblinfo SET idno='$idno', name='$name', address='$address', birthdate='$birthdate', contact='$contact', email='$email' WHERE 'index'='$id'"); $result = mysql_query($update) ?> </body> </html> [/CODE]

Member Avatar for kurtopia
0
328
Member Avatar for Lius

[CODE]<script type="text/javascript"> function populateHarga() { var x=document.getElementById("barang").value; document.getElementById("harga").value=x; var y=document.getElementById('barang')[document.getElementById('barang').selectedIndex].innerHTML; document.getElementById('nama_brg').value=y; } function populateTotal() { var y=document.getElementById("jumlah").value; var x=document.getElementById("harga").value; document.getElementById("totalnya").value=x*y; } </script> <body> &nbsp;<p> <?php mysql_connect("localhost","root",""); mysql_select_db("stageco"); ?> <table border="1" cellpadding="0" cellspacing="0"> <?php $nama_b=$_GET['nama_brg']; $harga_b=$_GET['harga']; $jumlah_b=$_GET['jumlah']; $total_b=$_GET['totalnya']; if($nama_b!="") { mysql_query("INSERT INTO temp('t_nama','t_harga','t_jumlah','t_total') VALUES('$nama_b','$harga_b','$jumlah_b','$total_b')"); } $result=mysql_query("SELECT * FROM temp"); $i = …

Member Avatar for Lius
0
210
Member Avatar for asif49

I'm a bit new to this so excuse my noobness. For the website I'm working on - I'm wondering about whether information like images, uploaded files, date of birth, edited details etc. can all be displayed on the same page (specific to the user who has logged in, not everyone …

Member Avatar for asif49
0
142
Member Avatar for JukesK

Im in need of big help... (sorry bout the size of the post :$) Im just getting started in databases and need some magic.... Im running on the server; * Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 * MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $ * …

Member Avatar for d5e5
0
170
Member Avatar for pritesh2010

hello everyone , I'm facing a problem in inserting data in TEMPORARY table. i can do it by simple query easily. but i want to do through [CODE] for Ex. i have bunch of query which i'm executing through SET @QueryText="Select ID from employees limit 5"; //it contains bunch of …

Member Avatar for pritaeas
0
215
Member Avatar for the_carpenter

Hi... I've been doing ASP.Net for years, but I am very new at PHP. I need to redirect a user to a specific page based on the refereeing page. There's no way to calculate what the page should be so I figure I would have to use MySQL and look …

Member Avatar for chrishea
0
188
Member Avatar for geekme
Member Avatar for debasisdas
0
108
Member Avatar for anand01

Hi all, am using eclipse IDE.I want to connect mysql database with jsp/servlet for that i want to add mysql j/ connector. I added properties -> Java build path-> Add External jar file but still it calls the exception Driver not found "com.mysql.jdbc.Driver". Am not filmier with Eclipse any one …

Member Avatar for anand01
0
148
Member Avatar for Arthi Raman

hi, I need a query to get the start date and end date of a month when given the month name. For eg., When given month='august' it must display 01-08-2011 to 31-08-2011 Thanks.

Member Avatar for debasisdas
0
86
Member Avatar for Cuchara2

I'm trying to make a postback script which works with a CPALead widget, however it does not seem to work. I do not think my code is wrong (which I have attached at the bottom) so I was beginning to think this was not possible due to the fact that …

0
59
Member Avatar for Gerbiler

Recently I have been working with Mysql and PhpMyAdmin a lot on Ubuntu, and I have stumbled across a very annoying error, or set of errors. I keep on getting a bunch of random loosely related error messages. These are the errors I get. When I try to log in …

Member Avatar for griswolf
0
533
Member Avatar for Miklo_jan

[B]Hi guys, Well I just reinstalled vBulletin 3.8.6, on top of the other. I tried to make a new THREAD, after posting it says:[/B] ___________________________________________________________________ Database error in vBulletin 3.8.6: Invalid SQL: UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts); MySQL Error : Unknown column 'newposts' in 'where clause' …

Member Avatar for pritaeas
0
380
Member Avatar for Zedith

Must need coffee or something :/ Cant figure this out. I have a table with following info: [CODE][B] unique_id block_id column_id order_id user_id[/B] 1 block-1 column-2 0 1 32 block-2 column-3 0 7 7 block-1 column-1 0 2 8 block-2 column-2 0 2 10 block-6 column-2 1 1 11 block-7 …

Member Avatar for Zedith
0
243

The End.