-
Began Watching Displaying php output to google using sublime text 2
Greetings guys, I am barely new to php and i have incoming presentation from a company and they asked me to build some basic website using sublime text 2. here's … -
Replied To a Post in Displaying php output to google using sublime text 2
I guess sublime text is just an editor with good features for progammers. But any simple notepad is enough to write php code. create text file name it as HelloWorld.php … -
Replied To a Post in PHP Dropdown question
Try to Use distinct keyword in your query $dropdownquery="select distinct col1,col2 ...."; -
Began Watching date SEARCH
please help ..the date format in my datase is Y-m-d.. now i want to search by date..so in my textbox i need only to type example: data in the database: … -
Replied To a Post in date SEARCH
$query = "SELECT * FROM po wHERE (date = str_to_date({$searchString},'%m-%d-%Y') || date like str_to_date ({$searchstring},'%m-%d-%Y)) "; -
Replied To a Post in date
We use explode fuction with seperator / , so it will give you array of size 3, then you can concate it as shown below $datearr=explode("/",$myDate); $dbdate=$datearr[2]."-".$datearr[0]."-".$datearr[1]; -
Began Watching date
I have a date in a textbox .. $myDate ='06/30/2014' how do i convert it into this format..since this is the date format in the database.. $myDate ='2014-06-30' thanks.. -
Replied To a Post in Combine script
I have changed your first query 1) added 2 columns in group by 2) added where clause according to your second query $sql = "select id,date,category,sum(q1) Total,sum(q2) Total2,sum(q3) Total3,sum(q4) Total4,sum(q5) … -
Began Watching Combine script
Hy i have this sql query.. how can i combine with the next one ?... this $sql = "select id,date,category,sum(q1) Total,sum(q2) Total2,sum(q3) Total3,sum(q4) Total4,sum(q5) Total5,sum(q6) Total6 from articles group by … -
Began Watching WHERE !=
Does anyone sees any error in this? I tried everything, google it and still getting the same results, even when i replace the $uid with the number of the id … -
Replied To a Post in WHERE !=
try following as i suggested before where f.friend_two <> '$uid' and F.friend_one <> '$uid' -
Stopped Watching WHERE !=
Does anyone sees any error in this? I tried everything, google it and still getting the same results, even when i replace the $uid with the number of the id … -
Began Watching WHERE !=
Does anyone sees any error in this? I tried everything, google it and still getting the same results, even when i replace the $uid with the number of the id … -
Replied To a Post in WHERE !=
To get correct result 1) I think you need to join clause to join users U, friends F 2) need to put where f.friend_two <> '$uid' and F.friend_one <> '$uid' -
Replied To a Post in how i can display database data as a tree
Your requirement is just grouping, its does not look like tree You can do this using two queries $cityquery= "select distinct city from usertable" loop -- through above records and … -
Began Watching how i can display database data as a tree
hello i have an attribute in 'users' table called RegNo which refer ro region number ... so i have to select users and display them according to their region number … -
Began Watching Show .php files before $_SESSION
I want to be able to show some .php files before the user logs in I know that the reason we do the session is for ones who are users … -
Replied To a Post in Show .php files before $_SESSION
Simply the page that you want to show to public users, do not keep session check in such pages. -
Replied To a Post in Count rows from two tables
I have put coluname in query as told by djbirdi and I have put alias a after parenthesis. Try with alias $query=mysql_query("SELECT COUNT(*) AS total FROM (SELECT uid_fk FROM message_believe … -
Replied To a Post in Count rows from two tables
I have put alias a after parenthesis. Try with alias $query=mysql_query("SELECT COUNT(*) AS total FROM (SELECT COUNT(*) FROM message_believe WHERE message_believe.uid_fk ='$uid' UNION ALL SELECT COUNT(*) FROM review_believes WHERE review_believes.uid_fk … -
Began Watching Count rows from two tables
I want to count rows from table1 and rows from table2 and retrieve a sum from both tables. i use this... $query=mysql_query("SELECT COUNT(*) AS total FROM (SELECT COUNT(*) FROM message_believe … -
Began Watching Leave page message in javascript
Hello, I want to ask user about leaving page when there is some **not saved data** on page. I wrote code <script> window.onbeforeunload= function() { return "Save your data plz"; … -
Replied To a Post in Leave page message in javascript
so where you put the code you shown in your fist post? -
Stopped Watching Leave page message in javascript
Hello, I want to ask user about leaving page when there is some **not saved data** on page. I wrote code <script> window.onbeforeunload= function() { return "Save your data plz"; … -
Replied To a Post in Leave page message in javascript
set javascript global variable onload that warn=1; but in onsubmit set warn= 0; Then on unload, you can see variable value and put alert <script> window.onbeforeunload= function() { if (warn==1 … -
Began Watching Leave page message in javascript
Hello, I want to ask user about leaving page when there is some **not saved data** on page. I wrote code <script> window.onbeforeunload= function() { return "Save your data plz"; … -
Began Watching MS SQL Connection to PHP
I have read from different forums, PHP website and Microsoft website how to connect PHP to MS SQL Server but the provided solutions didn't worked for me. If you could … -
Replied To a Post in MS SQL Connection to PHP
Where is your code, and what error you get while running your script? -
Began Watching php - invoice
Intend to carry out a simple online and print invoice to pdf. Suggestions are accepted ... -
Replied To a Post in php - invoice
what u have did till now? -
Replied To a Post in While Loop 2 difference class
you must have column in table foto that its vidoe or image. Use if condtion based on that column value to chose your html code -
Began Watching While Loop 2 difference class
Hello World, I have a problem. I want show 2 images or 2 link videos or 1 images 1 link videos together but image/videos not appear, because 2 difference class. … -
Replied To a Post in WATABLE
Hericles, Now I guess users thinks that moderators are OMNISCIENT -
Began Watching WATABLE
//create the sortable headers for (var i = 0; i < colsSorted.length; i++) { var column = colsSorted[i]; var props = _data.cols[column]; $(document).on('click', '.'+column+'ascen', function(){ col=$(this).parents("th").find("a").html(); if (priv.options.debug) console.log('col:{0} clicked'.f(col)); … -
Replied To a Post in php max_execution_time is not working
Put that in begining of your code set_time_limit(2000); -
Began Watching php max_execution_time is not working
hi everyone, in my server, i am running a script thats uses curl heavily and it usually takes about 5 minutes to finish running. It used to wokr in my … -
Replied To a Post in order price from multiple tables
I agree with hericles. But as temporary solution following should work SELECT a.price, b.price FROM table1 AS a INNER JOIN table2 AS b ON a.sku = b.sku ORDER BY case … -
Began Watching order price from multiple tables
I have two tables with column name price I want to order by price from both columns so if is in first table 100eur and in second is 200eur I … -
Replied To a Post in Compare Records based from the next Record
Now you have query, you can tweak around it. Though run following one also, I have changed b.type<>d.type to b.type=d.type. My query assumes that your date column is also having … -
Replied To a Post in computer shop
find one of your choice http://www.databaseanswers.org/data_models/ -
Began Watching computer shop
pls help me creat database for computer hardware shop by letting me knw the attributes -
Replied To a Post in calculations between arrays of two (or more) tables
if you run all part by part you can understand set 1 SELECT cashid, sum(amt) AS ramt, NULL AS pamt FROM receipt WHERE cashid IN ('17','23') GROUP BY cashid set … -
Began Watching displaying array from min to max
How can I do this, not to show only min and max number, but all numbers like 23,45,65,78,34,21,56 I need command to sort this out from min to max and … -
Stopped Watching displaying array from min to max
How can I do this, not to show only min and max number, but all numbers like 23,45,65,78,34,21,56 I need command to sort this out from min to max and … -
Replied To a Post in displaying array from min to max
echo array_sum($points)/count($points); -
Began Watching calculations between arrays of two (or more) tables
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 … -
Stopped Watching calculations between arrays of two (or more) tables
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 … -
Replied To a Post in calculations between arrays of two (or more) tables
SELECT cashid, sum(ramt) ramt, sum(pamt)pamt, ifnull(sum(ramt), 0)-ifnull(sum(pamt), 0) balance FROM ( SELECT cashid, sum(amt) AS ramt, NULL AS pamt FROM receipt WHERE cashid IN ('17','23') GROUP BY cashid UNION ALL … -
Began Watching calculations between arrays of two (or more) tables
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 … -
Began Watching calculations between arrays of two (or more) tables
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 …
The End.