|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
04-16-2006, 06:04 PM
|
#1 |
|
Confirmed User
Join Date: Mar 2004
Posts: 455
|
MySQL question
i am displaying the contents of a database on my site..
now i would like to tell my script to only display data if the value of one of the rows is 1, and not 0. is that doable? thanks! 
__________________
’ |
|
|
|
04-16-2006, 06:04 PM
|
#2 |
|
Confirmed User
Join Date: Mar 2004
Posts: 455
|
to only display that entry if the value in the "approve" row is 1
__________________
’ |
|
|
|
|
04-16-2006, 06:06 PM
|
#3 |
|
So Fucking Banned
Join Date: Apr 2006
Posts: 181
|
select [fieldlist] from [tablename] where fieldname = 1
|
|
|
|
|
04-16-2006, 06:09 PM
|
#4 |
|
Confirmed User
Join Date: Mar 2004
Posts: 455
|
wow, that was easy
 thanks dude!
__________________
’ |
|
|
|
|
04-16-2006, 06:46 PM
|
#5 |
|
Confirmed User
Join Date: Mar 2004
Posts: 455
|
another question:
how do i display the total number of entries in a table? (e.g. 340)
__________________
’ |
|
|
|
|
04-16-2006, 06:50 PM
|
#6 |
|
Confirmed User
Join Date: Mar 2004
Posts: 455
|
figured it out!
__________________
’ |
|
|
|
