WHAT DO YOU WANT?

[Belgian_Pilot]

No, the error is related to the db. It fails retreving data info.

This is the problem:

$f1=mysql_result($result,$i,"field1");

It can't find field1. What is field1

 

[wwjd_kilden]

I don't know .. like I said, that was a very random attempt cutting and gluing

I think the colored code is more likely to fit

 

[Belgian_Pilot]

You don't know??? What value do you wan't to retreve from the db then? You tell it to retreve "field1". It tells you it doesn't know what field1 is. Computers are nice

 

[wwjd_kilden]

I'm sleeeeeeeeeepy, my brain barely works when I'm awake

SQl on it's own is OK, when it is in the middle of other codes I loose track of that I'm doing
trying to debug the other code now

ed: now at least in prints the headers...

<?php
define("SERVER", "localhost:3306");
define ("BRUKERNAVN", "webuser");
define ("PASSORD", "pass_123");
define ("DATABASENAVN", "temp_inf200");
/* setter KONSTANTER istedenfor variabler*/
?>
<?php
/*
Tilkobling
*/
$db_ref = @mysql_connect( SERVER, BRUKERNAVN, PASSORD );
if( !$db_ref )
die( "Klarte ikke å koble til databaseserveren" );

if( !@mysql_select_db( DATABASENAVN, $db_ref ) )
die( "Klarte ikke å velge angitt database" );

$query = "select fornavn, etternavn from Bruker";
$resultat = @mysql_query( mysql_real_escape_string( $query ) );
if( !$resultat )
die( "Spørring feilet" );
?>
<table id="resultat" class="res_tabell" cellspacing="0">
<tr>
<th>
Fornavn
</th>

<th>
Etternavn
</th>
</tr>
<?php
/*
Gå gjennom resultatsettet rad for rad
*/
while( $row = mysql_fetch_array( $resultat ) )
{
echo "<tr>";
echo "<td>";
echo $row['fornavn'];
echo "</td>";

echo "<td>";
echo $row['etternavn'];
echo "</td>";
echo "</tr>";
}

mysql_close( $db_ref );
?>
</table>

 

[christiancollegegirl]

This page and the previous made absolutely no sense to me whatsoever.

 

[wwjd_kilden]

atm it isn't making horrilly much sense to me either, but it's a way of connecting to and getting info from a database (you upload info from it onto a web page or elsewhere)

 

[Belgian_Pilot]

The problem for is that this is PHP stuff. I work with ASP.net.

Try this tutorial:

PHP/MySQL Tutorial - Part 4

 

[wwjd_kilden]

thanks, I'll have a look at it

 

[ilovehillsong]

I want...to not have to do work on a bank holiday weekend!

 

[wwjd_kilden]

awwww

I want the guy on my group to stop complaining that my sql output looks "very little professional!" -,-
what does he expect?! (and he seemingly can't even do what I did, so he sure aint the right person to complain)

 

[Belgian_Pilot]

How is it now with the php/sql/html problem?

 

[wwjd_kilden]

well, now at least it gives me output

Program utkast 1

just needs some tidying

 

[Belgian_Pilot]

Looks good

 

[wwjd_kilden]

I hope I can make it a bit tidier though... it looks a bit odd with the spaces


... I want... dunno why but I want a hug

 

[christiancollegegirl]

*hugs for Astrid*

 

[Belgian_Pilot]

(- Hugs Astrid -)

Tonight I'm gonna hug Sarah

 

[wwjd_kilden]

thanks guys

 

[Belgian_Pilot]

She's coming at 16h. Yaay

 

[wwjd_kilden]

^^

..aw, I was gonna post a song you should play for her, but I don't think it's on youtube

 

[Belgian_Pilot]

It isn't? Most songs are somewhere on youtube...