sqlnoob
-
Posts
173 -
Joined
-
Last visited
Everything posted by sqlnoob
-
yeah already tried that, no effect
-
For some odd reason this page: http://www.rymwurdboek.nl/rymwurden.php Appears to work in internet explorer, but not in firefox or chrome. I must have made an error somewhere in the html, because it is odd that the text field in the html form doesn't work in firefox, but it does in internet explorer. I also tried it with different meta's on the index page and different closing tags, but it has no effect. http://www.rymwurdboek.nl/index.php Here is the html code of the rymwurden.php page: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML> <HEAD> <TITLE>Rymwurdboek</TITLE> <META NAME="description" CONTENT="rymwurdboek"> <META NAME="keywords" CONTENT="rymwurdboek, sinteklaas"> <link rel="stylesheet" type="text/css" href="rymstyle.css"> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-19711869-1']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); </script> </HEAD> <BODY> <!--div pagina container--> <DIV class="paginabreed"> <H1>Rymwurdboek</H1> <!--div mainbox, html gedeelte--> <DIV class="mainbox"> <!--hier zijn advertenties aan de linkerkant--> <DIV class="linkeradvertentieblok"> <a href="http://www.friese-producten.nl" target="_blank"><img src="images/adv1.JPG" width="125" height="177" title="Friese-producten.nl" border="0"></a><br><br><br> <a href="http://www.hollandwebwinkel.nl" target="_blank"><img src="images/adv2.JPG" width="125" height="226" title="Friese pepernoten" border="0"></a> </DIV> <!--div html formulier--> <DIV class="htmform"> <P><A HREF="info.htm">Sjoch hijr foar mear informaasje oer ut rymwurdboek.</A></P> <P> In moai ferske makke? <BR>Mei it rymwurdboek giet dat hiel handich! </P> <!--VOORBIJ DEZE REGEL AFBLIJVEN--> <FORM action="index.php" method="post"> <P>Wurd: </P><input type="text" size="50" maxlength="50" name="rymwurd"> <input type="submit" value="Rymwurden Sykje"> </FORM> <!--VOORBIJ DEZE REGEL WEER VRIJ OM TE VERANDEREN--> </DIV> <!--hier zijn advertenties aan de rechterkant--> <DIV class="rechteradvertentieblok"> <a href="http://www.friestalig.nl"><img src="http://www.friestalig.nl/decemberfries.gif" border="0" target="_blank" title="KLIK HIER OM NAAR FRIESTALIG.NL TE GAAN" width="125" height="125"></a><br><br><br> <a href="http://www.snoepogram.nl" target="_blank"><img src="images/adv6.JPG" width="125" title="Snoepogram" border="0"></a><br><br><br> <a href="http://www.dietwa.nl/index.php?option=com_content&view=article&id=61&Itemid=37" target="_blank"><img src="images/adv3.JPG" width="125" height="125" title="Die Twa" border="0"></a><br><br><br> <a href="http://www.wurdboek.nl" target="_blank"><img src="images/adv7.JPG" title="Scheepsstoffering" width="125" border="0"></a> </DIV> <!--mainbox sluiting--> </DIV> <!--wurdbox opening--> <DIV class="wurdbox"> <DIV class="wurds"> <!--VOORBIJ DEZE REGEL AFBLIJVEN--> <!--VOORBIJ DEZE REGEL WEER VRIJ OM TE VERANDEREN--> <!--sluiting wurdbox--> </DIV> </DIV> <!--sluiting paginabreed div container--> </DIV> </BODY> </HTML>
-
might try that one too, see if it works and if it doesn't work I'm going to recommend another webhost instead of this crappy and frustrating ****
-
yeah it doesn't fetch an alias either, gives as much problems as no alias (I know it sounds silly) Just for clarity sake I initially wrote it with alias, when that didn't work I tried without it. [rant] I'm beginning to think there is something seriously wrong or weird with this webhost. Just out of curiosity, is it at all common to see the sql file when you upload with ftp? By the way never had this much difficulty obtaining the password and url to the phpadmin and I've got experience with like 5 other hosts, none of which are as tedious or difficult as this one. [/rant]
-
thanks! That's what I wanted to know. So the only other obvious answer is that the database table must be corrupted
-
I appreciate the fact that you're trying to help, but I really need to know what the proper way is to write the WHERE clause and echo the result. For instance, why is this wrong: $telresult = mysql_query("SELECT * FROM `hallofryslan_rhymewords` WHERE `word` ='$someword'"); $telrow = mysql_fetch_array($telresult); $telwurd = $telrow['word']; And how do I write that the correct way? Also what I meant with "that will get me nowhere" is because the LIKE causes difficulties in the later part of the script (it's really complicated bit that searches for words that rhyme) and remember there is like 416000 of those words (now I know that's a Gordian knot and I have solution for that). But I still need to know what the proper way is. Just one good example with a php variable would do.
-
that still will get me nowhere ^ remember the fetch has to be done on a php variable, not a mere LIKE alone I need the proper syntax for this: SELECT COUNT(word) FROM `hallofryslan_rhymewords` WHERE word ='$externalvariable' but anyhow thanks for making it apparent to me that the words in the tablecolumn word may be corrupted with spaces that may possible be at least 1 step in the good direction to solving this highly frustrating problem (damn just what I needed, spaces behind the words, this is may turn out to be one very crappy database (shouts in frustration, what more surprises will I get next, /me is most displeased))
-
in phpmyadmin: SELECT * FROM `hallofryslan_rhymewords` WHERE word ="Adam" empty result (would be 0 with count) SELECT * FROM `hallofryslan_rhymewords` WHERE word = Adam error 1054 Unknown column 'Adam' in 'where clause' SELECT * FROM `hallofryslan_rhymewords` WHERE word = 'Adam' empty result (would be 0 with count) SELECT * FROM `hallofryslan_rhymewords` WHERE id =31 result is id word 31 Adam (this list one is to show that the row does exist)
-
echoing won't help either OK here is a description of the problem: I have a table with 416000 words! The user posts a word. This word is what I want to count. (I want to check if it exists in the table) I test it with Adam (I know this word is in the table), yet the result is 0, but it should be 1.
-
$query = "SELECT COUNT(`word`) FROM `hallofryslan_rhymewords` WHERE `word` ='".$rymwurd."'"; if( $telresult = mysql_query($query) ) { $telrow = mysql_fetch_array($telresult); $telwurd = $telrow[COUNT(word)]; echo "<P>Aanwezig: ".$telwurd."</P>"; } else { echo "<br>Query $query<br>Produced error: " . mysql_error() . '<br>';} again doesn't work
-
$query = ("SELECT COUNT(`word`) FROM `hallofryslan_rhymewords` WHERE `word` ='".$rymwurd."'"); if( $telresult = mysql_query($query) ) { $telrow = mysql_fetch_array($telresult); $telwurd = $telrow[COUNT(word)]; echo "<P>Aanwezig: ".$telwurd."</P>"; } else { echo "<br>Query $query<br>Produced error: " . mysql_error() . '<br>';} nope still doesn't work sigh
-
$telresult = mysql_query("SELECT COUNT(`word`) FROM `hallofryslan_rhymewords` WHERE `word` ='".$rymwurd."'"); $telrow = mysql_fetch_array($telresult); $telwurd = $telrow[COUNT(word)]; another failed attempt HOW?
-
$telresult = mysql_query("SELECT COUNT(`word`) FROM `hallofryslan_rhymewords` WHERE `word` ='".$rymwurd."'"); $telrow = mysql_fetch_array($telresult); $telwurd = $telrow['COUNT(word)']; still doesn't work
-
gah i just want to fetch the damn row and it won't work
-
still doesn't work with closing `
-
$telresult = mysql_query("SELECT COUNT(`word`) FROM `hallofryslan_rhymewords` WHERE `word ='".$rymwurd."'"); $telrow = mysql_fetch_array($telresult); $telwurd = $telrow['COUNT(word)']; echo "<P>Aanwezig: ".$telwurd."</P>";` hi I've been trying for ages to find the proper syntax. Somehow this doesn't work. It counts 0 when I know the word exists in the table. Just how do I select a php variable? The variable is a word!
-
I think, I've found some strategies to this "Gordian knot", namely parallel queries, but I don't know how much time that will buy me.
-
Hi all! I have this question about performance and speed issues. I have this sql table containing 2 columns. The first column contains an id, and the second column a word. The entire table has about 416,500 words (apparently there are that many words in the Frisian language). I have constructed a simple sql query, with a WHERE clause and a LIKE clause that searches for a patron. The goal is to search for words that rhyme with a user inputted word (it could be any kind of word used in the Frisian language). This site is used to aide people who want to write Frisian poetry, Santa Claus poetry to be more specific. Now I have this php script that can detect which word actually rhymes, so that's not the problem. The real problem is that I worry about how long it will take for the script to loop through the sql table and find all the words that rhyme for instance with a word like "piet". How long will it take to fetch say 300 records with a while loop from a table containing about 400,000+ words? And if this takes a long time, are there ways to enhance performance? And if so how? By the way, I have yet to find out what kind of sql database they use. The boss apparently doesn't know and she's the only one I've spoken to. So it could be that I ask this question in the wrong subforum, and they're using a different sql dialect. If that is the case my apologies. Anyhow I asked it here assuming, it is mssql they're actually using (but I could be wrong). :-\
-
Microsoft acquires Skype - but what else do they own!!
sqlnoob replied to titan21's topic in Miscellaneous
awe man they acquired lionhead studios -
I see, well bad spider or no spider, its not of any use to me, so I'll keep it blocked for now.
-
hmmm a buggy spider perhaps so... though it keeps coming back on occasion and it doesn't identify itself as a search spider, like for instance google, yahoo, yandex or baidu I really wish to know what this is. Google isn't much of a help I'm afraid.
-
Not sure where to put this, as I can't find the appropriate forum for this, but here goes...... I found this in a URL, like for example: http://www.somesite/somedirectory/'+p+' in my error log Apparently someone or something from Germany thinks that is a page. If I look it up in google in combination with several variances of the url or parts of the url, a lot of Russian and Iranian sites pop up with references towards joomla. By the way for clarity sake, I don't use Joomla nor any rss feed, or any other php based CMS. Does anyone happen to know what it means? Is someone trying to make a sad attempt to hack into a rss-feed that doesn't exist? Or trying to abuse a deprecated function in php? Or trying to abuse a leak of joomla? Or is it something else? I decided to block this IP with htaccess just in case. Any help or directions would be much appreciated. I'm really curious to know what this is.
-
Hi all, I was wondering... I'm working on a project that involves a website with embedded mp3 files and this guy wants to play a short list of 2 MP3 files. Now I've made a small m3u list with notepad that contains 2 songs. I mean no problem there. Because most browsers recognise this, it works and the two files can be automatically played in the browser one after the other. But here is the catch, now I have to show the name of these song on the right side of the page. I know this can be done with flash, but can it be done with mere javascript? And if it can be done, how do you do it? Is there a way to fetch the filename of the embedded song that is currently playing from the playlist and show it on a html page or php page? I'm really lost with this and I've got no idea on how to do this, or whether it is even possible. So any help or answers you can give me is much appreciated.
-
a 100 more lines of code, are they all seperate issued lines, because then I think what you're looking for is a loop
-
so you're getting the values to change in the xml file?