10,940 Topics
 | |
| | Hi, I have a query that has a condition that count persons whose blood pressure, weight and height are calculated whose age is greater than 3. I have made this query and this query is working fine but there is a condition that if the age is greater then 2 …  |
 | In reference to this: http://sqllessons.com/categories.html *Change parentid NULL to 0* Let's say I have 6 levels of subcategories. How do I have chained select dropdown based on the main category which has a 0 value under parentid, then show it's subcategoryLevel1 > SubcategoryLevel2 > and so on. Stops when there …  |
| | I have developed an application and will like to synchronize it with the online version. Both has the same table sturcture. Can I get the script that will help me perform this task. |
 | Hey guys, so here's what I'm trying to do: I've made an HTTP script in the game Second Life, it uses an application/x-www-form-urlencoded url to send information to my Php script on my website. Here's the script: <?php define('DB_NAME', 'vangua01_access_list'); define('DB_USER', 'vangua01_admin2'); define('DB_PASSWORD', 'askljflnfldsakn'); define('DB_HOST', 'localhost'); $action=$_POST['action']; if($action == 'connect') … |
| | Hi guys i have an sql query string that in my view there is something wrong with it but i an handicaped since i am very new to sql so my question is, is there any way of optimizing this query string select t1.cat,t1.site from (select cat,site from news where …  |
| | |
| | Hi, i found this code [online](http://www.macrostash.com/2011/09/17/demo-use-a-php-mysql-database-to-load-markers-on-a-google-map/#comment-2675). After installing and running code on my website, the screen shows nothing back, though code is firmly in place. <script type='text/javascript' src='jquery-1.6.2.min.js'></script> <script type='text/javascript' src='jquery-ui-1.8.14.custom.min.js'></script> <style> BODY {font-family : Verdana,Arial,Helvetica,sans-serif; color: #000000; font-size : 13px ; } #map_canvas { width:100%; height: 100%; z-index: 0; … |
| | Hi.. I want to call mysql Stored procedure with OUT parameter. Its worked in phpamyadmin But in php it returning empty result. I have used the following php script. Can anyone help me? <?php include("dbcon.php"); $countryname="india"; $rs1 = mysql_query( 'CALL countCountry($countryname,@totalcount)' ); $rs = mysql_query( 'SELECT @totalcount as totalcount' ); … |
 | I have a table called Report Card Table. In that table there is colum called expiry date. I would like to know everybody who's card is expring in less than or equal to 90 days |
| | Hey guys, so I've been having an errorwith Php/MySQL for a long time with something I'm trying to do. I posted it in the PHP section before I found this subforum, so I'm just going to place the link to it below. Was hoping maybe I'd have a better chance … |
 | Hello Pals... Help with this code...I am unable to hold Angularjs tag with Php variables $vid = "{{task.vid}}"; //this where the Errors comes in :( $s = $db->query("SELECT * FROM reply WHERE post_id_fk = '$vid'") or die($db->error.__LINE__); Please how can i go about this? Thank you! |
 | I want if the user clicks submit to return the the selected value when the form reloads that what I try and no luck <?php $getData = $db->prepare("SELECT * FROM first_university_degree_list"); if ($getData->execute()) { $res = $getData->get_result(); while ($data = $res->fetch_array()) { ?> <option value="<?php echo $data['univ_degree']; ?>" <?php if($FirstUniversityDegree … |
| | <!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>Untitled Document</title> </head> <body> <form action="#" method="post"> UserName: <input type="text" name="username"><br /> Passward: <input type="text" name="passward"><br /> Name: <input type="text" name="name"> <input type="submit" name="Submit" value="Sent"> </form> <?php $con=mysql_connect("localhost","root","","firstphp"); if(isset($_POST['Submit'])) { $UserName = $_POST['username']; $Password … |
| | Is there any software out there with GUI that i can use to install mysql and phpmyadmin on my vps account? Am new to vps,thx... |
| | Hello all, I am needing some guidance on how to build an array from POST Variables an then insert the data into mysql. Here is what I have M Variable from submitted form $parentid ="7638sds"; $child3_1_name =$_POST['chld3_1_name']; $child3_1_age =$_POST['child3_1_age']; $child3_2_name =$_POST['chld3_2_name']; $child3_2_age =$_POST['child3_2_age']; $child3_3_name =$_POST['chld3_3_name']; $child3_3_age =$_POST['child3_3_age']; $cnt="3"; $childrenContainer =" … |
 | i have three table i attached db files with query result i am getting. my query is below select tts.transaction_id,tts.service_type,tt.theme_name from transactions tts inner join users tu on tu.user_id=tts.user_id inner join themes tt where tts.user_id = 71 and tts.service_type in ('purchased','startup_service') group by tts.theme_transaction_id; i am not getting write theme … |
| | i have two postcodes entered by user. i format them validate and check if they do exist then i get postcode1's postal city name from mysql server. i have two districts both arrays one called innerLondon array and the second outterlondon array i fetch postal city name with my script … |
 | Hello all, My master master synchronization working properly but from yesterday after 4pm my sinking get stopped. My uplink working properly but downlink not working.I failed to found any issues. Please tell me why such master master get stopped and any solution for it.  |
 | Hello, What's the latest mysql syntax to insert into 2 tables: "INSERT INTO student as t, study_report as s(t.group_id, t.access_level_id, t.stu_username, t.stu_fname, t.stu_lname, t.stu_email, t.stu_address, t.stu_telp, t.stu_hp, t.stu_wa, t.stu_skype, t.stu_facebook, t.stu_twitter, s.group_id, s.stu_fname, s.stu_lname) VALUES('".$group_id."','".$access_level_id."', '".$username."', '".$stu_fname."','".$stu_lname."', '".$stu_email."', '".$stu_address."','".$stu_telp."','".$stu_hp."','".$stu_wa."','".$stu_skype."','".$stu_facebook."','".$stu_twitter."', '".$group_id."', '".$stu_fname."','".$stu_lname."')"; I have an error appears: You have an error … |
| | I am trying to make a vehicle advertising website like autotrader or ebay. I am using html, css, jsp, java and mysql for the database.Basically I want the user to be able to search for a vehicle (advert) via a form, then they are directed to a results page after …  |
| | I have a question about how to set up a page in php to allow the user to create reports from a mysql database and display in a grid on the page. I want them to build the query and save it to the another table and list on their … |
 | After very little success in using JQuery .post methods I wanted to try asking this here before giving up. I am serving a couple JS based games on a site using PHP as members can log into the site and through sessions/cookies remain logged and play games under their account. …  |
 | Hi, I'm still very new to MySQL and I'm having some issues trying to generate the right set of results. I have two tables, that follow the structure as below: mod_site_content +----+-----------+--------------+ | id | pagetitle | content | +----+-----------+--------------+ | 1 | home | <p> ... </p> | | … |
 | i want to upload the employee profile picture into mysql database using php. i tried this coding. image uploaded successful but when i fetch that image on browser it shows me text character like this (ÿØÿàJFIFHHÿáLExifMM*bj(1r). one more problem is below 20kb size images only uploaded into mysql. how to …  |
| | i have the following sql query i seem to be having this error "Incorrect syntax near the keyword 'INSERT'" |
 | Hi All, I'm not sure if this is a technical issue, preference or a question about best form. I have a 'users' table and a 'contacts' table. 'users' and 'contacts' have no direct relation. Both contain an email address for each record in their own table. I want to send … |
 | Hi, i'm developing an app with python where I need to link it to MySQL? Can somebody tell me how I would do that? Anything would be gladly appreciated! |
| | Hi all, i would like to ask, if i have **3 tables in database** and i have a **search bar** in my web page to **search staff id** to update details. The staff id being searched in search bar is assume as **$search_id = $_POST['searchid'];** The 3 tables in database … |
| | Hi all ; please help me what is the expected problem in this code ??! function SearchGrid($query,$updateOk=FALSE,$DeleteOk=FALSE) { $tbl.="<script> var prev=1; function HighLightRow(rowno){ if (rowno%2==0) tblsearch.rows[prev].bgcolor='#66FF99'; else tblsearch.rows[prev].bgcolor='#CCCC99'; tblsearch.rows[rowno].bgcolor='white'; prev=rowno; } </script> "; $result=mysql_query($query); $tbl.="<table id=tblsearch align =center border=0 > <tr bgcolor=gray>"; $RowNum =mysql_num_fields($result); //name of field :) .... for($col=0;$col<$RowNum;$col++) … |
| | Is there another function for creating php sockets apart from this socket_create(AF_INET, SOCK_STREAM, SOL_TCP); ? Really need to know, thanks. |
The End.