18,960 Topics
Hi! I've been thinking about how to get this idea work: I have a table in my page. Four columns and several rows. Columns are (1) a product name, (2) how many needs to be purchaced, (3) how many already have been purchased and (4) a submit button which should …
Well this is my register form, it all worked fine before but for some reason it isn't inserting anything into the table, all of my other scripts that insert items into a table. A quick reply would be nice :) thank you. Here is the Register Script: [CODE]<?php $title = …
Hey people hope you are well Could You please help me. I am designing a system which when users login i want the system recoginse who is a admin and a user ( option of deleting only to admin) Using mysql and vb.net Thank you in advance
Hi everyone, I am wanting to know if there is such a thing like the mySQL SELECT WHERE but in array's. I have this array: [CODE]<?php $array = array( [1] = array( ['test'] = '1', ['test2'] = '2' ); [2] = array( ['test'] = '4', ['test2'] = '2' ); ); …
hi everyone.. can anyone help me please.. i have a datagridview with 4 columns (id, name, ticket_number, destination), i just want that datagridview on column "ticket_number" to display ticket_number from mysql database and another 3 columns for user input. thanks in advance..
Hi, I'm attempting to design a database for a practice online store, I have never been taught databases and how to design them but I have watched a lot of videos explaining them, I have attached a screen grab of what it looks like at the moment, could anyone please …
Hello everybody, i learned the basics of php a while ago, and as a first project, i want to create a website where anybody can rate pictures or upload his own. The hosting isnt a problem, i want to know if a db is necessary, if its i will have …
Hello, currently, what i want to do is, add a column in a table "default" during runtime. Well, I've got that covered already. The problem is, the column names are actually taken from the users input through a textbox or drop down list and of course, if the same column …
I need dropdown menu with this options, just each of them have to show data from base where is = location [CODE]<p>Mesna zajednica <select name="mesto"> <option value="donji_grad">Donji Grad</option> <option value="karadjordjev_dud">Karadjordjev Dud</option> <option value="plavinac">Plavinac</option> <option value="seone">Seone</option> <option value="ladna_voda">Ladna Voda</option> <option value="lestar">Lestar</option> <option value="zlatno_brdo">Zlatno Brdo</option> <option value="slavija">Slavija</option> <option value="papazovac">Papazovac</option> <option value="carina">Carina</option> <option …
I would like to retrieve the ID number for that row that was just inserted into the database. [CODE]Dim Enrollment As New Enrollments With Enrollment .Student_ID = CInt(lvwStudents.FocusedItem.Text) .Enrollment_Date = CDate(dtpDate.Text) End With EnrollmentBAL.Save(Enrollment) [/CODE] I have this code to save it from the database, what I want to do …
Hi all, How can I make this nonsens i have written work? I have 2 tables, one containing the urls I need to echo out in links - But I am not echoing out all of them. First I have to check in another table if there are any products …
change password.php [CODE] <html> <head> <title>Change Password</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="pwd.css" rel="stylesheet" type="text/css"> <link type="text/css" href="menu.css" rel="stylesheet" /> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="menu.js"></script> </head> <body> <style type="text/css"> #menu { top:5px; margin:0 auto; width:80%; left: 40px; } #copyright { margin:100px auto; width:80%; font:12px 'Trebuchet MS'; color:#bbb; text-indent:20px; padding:40px …
Hello there, anyone can help me with my problem? my problem is, i want to display a "please complete all the fields" when the user inputs incomplete data in the textboxes and i want to display it in the same form. im new in php. These are my codes [CODE]<?php …
I have two relation table and I've made a php sql query out of it ... What I need is to insert the sql result into a new database table... Anyone ? this is my code [CODE]<?php $con = mysql_connect("localhost","sample","sample"); if (!$con) { die('Could not connect: ' . mysql_error()); } …
Hi, I store images in my MYSQL database. I need to retrieve that image to my jsp along with datas.Response.write() function only displays the picture and not the data. How to do that?
I need some ideas in regards to the database management of the email alerts that my website is sending out. [url]www.gubbit.com[/url] My website sends out deal alerts of the products on deals everyday. Typically a product deal stays ON for 3-4 days and my script is sending the same deal …
Hello,i have the following html page. [CODE]<html> <head> </head> <body> <div class="container"> <div class="8"> <?php $firstname['1']; ?> </div> <div class="8"> <?php $firstname['2']; ?> </div> <div class="8 last"> <?php $firstname['3']; ?> </div> <div class="8"> <?php $firstname['4']; ?> </div> <div class="8"> <?php $firstname['5']; ?> </div> <div class="8 last"> <?php $firstname['6']; ?> </div> …
I am developing a website that will host lots of user information. Things like avatar images, personal information, information about the users skills, etc. I will also be implementing a forum at some point. I am using a MySql db just to be clear. Ok now, I need some ideas …
Hi, I'm trying to sort out the names from the database based on the first letter by using (addr WHERE LIKE 'A%'). This gives me the following error message: [B]Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in...[/B] Does anyone know what’s wrong here? Everything works great when …
Hello to all, before begin i must say that I'm sorry for my bud english and hope that it not be a problem for understanding whit you. I'm looking for a solution to create a simple background server application that running and live over infinite loop cicle, whit have the …
Hi about 7 days am experiencing this problem if you can help me out this is the code; it's not updating at all it's just redirecting me to the page this is my code [CODE] function editcat($cid,$catname,$catdesc,$ok=false) { global $db; $id = intval($cid); $result = $db->query("SELECT * FROM category WHERE …
i've a problem with deleting record from datagrid. i have few columns in my datatable and all publish on to a grid and under "ID" column there are id nos and they are "NOT" unique. user able to search using this "ID" no. problem comes in deleting records since the …
I am using a select statement for selecting certain rows of database table. the statement returns multiple rows. please guide me how can i store all the rows so that they can be used latter for comparison. each row contains one variable of type string... I was using string user …
I want something like how facebooks wall works but when i call what others have posted its out of order with time for example: First Table (Users): UserID: 1, Name: Matt, UserID: 2, Name: Bob, UserID: 3, Name: Steve, Second Table (Friends): UserID: 1, FriendUserId: 2 UserID: 1, FriendUserId: 3, …
Suppose fields: id, uname, ufullname, upass, uemail I would like to add an option for users to update there profile. Users will update profile which make changes without reloading page. Every field will show once user clicked on Update profile. My needs little different than others tutorials i have searched …
I'm making a SAMP server, with all the info of bans and bought vehicles in a MySQL database to get easy acces to it and to change it easily. But setting it up wast that easy :/ Here is the MySQL info, can some1 please help me here? [CODE=php]-- phpMyAdmin …
<?php session_start(); if(isset($_POST['next'])){ $a=$_POST['a']; } if(!isset($a)){ $a=0; } $q = $_SESSION['q']['a']; include('dbconfiguration.php'); $sql1="SELECT * FROM question WHERE question_id='1' LIMIT 1 OFFSET 0 $q"; $result=mysql_query($sql1); echo $sql1; echo "<form method='post' action=''>"; while ($row = mysql_fetch_array($result)) { echo $row['Question']. "<br/>"; echo "<input type='radio' value='answer1' name='answer'>" .$row['optionone']; echo "<input type='radio' value='answer1' name='answer'>" .$row['optiontwo']; …
Hey there I try to find how many times a person did order and what is the day difference between it (second step): Table is called eshop_flat_sales_order customer_email created_at status a(at)a.com 12.1.10 complete b(at)a.com 14.2.10 cancelled c(at)a.com 16.1.10 complete a(at)a.com 18.1.10 complete c(at)a.com 18.1.10 complete b(at)a.com 20.1.10 complete Now I …
On days when my site gets a lot of traffic, I get this error message... Warning: mysql_connect() [function.mysql-connect]: User OH_admin already has more than 'max_user_connections' active connections in D:\Inetpub\vhosts\ourhometown.ca\httpdocs\includes\all.oh.front.inc.php on line 3 User OH_admin already has more than 'max_user_connections' active connections Can someone point me in the direction in how …
helooo.....i'm developing a login page currently...and i'm getting tis particular error...i have look it up on the net, changes were made....but still can't find a solution to this problem...i would be grateful if you guys could help me.. [CODE] <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // …
Greetings to the Community, I need some assistance with a MySQL query that is running very slow. I must admit that I am not a MySQL expert and I wrote this query with hints from several postings on Daniweb, so I'm looking for some hints to speed it up. Here's …
I intend to maximize the use of space on my web page, so I have decided to use Spry Tabbed Panels. However, problem is that Whenever I submit data on one panel to a mysql database, the second panel submits itself too. I want to deal with the data on …
I have this error appearing Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /websites/123reg/LinuxPackage21/th/er/ag/theragereport.co.uk/public_html/feed/feed_view.php on line 148 from this code [CODE]$sql3="SELECT view FROM $tbl_name2 WHERE id='40'"; $result3=mysql_query($sql3); $rows=mysql_fetch_array($sql3); $view=$rows['view']; // if have no counter value set counter = 1 if(empty($view)){ $view=1; $sql4="INSERT INTO $tbl_name(view) VALUES('$view') WHERE …
I have create in MySQdb a DB with a table named example,in this table i want to save a name, this name is in Greek language.My problem is thw follown when i try to save the name instantly without use textctrl, its ok but when i use textctrl i take …
Hi all, I've been using this type of code to pull out a single value from my SQL database but I can't help thinking that there's a simple command I'm not using: [CODE] strSQL = "SELECT MAX(Stage) FROM Visits WHERE ScheduleRef = 22" FinalStage = dl.getPRISMdata(strSQL).Tables(0).Rows(0).Item(0)[/CODE] [CODE]Public Function getPRISMdata(ByVal strSQL …
Hi, I want to only compare with a distinct value in a join across two tables. I am bulding a navigation, based on what gets returned (Based on how many "brand_id" is found in the join.) - I just only need to know if there is ONE brand_id of a …
hi every1 i m new to website development. just learning it. i have made a code in which i access my database(MS Access). i m able to print the first record of the database on the page. but i m not able to go to next record which i want …
Hi, My products (records) are selected with a number of pages. Then I use navigationbuttons like first | next | previous | last, to the next or the previous. like [CODE]<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>"> <input name="faktura_datum" type="text" id="faktura_datum" value="<? echo $date; ?>" /> First</a></strong></span></span> | <a href="<?php …
Hello.. I would like to know if this is possible. Which I assume YES it is possible. Since I add column (CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP), so I want to pulling the data from mysql table out to html php table filtered by the current time on the machine (computer system). …
I really dunno wats wrong here. the firts query works but the second does not . please help... There a these connected files: save.php [CODE]<?php include_once("classes/jewelry/item.class.php"); $inum = $_POST['ItemNo']; $i=new item(); $i->ItemNo = $inum; $i->ItemName= $_POST['ItemName']; $i->CapitalPrice=$_POST['CapitalPrice']; $i->SalePrice=$_POST['SalePrice']; $i->Category=$_POST['Category']; $i->Description=$_POST['Description']; $i->save(); include_once("classes/jewelry/stock.class.php"); $j=new stock(); $j->ItemNo = $inum; $j->NumStored= $_POST['Nload']; $j->NumSold= …
I'm trying to do an insert into my order_item table, but I'm getting this error. Can someone help with why this is happening. Thank you. My sql code to create the tables is below. [CODE] drop table IF EXISTS order_item, orders, customer, product; CREATE TABLE customer ( id INT(10) NOT …
How do I promote myself by my website (snipped) e. g. that I can design a database using PHP and MySQL?
Hello there, can anyone can help me with my problem, i want to update a record, but im getting an error. this is my code [CODE]<?php // connect to the database include('connect-db.php'); // check if the form has been submitted. If it has, process the form and save it to …
My final question. I have values which have been serialized into a table forum_polls as are in the following format as shown in the two examples below: [CODE]a:2:{i:0;a:2:{s:6:"answer";s:3:"Yes";s:5:"votes";s:1:"1";}i:1;a:2:{s:6:"answer";s:2:"NO";s:5:"votes";s:1:"2";}}[/CODE] [CODE]a:5:{i:0;a:2:{s:6:"answer";s:2:"CA";s:5:"votes";s:1:"1";}i:1;a:2:{s:6:"answer";s:4:"CIMA";s:5:"votes";s:1:"1";}i:2;a:2:{s:6:"answer";s:4:"ACCA";s:5:"votes";s:1:"0";}i:3;a:2:{s:6:"answer";s:5:"CIPFA";s:5:"votes";s:1:"1";}i:4;a:2:{s:6:"answer";s:24:"MBA(specify in comments)";s:5:"votes";s:1:"1";}}[/CODE] which unsererilized (I cheated and used an online unserializer) give: [CODE]array ( 0 => array ( 'answer' => 'Yes', …
I have an options table setup like so: [CODE]option_id option_name option_value 1 sitetitle SimpleCollab 2 siteurl http://example.com/ 3 sitepath /home/user/MAMP/htdocs/pm 4 enable_registration 1 5 enable_query 1[/CODE] Then my php code is as follows: [CODE]function get_pm_option( $option ) { global $pmdb; $result = $pmdb->query( "SELECT * FROM " . DB . …
Hi all, I have Text in MySQL utf 8 and an iframe displaying this text, and the page content is utf8. Does anybody know why the iframe caret position doesn't match with MySQL position when there are line breaks, and how to fix it? Regards
Hello! I am making a simple web application with a database. I want to show all the members from a specific group. The group is selected in a drop down list which is populated from my sql database table tblGrupper. I have managed to populate a GridView with the groupID …
I want to count the total no of rows in a table [CODE] Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:gabbar"); Statement ps1 = con.createStatement(); ResultSet count = ps1.executeQuery("SELECT COUNT (*) FROM products ); //products is a table in database [/CODE] count is of ResultSet type.but i want to do arithmetic operation on …
Hi all, I have WampServer2.2a-x32 and VirtueMart_1.1.8_eCommerceBundle_Joomla_1.5.22 but during installation the message given: [CODE]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 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` …
Hi all, I have a text file saved as utf8 without BOM. I loaded it into MysQL database. An iframe is loaded with this data from MySQL. I need the caret position in the iframe in order to perform operations in the database. Everytime there's a new line the positions …
The End.