10,946 Topics
 | |
| | I have error with this line while($row = mysql_fetch_array($pregled)) in line 42 here is part of code that has problem, can anyone check this out? I need to fix this as soon as possible thanks in advance <p align="center"><font color="#0000FF">Pregled grupa</font></p> <p align="center">Grupa kojoj koncert pripada: <select name="grupa_select2" id="grupa_select2"> <?php … |
| | Suppose I have a tow SQL tables: Fathers id | name ------------- 1 | Clinton 2 | Gates 3 | Bush 4 | Clinton Sons id | fatherid | name --------------------- 1 | 1 | bill 2 | 1 | suzy 3 | 2 | mera 4 | 2 | … |
| | I am unable to get my text file data.txt to read correctly into my database. This is what my text file looks like 9889483782,6068378394,6069437364... and so on for like 50 numbers I have to get each of the comma seperated values to show up in the database, id like them … |
| | Okay I hope my title is not confusing. I have two checkboxes names Delete[] and Update[] followed by a textbox named Name[]. When I tick checkbox Delete[] and click Submit, I ran a query to delete the data based on that Checkbox's value (which I have set to be the …  |
 | i made union to two mysql tables select cashid, sum(amt) as ramt, NULL AS pamt from receipt where cashid in ('17', '23') GROUP BY cashid union all select cashid, NULL AS ramt, sum(amt) as pamt from payment where cashid in ('17', '23') GROUP BY cashid and now i want to … |
 | ->Hi,I hope all is well. Here is what I have difficulties with, I am NOT good in Java Scripts and I wanted to have a Slide show Image on My Page and lucky was I to find these fancy slide shows [here](http://www.dynamicdrive.com/dynamicindex14/shockwave/index.htm). I downloaded necessary associated files and the whole … |
| | I have three tables i want to search for customer data depending on the equipment type. $test = "SELECT custid, equipment FROM customer WHERE custid='$id'"; $data = @mysqli_query ($dbcon, $test); $equip = mysqli_fetch_array($data, MYSQLI_ASSOC); if($equip['equipment'] = "cellphone" ){ // Make the query: $q = "SELECT custid, cdate, custName, customer.equipment, customer.manufacturer, …  |
| | Hi all why this code doesn't work correctly but php validate without js work correctly and js without php validate work correctly ?! form.php <html> <head> <title>Registration Form</title> <script language="JavaScript" type="text/javascript"> Function validate () { var str=true; document.getElementById("name").innerHTML=""; document.getElementById("username").innerHTML=""; document.getElementById("pass1").innerHTML=""; document.getElementById("pass2").innerHTML=""; document.getElementById("email1").innerHTML=""; document.getElementById("web").innerHTML=""; if(document.frm.nameTxt.value=='') { document.getElementById("name").innerHTML="Please Enter your name"; str=false; … |
| | Hello, I am installed php 5.3.28 with apache 2.2 and mysql 5.5.38 on windows 64 bit machine, despite configuring php correctly with apache and also enabled the extensions, its not able to recognise the mysql extension loaded. The connection attempt through adodb throws the error "call to undefined function mysql_connect() … |
| | Can anybody help or point me in the right direction what is missing on my code. The postcode is a mysql table and one field stores user's choice of postcodes in the form of array(a,b,c,d and etc....) Now I want to load selectedPostcode in checkboxes for user_id = 2 to … |
 | Hi Guys I wrote simple PHP script for get value from URL and check similar values from the database. This is a code <?php include('../../datab.php'); if(!empty($_GET['ip'])) { $ip = $_GET['ip']; $ipcheck = mysql_query("SELECT * FROM `report` WHERE `ip`='$ip'"); if(mysql_num_rows($ipcheck)> 0) { while($row = mysql_fetch_array($ipcheck)){ ?> <body> <p>Report ID : <?php … |
| | OK, I have the following regulare expression for phone number validation, but it doesn't really do EXACTLY what I want... What I want to see is a forced format 000-000-0000 where it needs to be entered with the area code-prefix-suffix including the dashes. I store it in a varchar field …  |
| | Hello all, Am trying to display records from mysql using HIghchart but for some reasons, it is not bringing out any output, please help me look into my codes. :::::::::::::::::::::::::::::::::::::data1.php :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: <?php include('mysql_connect.php'); $dept = $_POST['department']; //include('mysql_connect.php'); $stat = 'paid'; $result = mysql_query ("select category, amount, actual from budget where … |
 | Hi guys having a little problem getting my brain wrapped around this, im new to php and need some help, on my homepage i have a product spotlight container. In this container i would like to pull information from a table in my database and display the relevant content. I …  |
| | Hello, I'm new to php mysql and would like to ask if someone can point me in the right direction for a script or tutorial that could explain to me how to achieve the following. I have a page that is called "page.php" now when i click a link it … |
| | hello. my MySQL database corrupts the database when ever i start, stop, or restart the service. i am on a laptop.. and this is for testing.. so, i have to stop the server to be able to do other kinds of work and take my laptop to school, work, and … |
 | I am having trouble saving dates to my MySQL database (code below) C# var abook = db.egw_addressbook.Local.FirstOrDefault(o => o.contact_id == 16875); abook.org_name = mvm.org_name; abook.hex_srv_start = mvm.hex_srv_start; db.SaveChanges(); MessageBox.Show("Saved"); XAML <DatePicker x:Name="Txthex_srv_start" SelectedDate="{Binding hex_srv_start}" HorizontalAlignment="Left" Height="26" Margin="10,55,0,0" VerticalAlignment="Top" Width="111" /> If I make any changes to the date, I get … |
| | Hello! I have a problem with sorting mysql queries into pages. So i wanna set every query that is passed to screen to be divided with 30 rows per page. Here is what i come up with: <?php $con=mysqli_connect("*","*","*","*"); // MySQL connect if (mysqli_connect_errno()) { echo "MySQL: no connection! " … |
| | I'm trying to prevent the user from purchasing any share, if the cash in his/her account is less than the desired stock cost (price * shares). However, I'm getting the following error: Warning: mysql_query() expects parameter 1 to be string, array given in /home/jharvard/vhosts/pset7/public/buy.php on line 39 Here is the … |
| | My script has a two bugs, which I've been unable to fix. So, I need your help. Here is the file: <?php // configuration require("../includes/config.php"); // check if form was submitted if ($_SERVER["REQUEST_METHOD"] == "POST") { // type of transaction - for tracking history $transaction = 'SELL'; // validate submission … |
 | this is my code $totalDates = "SELECT COUNT( DISTINCT date ) FROM table_name"; $result = mysqli_query($connection, $totalDates); $totalDates = mysqli_fetch_array($totalDates, MYSQLI_NUM); echo "there are total $totalDates Distinct Rows"; i want to get the no of distinct dates from table_name but it giving me this error , what i might be …  |
| | Hi, i have the requirement of converting a php-mysql app into a standalone app. The main purpose is to hide the source code from the client, and to run the app in his system without a web browser. I wonder if there is any tool for this, so that i … |
| | Hi, I have started using file_get_contents and regex, and after struggling have got it working. The issue I have is that when I print_r($match[1]); I get the results I want, but I do not know how to then convert this into something that I can store in a MySql database, … |
| | use people; SELECT 'first' UNION SELECT first from e where skills regexp "javapl" INTO OUTFILE '/home/ankit/csv/tablename.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'; this runs without problem to /var/tmp folder but other folders gave error:13 can't write please help |
| | Hi Guys, I am developing a Music Database system. This is a 'Song.php' page. It will be a Detailed page of a each song. Ex : song.php?id=1 <?php if(!empty($_GET['id'])) { $sid = mysql_real_escape_string ($_GET['id']); } // if song id is null, user will redirect to the full song list else …  |
 | so.. Im having trouble wrapping my noodle around this... my initial thought: -- events create table Events ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Title VARCHAR(512) NOT NULL, Description TEXT NULL, StartDate DATETIME NOT NULL, EndDate DATETIME NULL ); create index StartDate_OnEvents On Events (StartDate); create table EventFrequency ( … |
| | I have a php/mysql project. When the admin deletes a customer or product from the database on the form I need an confirm box to show and ask the admin if they are sure they want to delete and have the customer row show in the confirm also. Here is …  |
 | So i made a inbox system and its stores the accents(Ã,é,ú etc..) like í,é,ú wich is perfect, but then i made another script and its storing the Ã's like à and i dont know why... i have <meta charset="utf-8"> on both and mysql collation are both utf8 any one knows … |
| | hey guys, so i'm trying to insert data from one table to another. table 1: |event_id|event_name|start|end|event_venue| table 2: |guest_id|guest_name|event_id|event_name| $event = mysql_query("INSERT INTO event VALUES('','$name','$dstart $tstart','$dend $tend','$venue')"); $insertg = mysql_query("INSERT INTO guest(event_id, event_name) SELECT event_id, event_name, FROM `event` WHERE `event_name` = `$name` "); i get : > Column count doesn't … |
| | Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\classes\Trade.class.php on line 12 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\classes\Trade.class.php on line 19 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\classes\Trade.class.php on line 70 Line 12 [CODE]while ( $trade_users_row … |
| | Happy Day.. Hello All! I want to know the Difference between mysql_fetch_array and mysql_fetch_assoc.,and Im new here.. and also to php.. Plz help me to solve my problems.. |
| | Hi,im trying to insert into table student_acedamic_history but I get this error.Heres my code. CREATE TABLE Student_Acedamic_History( S_id INT, Degree_Title VARCHAR(30), Institue VARCHAR(30), Year_Of_Comp INT, Total_Marks INT, Obtained_Marks INT, PercentAge FLOAT, CONSTRAINT fk_S_id_students FOREIGN KEY student_acedamic_history(S_id)REFERENCES students (S_id)ON UPDATE CASCADE ON DELETE CASCADE ); And the data: INSERT INTO student_acedamic_history … |
 | Hello guys i have question how is the right way to write the mysqli_connect ? $con=mysqli_connect("username","host","password","db_name"); Please tell me if im wrong and how to fix it. Thanks ! :)  |
| | i have 2 tables seo_footer_title and seo_title. i want to add title,description and keywords footer.php <li><a href="index.php?city=<? echo $city;?>">Home</a></li> <li><a href="about_us1.php?page=2" title="About Us" onclick="function changetab();">About Us</a></li> <li><a href="contact_us1.php?page=3" title="Contact Us">Contact Us</a></li> header.php $page = $_GET['page']; $sql1 = mysql_query("SELECT st.`id`,st.Catagory, st.`title`, st.`description`, st.`keywords`,sft.id,sft.titles FROM `seo_title` st JOIN seo_footer_title sft ON sft.id=st.Catagory … |
 | Hi, i'm having some trouble with my MySQL server where i can't log in or connect to it from the terminal , phpmyadmin or my server control panel. the password is correct , i have reset it a number of times but still get the same message: ERROR 1045 (28000): …  |
| | Hey guys, so im wondering if theres a way to insert 2 input values into one column in PDO? coz in mysql_* i just did something like this and it worked: INSERT INTO tablename VALUES ('input1 input 2', 'input3'); pdo i tried : $event = $dbh->prepare("INSERT INTO event(event_name,start_event,end_event,event_venue) VALUES('$name', CONCAT_WS('$dstart', … |
| | Hi, I am trying to display two or more images from a database and I cannot get them to display simultaneously. I have a database table called 'tbl_images' which has two fields 'id' and 'image' here is the code for the database creation: [code=mysql] CREATE TABLE tbl_images ( id tinyint(3) …  |
| | When I use `select indicator...`in my select statement below I can't use `$row[indicator]` when I use `select indicator as indicator` I can use `$row[indicator]`. Why is this? $stmt=$mysqli->prepare("select indicator as indicator, count(status)as 'ok', (select count(status) from viewindicatoren where status ='niet ok' and afdelingid=? group by IND_id ) as 'nietOk' from … |
| | Hi Everyone, I haven't started coding or anything but I need to know if it's possible to read a file from last read position? I want to read a file and dump the content into a MySQL database but don't want to read the entire file from start to end … |
| | I have a table that extracts data from a mysql database, I want the table to be centerd on the screen. I have used text-align: center; but obviously it only centers the text inside the div. here is my css .tableOuter { text-align: center; } .tableInner { text-align: center; margin-left: … |
| | I have a php/mysql project. When the admin deletes a customer from the database on the form I need the confirm box to display the customer row that they want to delete as well as the message. Here is current confirm box with a message <script type = text/javascript> function … |
| | Hi, I have a very complex query that is using mysql functions and complex logic. I have done indexing of important fields that needs to be done but I am having issue that the records keep on duplicating and I am using group by to remove this issue but my …  |
| | I want to show some mysql results in two different areas... I thought I would do two queries, and show a certain few (1-5) or whatever on one area, and the rest on another, however I need them split even.... how can I do this? I thought about doing something …  |
 | I need to rebuild my website from scratch as its using old mysql script in pages and based on xmb forum software as a logon system and to connect to my sports database pages. Can someone suggest the best option from here to either update to mysqli or PDO. So … |
| | How do i write php code for getting field from mysql as dropdown in php, and, also to display the related records of selected option in dropdown from database |
| | Hello, I am trying to create a table in MySQL with the following data: $sql = "CREATE TABLE $uID ( Col0 int(10) NOT NULL auto_increment, Col1 varchar(255) NOT NULL, Col2 varchar(255) NOT NULL, Col3 varchar(255) NOT NULL, PRIMARY KEY(Col0) )"; However, I keep getting a syntax error. Can someone pls. …  |
| | I have 2 drop down. In 2nd drop down items are added dynamically based on 1st drop down selection. Now I want selected value of 5th subject to store in MySQL table. I am not able to get the value of option which is selected in 2nd drop down. How …  |
| | I have a php/mysql project and I am currently trying to display a table into an html table through PHP how ever Only the headers are getting returned not the actual table data, here is my query plus html table <?php $result = mysql_query("SELECT * FROM store"); echo"<table border = … |
 | I want to create an archive list like this: 2014 -March -Feb -Jan *Post 1 *Post 2 2013 -November *Post 1 My config file is: <?php ob_start(); session_start(); //database credentials define('DBHOST','127.0.0.1'); define('DBUSER','name'); define('DBPASS','pass'); define('DBNAME','sample'); $db = new PDO("mysql:host=".DBHOST.";dbname=".DBNAME, DBUSER, DBPASS); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //set timezone date_default_timezone_set('Europe/London'); ?>` the table I m …  |
 | how do i insert the textboxes with different data inside of them in one database table i have this code dunno what to do next Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click Dim sql As String Dim totcount As Integer = 0 Dim inc As … |
The End.