awesty

[quote author=fenway link=topic=100169.msg395265#msg395265 date=1152636794] That, or your query is failing... [/quote] yea, the code probably doesnt make any sense at all ::) i tried taking out the semi colon but it still had the same error. :( i think ill just try to learn how to use phpMyAdmin. ::)

that solved that problem. but now i am getting this message: [quote]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/awesty/domains/flashuser.frih.net/public_html/stuff/asd.php on line 46 [/quote] i should i do? thanks alot for all your help :)

so what is the point in using id's when you can only use them once when you could easily forget you have already used it and muck up ??? i alway use classes, but sometime use id's for no particular reason other than doing stuff differently :P

do you mean i should change mysql_selct to mysql_select_db? okay, im fairly new to this so i dont quite understand what you are saying. ??? thanks :)

[quote author=Daniel0 link=topic=99901.msg394290#msg394290 date=1152517740] Why are you posting this in the "PHP General" forum ??? [/quote] because flash portals are made with php :o i think you could probably be making more than $10. i am part of a few flash communitys and a portal does make a difference to the site :)

for everything other than php and sql i use dreamweaver 8, but since that doesnt like php i use notepad2. it colors the text for just about any coding language from html to actionscript :D

i have just started learning mySQL and i am getting this error :( [quote]Fatal error: Call to undefined function: mysql_select() in /home/awesty/domains/flashuser.frih.net/public_html/stuff/asd.php on line 42 [/quote] and this is the code i am using: [code]<?php $con = mysql_connect("localhost","awesty_data","********"); if(!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("awesty_data",$con); mysql_query("CREATE TABLE `persons` (`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`FirstName` VARCHAR( 15 ) NOT NULL ,`LastName` VARCHAR( 15 ) NOT NULL ,`Age` INT( 10 ) NOT NULL) ENGINE = MYISAM ;) or die(mysql_error()"); mysql_query("INSERT INTO `persons` (FirstName, LastName, Age) VALUES ('Peter', 'Griffen', '35')"); mysql_query("INSERT INTO `persons` (FirstName, LastName, Age) VALUES ('Glenn', 'Quagmire', '33')"); mysql_query("INSERT INTO 'persons' (FirstName, LastName, Age) VAlUES ('$_POST[firstname]', '$_POST[lastname]', '$_POST[age]')"); /*if (!mysql_query($isql, $con)) { die('Error: ' . mysql_query()); } echo "Success";*/ mysql_close(); ?> <?php $con = mysql_connect("localhost", "awesty_data", "*******"); if(!$con) { die('Could not connect: ' . mysql_error()); } mysql_select("awesty_data", $con); $result = mysql_query("SELECT * FROM persons"); while($row = mysql_fetch_array($result)); { echo $row['FirstName']; echo "<br />"; echo $row['LastName']; echo "<br />"; } ?>[/code] any help would be appreciated. thanks :)