|
hi, i got the problem with updating my database via php
its like the new one doesnt change with the old one is there anything wrong with that?
$query = "UPDATE friends set lastname = @lastname where firstname = @firstname ";
$result = mysql_query($query) or die("query failed : ".mysql_error() );
|
|
|
|
|
Here is how that SQL statement should be structured:
$query = 'UPDATE friends SET lastname = "@lastname" WHERE firstname = "@firstname";';<br />
<br />
$result = mysql_query($query) or die("query failed : ".mysql_error() );
Also why have you used "@"? that is not a variable declaration from what I can remember.
Good on you for starting on PHP though.
Brad
Australian
By contacting your lawyer you negate the right to sue me.
|
|
|
|
|
when calling a url through xmlHttp repeatedly using setInterval
to perform some operation on database .But it is functioning correctly when setting a break point on the url page other wise it wont executing.
|
|
|
|
|
Can you repeat that? and try too make sense.
Brad
Australian
By contacting your lawyer you negate the right to sue me.
|
|
|
|
|
I am developing an online webchat using xmlHttp Request.
I created the following script to get message from database
function getMessage()
{
clearInterval(interval);
frm = document.forms[0];
var xmlHttp=XHRFactory.getInstance();
sessionId=getCookie("chatSession");
from=getCookie("chatFrom");
//alert("hi");
url="chatprocess.aspx?msg="+from+ "&option=4&sessionID="+ sessionId;
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange=function ()
{
if (xmlHttp.readyState == 4 && xmlHttp.status == 200)
{
// alert("hihi");
if((window.ActiveXObject))
{
if(xmlHttp.responseBody != null )
{
isok=xmlHttp.responseText;
}
else
{
isok=xmlHttp.responseText;
}
}
else
{
if(xmlHttp.responseText.length != 0)
{
isok=xmlHttp.responseText;
}
else
{
isok="Not";
}
}
}
// isok=xmlHttp.responseText;
} ;
//alert(isok);
if(isok=="ok")
{
closeWindow();
}
else
{
getchatmessage();
}
xmlHttp.send();
return false;
}
In chatprocess.aspx i wrote the following code to fetch the content from database
private void GetMessage()
{
sql = "SELECT Chat_temp_From.Message FROM Chat_temp_From INNER JOIN Chat_Session ON Chat_temp_From.Session_ID = Chat_Session.Session_ID WHERE (Chat_Session.Session_Status = '1') and Chat_temp_From.Session_ID=" + sessionId+" and Chat_temp_From.Status=1";
msg = objDl.RetrieveMessage(sql);
sql = "update Chat_temp_From set Status=0 where Session_ID=" + sessionId;
bool deleteSuccessfully = objDl.ExecuteSQL(sql, ref rowsAffected);
if (!deleteSuccessfully)
{
Response.Write("Error");
}
Response.Write(msg);
}
But its not continusly calling the getmessage function in the javascript.
in the form load i am calling the following client script
function startChat()
{
interval=setInterval("getMessage()",10000);
}
but its not working
|
|
|
|
|
Can you define "not working".
Do you receive error messages? What happens when you run it? Do u have a web based testing server that I could see it run on?
Brad
Australian
By contacting your lawyer you negate the right to sue me.
|
|
|
|
|
the control is going to the server code for fetching the database only once. after that the js function is repetedly executing and displaying the first message from the database.
I am doing this as part of my post graduation course. we dont have facility to upload this to any server
|
|
|
|
|
Ok can you please define the problem you are having.
Brad
Australian
By contacting your lawyer you negate the right to sue me.
|
|
|
|
|
but some times its not repetedly calling the js function. so it wont fetch from database
|
|
|
|
|
Ok so now i think i understand your problem.
Your AJAX call does not keep refreshing correct?
If this is the case then I noticed you have a startChat() function.
After you process the received data call this function.
This will mean that the process is restarted.
Hope that works for you.
Brad
Australian
By contacting your lawyer you negate the right to sue me.
|
|
|
|
|
It looks like your retrieving the items from the existing session. Since each user has a different session, you'll never get the other messages.
|
|
|
|
|
Hey all,
I am working on a personal site atm and have built it a user system. I have a Group/Access system and users are able to log in now.
But now I am facing the challenge of allowing continued sessions, like how we can log into the code project once and not having to do it again until we Sign Out or delete cookies.
ATM I have a system where when the user logs in a 100 character random password is set and stored with their user ID. This is a system that works very well, but it means that If you log on from 2 locations one person will get kicked.
This may not seem like a bad thing except that what if you have two computers, then only one will be able to stay connected at a time.
Another thing is that I don't want to use PHP sessions because then a malicious user could guess the Session ID of another user and not have to know their user ID to login.
Can someone (especially Chris) recommend a way of implementing this?
Brad
Australian
By contacting your lawyer you negate the right to sue me.
|
|
|
|
|
I want to use a local language font in my web page. how to install that font in web so that very user can enjoy that font. plz. Help me.
Bharat Bhusanam
|
|
|
|
|
Sorry, if the user has not installed the font themselves then you can use it. You could offer it as a download though.
Brad
Australian
By contacting your lawyer you negate the right to sue me.
|
|
|
|
|
Hi everyone!
I need help understanding how to add overlays and tiles over my google map... is there a way to overlay only one image instead of mapping the url's of each tile? Many many thanks in advance!
Nila
"...for that, I will need a large cup of coffee and a brand muffin!" -Samantha Bea
|
|
|
|
|
I am generally aware that the use of tables is discouraged and have even seen an ad for a web developer stateing "Table-less layouts and CSS tips and tricks a must". Curiously, when I took a look at the source for their site there was one table specified.
Can anyone tell me the reason for not using tables?
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
Good question. Tables were at one time used to align parts of web pages, organize text and display data. But now, CSS makes the whole alignment process easier by using containers and alignments. Tables are to hard to manage, and the code for a table tends to get messy and hard to manage. Plus, you don't have nearly as much control over tables as you do style sheets, and they don't look very modern either, just a big block in the middle of your web page.
Besides, the purpose of HTML has changed over the years. It's mostly used now as just a shell for CSS, Javascript and all other web languages.
Another good reason for using CSS is, if you have an external Style Sheet, you can easily change the styles for table in several pages (for example, a menu). When otherwise you would have to go through each individual page and change the table.
|
|
|
|
|
Thanks for the information.
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
Tables are for displaying a matrix of information such as a database table or a spread sheet. They are very rigid, slow down page rendering and clutter your code. They are hard to maintain over time.
http://www.alistapart.com/articles/practicalcss/[^]
|
|
|
|
|
Thanks for the link.
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
Tables was used for layout at the time that there were no alternatives. It's a hack to do layout without any tools for layout. It was very useful at that time, but that time is not now.
The default behaviour of a table is to adapt itself to it's contents, and it was left up to each browser to figure out how to do it, which resulted in that each browser does it a little bit different. This behaviour that has to be defeated completely when using them for layout by specifying an exact size on all the cells, but people did put up with that because the benefit was that it was possible to do layout, and there weren't any alternatives around.
Today there are alternatives. You can use html to structure the information and css to do the layout. That allows you to separate the information from the presentation, which benefits load times, maintainence, search engine indexing and accessibility.
The table tag still has a purpose, of course, and that is it's original purpose; to make tables.
---
b { font-weight: normal; }
|
|
|
|
|
Sweet, sweet table making time!
|
|
|
|
|
Ahh... the nostalgia... Yes, there's where the table based layouts belong...
---
b { font-weight: normal; }
|
|
|
|
|
Guffa said; "The default behaviour of a table is to adapt itself to it's contents, and it was left up to each browser to figure out how to do it, which resulted in that each browser does it a little bit different"
Good point.
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
I've written a custom web combobox component that supports explict options in the web-page as one way of suppling choices for the drop-down list:
<cbo:ComboBox runat="server" id="ComboBox">
<asp:ListItem Value="1" Text="one" />
<asp:ListItem Value="2" Text="two" />
<asp:ListItem Value="3" Text="three" />
<asp:ListItem Value="4" Text="four" Selected />
</cbo:ComboBox>
Aestheticly, it would be much nicer, and easier for the users of my component, if the items could be defined as:
<cbo:ListItem Value="1" Text="one" />
How can I do this? Can custom web components be nested?
Thanks.
|
|
|
|