39,326 Topics
 | |
| | Please can someone help me optmize this query, it is slow and brings the same data for the debtage column SELECT customer.custid,customer.compname,customer.phone,customer.depot,acctofficer.acctfullname AS acctoff, STR_TO_DATE(mastorders.lastsuppdate,'%d-%m-%Y') AS purchdate, STR_TO_DATE(transactions.timestamp,'%Y-%m-%d') AS debtage, format( customer.balance, 2) AS balance, customer.balance AS balance1 FROM customer,mastorders,acctofficer,transactions WHERE customer.custid=mastorders.custid and acctofficer.acctoffid=customer.acctoff AND customer.depot='$depot' GROUP by customer.id ASC. … |
| | how to use datepicker jquery what are the essentials think i should download to use datepicker  |
 | I want to have a supplier table, with ID, NAME, CONTACT, PHONE, etc, In my main table, a record can have more than one of these suppliers, what is the best way to select multiple rows from the supplier table if they relate to a record in the main table? … |
| | Hi I am new, Pls help me the following issue. When click the update button, ID should be to another page to process the update function. Below is my entire code index.php <?php include_once '../../inc/config.inc.php'; $sql="SELECT * FROM demo order by id"; try { $result = mysqli_query($con,$sql); include 'view.html.php'; } … |
| | hi im doing a project on online table reseration. im using a table "reservation" to store the table details of reserved table +--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+----------------+ | reserve_id | int(15) | NO | PRI | NULL | auto_increment | … |
 | With the following bit of code I'm trying to get the key's of each sub-array that I will need at this part of the script. It's working so I'm not too worried about this, I just think there should be a pre-built function to do the same thing. foreach($myArray['ico'] as … |
 | Hi. all i have small problem Not verified =0 verified=1 $balance = $match_value['balance']; $verified = $match_value['verified']; <tr><td> <b> Balance: </b> </td> <td> if ($verified == 1) { $verified = "$balance"; } else { <a class="btn btn-danger" href="verified.php" > not verified </a> } </td></tr> |
| | Store a image in database. and fetch the image when the user login |
 | Hi, I am trying to insert data into 3 tables using mysql.. At first, I was able to insert in the first table (staffinfo), after coding for the second table insert (empinfo), It inserted into second table without inserting in first table AND finally it echoes 1 record added Successfully …  |
| | Raffle function to generate unique numbers for each player, related to the same table with a recursive aproach. I had to do a simple raffle system for a contest that I was working on and tried many things and the most simple and the most effective one to generate unique … |
 | **Problem** I need an jax pagination in YII, The problems are * its not showing the required results for the first time. ie. it is showing the complete result * When clicked on more, it again shows the complete result below that section as it is **What Needed** * i … |
| | Hello, I have looked everywhere on the web for a solution to this problem. I am trying to store arabic characters into mysql via an html form. i have set the meta charset to utf-8 and have tried mysql_query('set names 'utf=8'") but still i get garbled characters in my table: … |
 | ## Theme Options Settings ## I have problem with my theme options settings saving. My settings is to saving to permanently , its just only save when you stay on the theme options page after saving the settings. But when I go to any other page or reload the current … |
 | I have build simple chat box. One Text box -> Enter msg One button -> Submit One Textarea -> show message which enter in "Text Box" How could i do using jquery + ajax.? Give me suggestion. Thank you |
| | Hi all, I need to do my own version of phpMyAdmin for my php class. I encountered problem when trying modify existing data on database. I don't know what would be best way to modify whole table's data when I don't know exact amount of rows or columns. At this … |
| | Hi there, I have a problam with my code, and i cant fix it, please help. The problam is with the mysql_num_rows on line 4 ; Here is the code: $sql_query = mysql_query("SELECT * FROM upload WHERE MATCH(username,text) AGAINST('$search_term')"); //additional check. Insurance method to re-search the database again in case … |
 | Hi, How to calculate hours in PHP in when time is coming in Am - PM format ? for example, 1] start time: 9AM end time: 12PM 2] start time: 9PM end time: 1AM 3] start time: 12.30PM end time: 1.25PM any formula please |
