-
Replied To a Post in UNION SQL call original rows
You cannot change a column name on the fly like this. You're better off making another column and calling it type and flagging it to know what "type" it is. -
Began Watching UNION SQL call original rows
Hello i want to UNION three tables from the same database. SELECT DISTINCT * FROM (SELECT uid as id, name as name, username as username,bio as aboutme, '' as text, … -
Replied To a Post in How do you write an sql query for this?
What have you tried? -
Began Watching How do you write an sql query for this?
i'd like some help writing an sql statement that brings back the shows in a specific category. For example an sql statement that will bring back shows from the action … -
Replied To a Post in CASE WHEN THEN error
You're also missing the word "where" before your case. Lastly, comma joins are pretty old and likely will be deprecated at some point... -
Replied To a Post in CASE WHEN THEN error
Your where clause always have to result in a boolean to check equivalency. For example "where 1 = 1". From reading this, it does not look like the case has … -
Began Watching CASE WHEN THEN error
Hello i am getting an error on a CASE WHEN THEN syntax on my mySql SELECT DISTINCT u.uid,c.c_id,u.name,u.profile_pic,u.username,u.email,c.time FROM conversation c, users u, conversation_reply r CASE WHEN c.user_one = '99' … -
Replied To a Post in Storing a php table values in mysql database
So.. the problem is your question is very vague. Instead, I will walk you through how to find your answer on your own and hopefully that will help you. First, … -
Began Watching Storing a php table values in mysql database
$table = "<table>\n"; for ($i = 0; $i < sizeof($rounds); $i++) { $table .= "<tr><th>Week #: " . ($i + 1) . "</th><th>Match</th><th>Away</th><th>Referee</th></tr>\n";//table headers foreach ($rounds[$i] as $r ) {//iterate … -
Replied To a Post in Performing a MySql query in JavaScript
As I noted, if you want to do "everything" in javascript, look at building out a nodeJS stack. While it's "all javascript" it just happens to replace the PHP part … -
Replied To a Post in Performing a MySql query in JavaScript
You are going to need to learn about AJAX, some server side language to format your JSON to output to the AJAX request, and of course - SQL to write … -
Began Watching Performing a MySql query in JavaScript
I have a table on my web page that is currently updating with random Data, see below: function changeContent(){ var i = 1; var len = numberRows; var random1 = … -
Gave Reputation to Dani in Biggest DaniWeb pain points
> You have an audience here who are expert practitioners in IT, web services, etc etc. Hundreds of man-years experience in designing, developing, supporting exactly this class of software/service. We … -
Replied To a Post in Displaying records from database using enum
Yes, that's exactly what I meant. How are you determining your $per_page_records value? Edit: actually... since youre using the active='1' in your query, you just wouldn't pull any data if … -
Replied To a Post in Displaying records from database using enum
What is your methodology that gets the count of all items? (ie, how are you determining you only need 3 pages of 25 a piece?) -
Began Watching Displaying records from database using enum
Hi I am struggling with some code and was wondering any someone could please help me. My php skills are VERY limited and only get stuff done by reading forums … -
Gave Reputation to gentlemedia in Biggest DaniWeb pain points
I really hope that you do also something against these sig posters, because they're posting meaningless questions/answers and dragging up old threads from the death, just to have some backlinks … -
Replied To a Post in Want to set iframe javascript property
you are looking for the javascript function `window.open` (or, in your case, `top.window.open("https://www.yahoo.com")` or whatever....) -
Began Watching Want to set iframe javascript property
There is javascrit functio is calling on button click and this form get created by Iframe i just want to set link to be open in new tab or window … -
Replied To a Post in Final year diploma project
I'm always confused by questions like this... You studied this field. You know your stuff.. build something important to you - with EE you can do SOOOO much.. Take something … -
Began Watching Final year diploma project
i am a student of diploma in electronics and telecomm can anyone suggest me projects related to the below domains:- wireless communication power electronics electrical and electronics IOT Biomedical Instrumentation … -
Replied To a Post in fyp
Having an off day pty? -
Began Watching fyp
hello everyone.. i am a final year student. we are asked to do a project in networking.. what kind of project in networking should i do.. i confuse what kind … -
Replied To a Post in How to create a toggle without JS?
The only "secret" to JS-Less toggles is an input type="checkbox" and use a label to toggle the checkbox's state from there, you use your css "+" and :checked pseudo selector … -
Began Watching How to create a toggle without JS?
Hi there! I am creating a toggle in pure css without jquery or javascript and its look like it hasn’t work yet. The problem is Css div alignment. Its not … -
Replied To a Post in Traceback TypeError: 'int' object does not support item assignment
tcol1 = 0 tcol1[mm] = col1 + amt You can't set a member of 0 to a value. You are essentially saying 0[mm] = col1 + amt; -
Began Watching Traceback TypeError: 'int' object does not support item assignment
New to Python. Background from TRS basic thru several versions of basic and ending with Qbasic, some Perl and now trying Python. I get the following error and have no … -
Replied To a Post in What's wrong of my query?
http://www.sqlfiddle.com/#!9/c6632/15 I believe this will work for you (I gave you two versions to work with) select room_type.room_type, room_type.room_typeID, room_type.room_type_des, room.room_id, room.room_number, room.room_typeID, room.room_adultcapacity, room.room_childcapacity, room.room_img, room.room_status from room left … -
Replied To a Post in What's wrong of my query?
in your example code there.. your room_id for the reservation is NULL... is that right? -
Replied To a Post in What's wrong of my query?
> where the inputed check in and check out dates of the present guest... things like this make it confusing. Another attempt at clarification please: Given a date range (fromDate … -
Replied To a Post in What's wrong of my query?
Your tables are not complicated. However, I am still struggling to have a plain English explanation of what you want (and is likely the root of your problem. If you … -
Replied To a Post in What's wrong of my query?
So.. let me make sure I have your request right: You want all rooms -- show the reservation information when a room is reserved -- limit by a specific date … -
Replied To a Post in What's wrong of my query?
So.. I didn't pop this in a fiddle or anything due to laziness... however, I believe I found your problem: so, you're pulling ALL ROOMS (and appropriate meta data) where … -
Began Watching What's wrong of my query?
In this query i want to display the unbooked rooms, but the booked rooms are displayed instead of the unbooked rooms... create table guest ( guest_id int auto_increment primary key … -
Gave Reputation to afia_1 in Title for web based system final year project
I guess you are looking for project suggestions for final year project. It doesn't matter if you are looking in beauty and self grooming or in whatever. You need to … -
Replied To a Post in Title for web based system final year project
Well.. currently there is a flood of people who put out youtube vids and personal blogs on that sort of stuff... you can write a page that indexes / ranks … -
Replied To a Post in Title for web based system final year project
I get that English seems to not be your primary language. Let's try asking another way... What class is this for? What other instructions have you been given? What are … -
Replied To a Post in Title for web based system final year project
.... are you asking what you should reasearch or just some random title? I mean... no offense here... but you have a problem (you need a title generated). Solve it … -
Began Watching Title for web based system final year project
Hello .Im a final year student in bachelor of science computer in web technology. I need your suggestion for my final year project title.Do you have any related ideas? -
Replied To a Post in Biggest DaniWeb pain points
SO requires a certain amount of "points" to allow replies. It's a community filter. It's annoying. However, as was pointed out with how hostile the internet is in general to … -
Replied To a Post in Biggest DaniWeb pain points
Well.. here's my 2¢ 1: Old threads (like.. some are 3+ years old!) being commented on. They need to be locked. A lot of the comments are outdated, spam, or … -
Began Watching Biggest DaniWeb pain points
I'm trying to save DaniWeb. :) What are the biggest pain points you have with DaniWeb? If you don't visit DaniWeb as much as you used to, what changed? Where … -
Gave Reputation to Dani in Who might have interest in building a Dazah app?
> You built it. They will come. I built it 2 years ago. No one ever came. > To me, DaniWeb is the Dazah app for DaniWeb users. We already … -
Replied To a Post in PHP Notice: Array to string conversion
did the two suggestions above not work? -
Replied To a Post in PHP Notice: Array to string conversion
@janicemurby try this: else eval("$$rowcf['Variable'] = $rowcf['Value'];"); or else eval("$\$rowcf['Variable'] = $rowcf['Value'];"); Im not sure what the escape for the 2nd $ will do... it seems odd to need it.. … -
Replied To a Post in Who might have interest in building a Dazah app?
@Dani, I will admit.. as much as I love to program, I am very much a "point me at a problem" kind of person... I have a bit of a … -
Replied To a Post in PHP Notice: Array to string conversion
@gdi888, start your own thread. You will need to post example code to see what you are doing to see if we can help. By posting in your own thread, … -
Replied To a Post in PHP Notice: Array to string conversion
So.. first, did you write this? Are you aware of what "$$" variables do? ( for those who don't, they make a (scoped?) variable with the "VALUE" as the variable … -
Began Watching PHP Notice: Array to string conversion
hi all im getting the following error PHP Notice: Array to string conversion in /home/public_html/includes/database.php(23) : eval()'d code on line 1 in this file <?php $link = @mysqli_connect($hostname, $username, $password, … -
Replied To a Post in Who might have interest in building a Dazah app?
You obviously put a lot of thought into this. Personally, I am either not experienced or creative enough to figure out how to exploit the system you created. I get …
The End.