Maurice

Hi all,just one small question. How can I block MySQL from inserting empty records in a table?Thanks very much. Maurice

Never mind, I inserted the incorrect name for the database in the code, however thanks all!

Hi all,currently I'm trying to create a simple mySQL database. Using the tutorials iver here I've come pretty far. Now I have a question.The following code (can be find on http://w3schools.com/php/php_mysql_select.asp ) gives me the error that the mysql_fetch_array() doesn't excist or is invalid. In the $result there can be found:$result = mysql_query("SELECT * FROM leden"); while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['FirstName'] . "</td>"; echo "<td>" . $row['LastName'] . "</td>"; echo "</tr>"; } Could somebody help me out on this, so I can read out the information from the 'leden' table? I think the error is the $row, so does the error from mysql thinks, but I don't know how to fix this. Complete code (copied from w3schools): <?php$con = mysql_connect("localhost","******","******");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("leden__DB__test", $con);$result = mysql_query("SELECT * FROM leden");echo "<table border='1'><tr><th>Voornaam</th><th>Achternaam</th></tr>";while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['voornaam'] . "</td>"; echo "<td>" . $row['achternaam'] . "</td>"; echo "</tr>"; }echo "</table>";mysql_close($con);?> and the table 'leden' looks like this:-------------------------------| voornaam | achternaam ||-------------|---------------||Maurice | Krielaart ||Admin | Admin |-------------------------------Hope somebody can help me getting the data from the table into the browser page.Thanks in advanceMaurice Krielaart

Never mind, found my answer after trying and trying The best way (in some cases) to learn,Cheers,Maurice

Hi all,first of all thanks for all help received so far, it really helped me out of some nasty things. Now I have one more question, which I can't find the answer of.In my actionscript, I have a variable (number) created inside a function. Then I have another function, where I need that variable again. I thought this was no problem, but it seems that ActionScript can't read out variables created inside one function into another. Again, this variable is a number.1) Is there a 'special' trick how I can read the variable from one function into another? Then one small question related to this, does a function inside a function is allowed? So like: button_btn.onPress = function() { *** button2_btn.onPress = function() { *** }}

Hello all,just a small question I think, but I have a problem that I can't solve. I'm using Flash 8 Pro, and wish to set for a input field a alpha background of 20.This is what I have now:input_txt.border = true;input_txt.background = true;input_txt.backgroundColor = 0x33CCCC;input_txt._alpha = 20;Where input_txt is the instance name of the input field.But when playing this "movie" I just get a standard 0x33CCCC color, instead of that color a bit faded with _alpha.What am I doing wrong?Thanks in advance,Maurice Krielaart

Hi all,I'm Maurice and new to W3Schools forum, though I allready learned much with the help of w3schools.com.Now I have a question. Is it possible to print the tutorials found at w3schools? For example, I 'wanna' learn ASP, but was hoping that the tutorial is printeble, so I don't need to switch screens etcetra all the time, and also be able to check things when not connected to the internet.Thanks for help, and great job you're doing over there!Maurice Krielaart