Maq

In the future, please use tags around your code.

Oh yeah sorry. I don't think you want to use a COUNT or num_rows function here. You would either want to use a variable that increments its value in the loop or the user_id from your table.

You already have the number of rows held in a separate variables ($num_rows). Change: echo $rows['num_rows']; ?> to

I'm not sure what you mean. Are these names in a file or database? Do you want to extract these names and put them in a file? If you want to extract the female names from the database then you would just do a simple select query with a condition to check for female.

Dj Kat - Please take a look at this thread: http://www.phpfreaks.com/forums/index.php?topic=325648.0 The some of bb codes along with many other features have been lost due to the forum upgrade. Please address them there (I think the one you posted has already been mentioned).

This topic has been moved to JavaScript Help. http://www.phpfreaks.com/forums/index.php?topic=328645.0

Post your query with the attempted left join.

You can use - http://us3.php.net/mysql_num_rows - on the $result to check.

I think creating an XML file for this and using XSL would be much more maintainable and efficient. As long as the file is valid XML then you can parse it with something like SimpleXML in PHP or use an XSL sheet. Here are a few helpful links: http://cowburn.info/2009/10/23/php-funcs-xpath/ http://us.php.net/simplexml

Is it possible to add the code in as XML. That way, you could use XSLT to easily extract/add information.

Check the time as well in your query. If you get a result back then that time is taken on that day.

Why don't you just check it within the query?

Hi Chris, welcome to the community!

Hi, welcome! What happened?

To sort by key you would use ksort.

This topic has been moved to PHP Regex. http://www.phpfreaks.com/forums/index.php?topic=328353.0

This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=328375.0

Yes it is. OP, you should avoid using reserved words as table names. Here is a list: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

The XSL sheet will parse and transform the XML document by setting up match rules. What exactly are you having trouble with? The actual code or setting it up?

Please, use the tags in the future.

Sure it's possible, but why would you want to do that? If you want help, then provide an example and some relevant code.

Please use the tags in the future.

http://dev.mysql.com/doc/refman/5.0/en/user-variables.html

This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=328221.0

This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=327525.0