Probably a beginners error but...

Recent blog posts:

How to make a Christmas photo…
Every Christmas people take a off from their busy schedule. This is the time they can enjoy with their…

Car web design, motorbike…
If you are looking for Car website design, Auto web design, bike web design, or anything similar our…

The Best Video Converter-a…
iOrgSoft Inc. has released the powerful Video Converter - iOrgSoft Video Converter 1.6.0, the latest…

Photo DVD Maker New Website…
AnvSoft Inc., the multimedia software developer, unveils a new website…

How to rip DVD movie, convert…
It is no doubt that PSP is an excellent game player. However, it is not playing games all the time; you…

World’s Most Unusual Christmas…
This Christmas, don’t go with that ho-hum, run-of-the-tree-farm tree your family always gets…

Facebook account cracker
facebook account cracker (50 GBP) Before you're told what this tool does, it's worth noting that…

BlackBerry Storm review…
As BlackBerry fans, you can’t miss the BlackBerry Storm. At Nov 6th, 2008, the word on the street is…

Review on Any DVD Cloner
Have you ever had a DVD Movie collection broken or lost? Have you ever wanted to backup movies but…

All recruitment agencys come…
What is RCCSS? RCCSS is a new unique peice of software which will scan millions of major sites and…

They have birthday today:

akram mellice

Daffy little vampire

все >>

Forums:

topic feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

[EJB 3.0] - PersistenceContext…
I have tried to inject a PersistenceContext into a JSF managed bean POJO as is outlined here. The…

[JBoss jBPM] - Re…
Raj, as I just stated in the other thread you will have to lock on processInstance. What seems to be…

Passing LARGE (1500-2500 chars)…
I want to pass a large (easily 1500-2500 characters) variable between a DHTML object using Jscript over…

Rebuild trailer not found…
Hi, in an application that read information from an Oracle database and create a PDF I get this error…

Recent forum topics:

IBM Application Server Crash…
Hi, I was wondering if you someone can provide some guidance as to the maximum allowable heap size for…

Rakudo bug reports still go to…
Some of you may have seen the announcements on the Parrot lists that Parrot will be starting to use…

Stop sql Injection attacks and…
HI there, not long ago I found a website explaining a feature of a dbi-addon (or catalyst-addon) which…

Recent forum comments:

RE: IBM Application Server Crash…
…

RE: [JCA/JBoss] - getOutputStream()…
Put Your Java Code in Servlet. It will work fine Try to avoid scriplet in jsp

RE: how to retrieve CheckBox value…
Old Pedant wrote: This seems to contradict your earlier argument that Request("foo") is the…

RE: how to retrieve CheckBox value…
"magix" <magix@asia.com> wrote in message news:48ad9aed$1_2@news.tm.net.my…

RE: how to retrieve CheckBox value…
"Old Pedant" <OldPedant@discussions.microsoft.com> wrote in message…

RE: how to retrieve CheckBox value…
"Bob Barrows " wrote: LOL! But it *IS* precise...if you know what you are doing…

RE: how to retrieve CheckBox value…
Old Pedant wrote: Perhaps not, but I would suggest you do so. I'm surprised a pedant would advise…

RE: how to retrieve CheckBox value…
"magix" wrote: Other answers right, but more complex than needed. Just do this: <%…

RE: RE: Please Help Advanse Search…
Old Pedant wrote: ******************* ... unless navigation in the recordset has occurred, or…

RE: ASP Page Counter
"Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message…

Moderators:

Administrator
Protorioris


Probably a beginners error but...
Jari Ivanoff 2 October 2000 00:53:29
	.. since I am a beginner... I am creating a php script that is getting some data from a MySQL database and print out the data: <?php $db = mysql_connect("localhost","root"); mysql_select_db("news",$db); $result = mysql_query("select * from news",$db); printf("Datum: %s <br>\n", mysql_result($result,0,"datum"); printf("Klockslag: %s <br>\n", mysql_result($result,0,"tid"); printf("Rubrik: %s <br>\n", mysql_result($result,0,"rubrik"); printf("InnehГҐll: %s <br>\n", mysql_result($result,0,"innehall"); ?> I get this error message in my browser: Parse error: parse error in c:\apache\htdocs\newsout.php on line 8 I get the same error message on every single one of the printf lines. Sorry about that some of the words are in swedish.. /Jari
		Add comment


Matt 2 October 2000 00:53:29 [ permanent link ]
	you cannot just output directly from the query, I assume you want to either loop through a list or rows that you retrieved or that you just have one row. Either way you need to run a $thisrow = mySQL_fetch_row($result). The current row is then set in the array $thisrow and you can access each column thusly: $thisrow[0] $thisrow[1] ... hope that this helps. If you want to loop through each row then just put it in a while loop like this: while($thisrow = mySQL_fetch_row($result)) { ...your code... } Take a look at this page for all the avaliable PHP commands that deal with mySQL: http://php.net/manual/ref.mysql.php --Matt ----- Original Message ----- From: "Jari Ivanoff" <jari.ivanoff@telia.com> To: "PHP" <php-general@lists.php.net> Sent: Sunday, October 01, 2000 4:42 PM Subject: [PHP] Probably a beginners error but... .. since I am a beginner... > I am creating a php script that is getting some data from a MySQL database> and print out the data:> <?php> $db = mysql_connect("localhost","root");> mysql_select_db("news",$db);> $result = mysql_query("select * from news",$db);> printf("Datum: %s <br>\n", mysql_result($result,0,"datum");> printf("Klockslag: %s <br>\n", mysql_result($result,0,"tid");> printf("Rubrik: %s <br>\n", mysql_result($result,0,"rubrik");> printf("InnehГҐll: %s <br>\n", mysql_result($result,0,"innehall");> ?>> I get this error message in my browser:> Parse error: parse error in c:\apache\htdocs\newsout.php on line 8> I get the same error message on every single one of the printf lines.> Sorry about that some of the words are in swedish..> /Jari> --> PHP General Mailing List (http://www.php.net/)> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net> For additional commands, e-mail: php-general-help@lists.php.net> To contact the list administrators, e-mail: php-list-admin@lists.php.net>
		Add comment




Get comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

	see also: frontpage extensions and where are they… In Publisher 2002, is it possible to… Can Publisher save the file name…		пройди тесты:		see also: Hi, everyone!!! About ...

Probably a beginners error but...

Add new comment