| | Hi all, I have one problem on selecting larga data from mysql. I have inserted large data to mysql, and all data was inserted. I see it from phpmyadmin. but when i select that record from database it cannot display whole data.it doesnt show the end part of the data. … |
| | **reg.php** <?php require_once('Connections/iventori.php'); ?> <?php $currentPage = $_SERVER["PHP_SELF"]; //$tarikh=gmdate("j F y",time()+(28800)); $maxRows_Recordset2 = 10; $pageNum_Recordset2 = 0; if (isset($_GET['pageNum_Recordset2'])) { $pageNum_Recordset2 = $_GET['pageNum_Recordset2']; } $startRow_Recordset2 = $pageNum_Recordset2 * $maxRows_Recordset2; mysql_select_db($database_pinjaman, $pinjaman); $query_Recordset2 = "SELECT no_inventori,model FROM inventori WHERE peralatan='laptop'"; $query_limit_Recordset2 = sprintf("%s LIMIT %d, %d", $query_Recordset2, $startRow_Recordset2, $maxRows_Recordset2); $Recordset2 = … |
| | Does anyone know how to query a dropdown list to a website from SQL server 2012 in WebMatrix Using PHP? PLEASE HELP!  |
| | I am making a cms for a booking app and the admin will be able to see the number of bookings at any moment. How can I do it so that the above updates continuously with ajax...like facebook newsfeed for example. So far the only ajax I have made is … |
| | PHP, jQuery and definitely not my favourite. My query is this; I purchased a social network script and there are still modifications I need to do that I am stuck with. I would like the users to have the option to upload a photo if they want to, with any … |
| | I got a project to add some changes; but the problem is that the code is 4 years old; it is running on server but not on LOCAL; How I can run old PHP locally ? |
| | I am making a form which contain two input suggestion fields, 2 datepicker and three select fields. I want to make my form ajax based and show result in div when any field is changed. Just like farecompare.com I almost created a form but form start loading when i click … |
| | **here is my coding. i want user unable to select data in select box once it is selected in the first select box(hide/remove).i add the javascript. but its not working. any solution?** **peralatan.php** <?php require_once('Connections/iventori.php'); ?> <?php $id = $_GET['idpinjaman']; $colname_Recordset1 = "-1"; if (isset($_GET['idpinjaman'])) { $colname_Recordset1 = (get_magic_quotes_gpc()) ? … |
| | Hi,I am a beginner in php. And I am trying to create this php program where a user selects a picture and it displays it! Theare is an input page which is html and an processing page which is php! I seemes to have a problem in the processing page … |
| | <div class="message-container" id="message-composer"> <div class="message-form-content"> <div class="message-form-header"> <div class="message-form-user"><img src="{$url}/thumb.php?src={$avatar}&t=a" /></div> {$lng->form_title} <div class="message-form-private"></div> <div class="message-loader" id="post-loader9999999999" style="visibility: hidden"><img src="{$url}/{$theme_url}/images/preloader.gif" /></div> </div> <div class="message-form-inner"> <form id="imageForm" name="form" action="{$url}/requests/post_message.php" method="POST" enctype="multipart/form-data" > <textarea id="post9999999999" class="message-form" placeholder="{$lng->message_form}" name="message"></textarea> </div> <input type="hidden" name="privacy" id="message-privacy" value="{$private_message}" /> <div class="selected-files"><span id="queued-files">0</span> {$lng->files_selected}</div> <div class="message-form-input"><input type="text" … |
| | <?php include 'connect.php';?> <?php include 'functions.php';?> <?php include 'header.php';?> <?php if(isset($_GET['user']) && !empty($_GET['user'])){ $user=$_GET['user']; }else{ $user=$_SESSION['user_id']; } $my_id = $_SESSION['user_id']; $username=getuser($user,'username'); ?> <h3> <?php echo $username; ?> </h3> <?php if($user != $my_id){ $check_frnd_query=mysql_query("select id from frnds where (user_one='$my_id' and user_two='$user') or (user_one='$user' and user_two='$my_id')"); if(mysql_num_rows($check_frnd_query) == 1){ echo "<a href=''>already … |
| | Hello, I'm trying to implement autocomplete on a single field "contact". This should query the "contacts" table looking for an id but displaying the firstname in the input field. This is my function inside ListingsController.php, every listing belongs to a contact and every contact belong to a listing. public function … |
| | $gateway_url = $url."?ORDERID=".$orderid."&SESSIONID=".$sessionid; <iframe src="<?php echo $gateway_url; ?>" style="border:0px #FFFFFF none;" name="manframe" scrolling="no" frameborder="0" marginheight="0px" marginwidth="0px" height="60px" width="468px"></iframe> Please I need help. I get this error Parse error: syntax error, unexpected '<' |
The End.