[RESOLVED] error in php for mysql data extract

big-dog

What is wrong with this at line 15 ( } else { ) error out.
Im trying to pull data from database and display on page. It all worked till I added the if( . Also I need some idea about how to keep this output sheet a little more current. What I mean by this is the current code desplays by Race_date desc, How would I get it to remove anything older than say 2 weeks.

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT First_Name, First_Class, Second_Class, Race_Date FROM Registration ORDER BY Race_Date DESC";
$result=mysql_query($query);

$num=mysql_numrows($result);

if ($num==0) {
echo "There are no Drivers Registered Yet";
} else {
Output Loop
}

mysql_close();

bretticus

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT First_Name, First_Class, Second_Class, Race_Date FROM Registration ORDER BY Race_Date DESC";
$result=mysql_query($query);

$num=mysql_numrows($result);

if ($num==0) {
echo "There are no Drivers Registered Yet";
} else {
Output Loop
}

mysql_close();

Dos your code seriously have "Output Loop" in it like that?

big-dog

I guess so. I trying to learn newbie😕
any help would be great.

bretticus

big-dog wrote:
I guess so. I trying to learn newbie😕
any help would be great.

First of all, I think it's great you are learning PHP. I honestly thought that the "Output Loop" part might be just pseudo code for abbreviation. Now I realize you are just very new to PHP...and that's ok, we are were at one time. I surely don't want to be discouraging in anyway. Furthermore, I'll assume that the bulk of that code came from someone else and the "Output Loop" part certainly was pseudo code. I'll bet you get an error message like "Parse error: syntax error, unexpected T_STRING" or something similar, perhaps? That's because "Output Loop" is not a function or proper syntax in PHP. The original author just abbreviated. When in doubt, the PHP Manual is your best resource.

bretticus

To drill down a little further, notice the while loop in this example

bretticus

Oh and one more thing, in this part of the MySQL Manual, the first example will should you how to get recent records only.

big-dog

I found a website that has tutoreals for beginners. kind of a step by step. every thing was going good I thought till now. It gets discuraging when you think your following along pretty good and then :eek: and you try to figure it out for hours and still nothing. I glanced at the sql link and if I can figure out😕 what to do with that info ill be happy.

bretticus

I'm sure you are doing just fine. Once the fundamentals sink in, you'll be surprised about how much you can accomplish. Don't get discouraged, just keep at it.

Oh, and by the way, no, I didn't just drop some example code down, but I do promise all the code and examples you need are in those links I posted. Basically, where you had the infamous "Output Loop", you need to use a while loop with one of the mysql fetch functions: mysql_fetch_row(), mysql_fetch_array(), mysql_fetch_assoc() to display your information like:

while($row=mysql_fetch_assoc($result)) {
       echo $row['First_Name'];
       //...and so on...
   }

big-dog

I just delete the Output Loop out and it seems to work again. I went into the database and deleted all records ran the php and it said no drivers reg. then I added a record and it didnt show that message it showed the drives name class and date.

using the code Im using is that not good.
Im kind of following it. Im afraid if I get off on other ways Ill really be confused trying to do it a step at a time and see the results so I understand.