 | | |||||
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.
Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
| ||||||||
| Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics. |
 |
 |
| | LinkBack | Thread Tools |
07-08-2006, 08:17 AM
| THREAD STARTER #1 (permalink) |
| Account Closed Join Date: Jul 2006
Posts: 81
   | Simple PHP help needed. <? $sql2 = "SELECT * FROM games WHERE visible = '1' ORDER BY RAND() LIMIT 4"; $result2 = mysql_query($sql2); while($row2 = mysql_fetch_array($result2)) { ?> I salvaged this code from my old site I had coded for me. So, if I bascially need something like the above but.. I need to do this. I have a users table which contains the fields artist1-10 and song1-10. I want to select the artists, randomly like the above and echo them out like this: Popular artists/bands. <?php echo " artist1 artist2 artist3 ?> etc, 8 times down, if anyone can do this for me, I'll buy some NP's in the next week and donate a few too you. EDIT: so basically inside my users table, i have usernames and then artist1-10 and song 1-10 for every username, i want to randomly select these artists and display them
Last edited by electricbeat; 07-08-2006 at 08:39 AM.
|
|
|
07-08-2006, 08:49 AM
| #2 (permalink) |
| Senior Member  Join Date: Sep 2005 Location: England
Posts: 1,034
| I'm assuming from the table structure you described that username is the first field, then artists are the next 10 fields, then songs are the next 10 fields. If not you will encounter errors with this. This will pick 8 usernames, and display the 10 artists/10 songs of each. ????: NamePros.com http://www.namepros.com/programming/214765-simple-php-help-needed.html Code: <?
$sql = "SELECT * FROM users WHERE ORDER BY RAND() LIMIT 8";
$result = mysql_query($sql);
if ($result) {
// This check is to make sure you made a succesful query before you continue
while($row = mysql_fetch_array($result2)) {
echo "Username: $row[0]<br>
Artist 1: $row[1]<br>
Artist 2: $row[2]<br>
Artist 3: $row[3]<br>
Artist 4: $row[4]<br>
Artist 5: $row[5]<br>
Artist 6: $row[6]<br>
Artist 7: $row[7]<br>
Artist 8: $row[8]<br>
Artist 9: $row[9]<br>
Artist 10: $row[10]<br>
Song 1: $row[11]<br>
Song 2: $row[12]<br>
Song 3: $row[13]<br>
Song 4: $row[14]<br>
Song 5: $row[15]<br>
Song 6: $row[16]<br>
Song 7: $row[17]<br>
Song 8: $row[18]<br>
Song 9: $row[19]<br>
Song 10: $row[20]<br><hr>";
} // End while
} else {
echo "The query wasn't successful.";
}
?> |
|
|
|
07-08-2006, 08:51 AM
| THREAD STARTER #3 (permalink) |
| Account Closed Join Date: Jul 2006
Posts: 81
| Sounds like that I needed, i'll just test it, thank you! The query was unsuccessful it replied with. Too give you a better idea of my db this is it. http://img89.imageshack.us/img89/793/png4ja.png So, this is inside users. I have duplicate entries because i was testing pagination and other things.
Last edited by electricbeat; 07-08-2006 at 08:56 AM.
|
|
|
|
07-08-2006, 09:02 AM
| #4 (permalink) |
| Senior Member Join Date: Sep 2005 Location: England
Posts: 1,034
| Oh ok, that makes things a little more awkward, but all it requires is some moving around of numbers. From the image i'm assuming from then on, it goes "artist3, song3, artist4, song4". Code: <?
// I've never seen this ORDER BY RAND() before, I hope it works for you...
$sql = "SELECT * FROM users ORDER BY RAND() LIMIT 8";
$result = mysql_query($sql);
if ($result) {
// This check is to make sure you made a succesful query before you continue
while($row = mysql_fetch_array($result)) {
echo "Username: $row[1]<br>
Artist 1: $row[5]<br>
Artist 2: $row[7]<br>
Artist 3: $row[9]<br>
Artist 4: $row[11]<br>
Artist 5: $row[13]<br>
Artist 6: $row[15]<br>
Artist 7: $row[17]<br>
Artist 8: $row[19]<br>
Artist 9: $row[21]<br>
Artist 10: $row[23]<br>
Song 1: $row[6]<br>
Song 2: $row[8]<br>
Song 3: $row[10]<br>
Song 4: $row[12]<br>
Song 5: $row[14]<br>
Song 6: $row[16]<br>
Song 7: $row[18]<br>
Song 8: $row[20]<br>
Song 9: $row[22]<br>
Song 10: $row[24]<br><hr>";
} // End while
} else {
echo "The query wasn't successful.";
}
?>
Last edited by Shorty; 07-08-2006 at 09:23 AM.
|
|
|
|
07-08-2006, 09:16 AM
| #6 (permalink) |
| I'll do it   Join Date: Dec 2005 Location: India
Posts: 6,927
   | PHP Code:
__________________ |
|
|
|
07-08-2006, 09:24 AM
| THREAD STARTER #8 (permalink) | ||||
| Account Closed Join Date: Jul 2006
Posts: 81
|
| ||||
|
|
|
07-09-2006, 05:44 AM
| THREAD STARTER #16 (permalink) |
| Account Closed Join Date: Jul 2006
Posts: 81
| I'm needing more help again  PHP Code: |
|
|
|
07-09-2006, 05:51 AM
| #17 (permalink) |
| Senior Member Join Date: Sep 2005 Location: England
Posts: 1,034
| Code: if (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,6})", $email)) {
// The email isnt ok, print an error message
} else {
// The email is fine, so carry on
// And this last bracket goes at the end of your script
} |
|
|
|
07-09-2006, 05:52 AM
| #18 (permalink) |
| NamePros Regular  Join Date: Jun 2006 Location: Sydney
Posts: 251
| ([_\.0-9a-z-]+@) ([_\.0-9a-z-]+)@ try chaning that
__________________ Site Armory, tools for your website | Webmaster SEO Forums | PHP Tutorial and coding forums |
|
|
|
07-09-2006, 06:09 AM
| THREAD STARTER #19 (permalink) |
| Account Closed Join Date: Jul 2006
Posts: 81
| My friend gave me this: PHP Code: |
|
|
|
07-09-2006, 08:57 AM
| #20 (permalink) |
| NamePros Member  Join Date: Apr 2006
Posts: 186
| Just a tip, you should really indent your code. It's kind of hard to follow your code when there's no indentation.... can't tell where if...else statements start and end. As far as your issue, in the code you just posted that your friend gave you, he created a variable "$bIsValid" - it's set to false if the email address isn't valid. So just before issuing your registration query, just do an if block Code: if ($bIsValid == true) {
...
}
__________________ |
|
|
