Can't fetch result twice in a PHP script

. } The first time I call mysql_fetch_row , the code inside the while loop gets executed, but not the second time. What is the reason behind that. -- -Mahmoud Badreddine http://www.spreadfirefox.com/

Re: Can't fetch result twice in a PHP script

/07, Mahmoud Badreddine wrote: In one of my php scripts I make 2 successive calls of mysql_fetch_row using the same Mysql Result. In the first call the desired result is achieved, but in the second one it isn't. I have something like while($someArr=mysql_fetch_row($result)) { ...some code

Re: Inserting null values in mysql with PHP

script I do test if the values are empty and in case they are I set the variable to NULL. But that still doesn't help. Is that a mysql problem ? Thank you. -- -Mahmoud Badreddine http://www.spreadfirefox.com/ -- MySQL General Mailing List For list archives: http

Re: Inserting null values in mysql with PHP

your NULL value for your insert statement. MySQL will try to convert that to a numeric value, which may end up as 0. On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote: Hello I have a table which contain a few numerical values. I set the default values to be NULL. When I

Inserting null values in mysql with PHP

are empty and in case they are I set the variable to NULL. But that still doesn't help. Is that a mysql problem ? Thank you. -- -Mahmoud Badreddine http://www.spreadfirefox.com/

How to set table-specific privileges

Hello, I am trying to revoke all privileges from a user on a certain table in a database. I want the user to continue to have all his/her privileges intact for the other tables though. I used the statement REVOKE ALL PRIVILEGES on dbName.tableName from thisUser; But that doesn't seem to change

Problem with authentication

Hello to all I had an old MySQL 4.0 running on a Windows Machine. I removed that version and I installed the MySQL 5.0 . When I went to run phpMyAdmin this is the error I receive. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Field names truncated.

I recieved a database structure from a certain piece of software and I exported all the tables to MySQL, only to find out that the field names were cut short. How can I make sure that the field names is large enough to accomodate the longest field header? Thank you. -- -Mahmoud Badreddine http

Running a query on multiple databases

to accomplish this task. Thank you. -- -Mahmoud Badreddine

Database design question

. -- -Mahmoud Badreddine

Converting Integer values to date type

the integer values to varchar and that didn't help either. This is got to be simple to do. Thanks in advance. -- -Mahmoud Badreddine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Converting Integer values to date type

), Mahmoud Badreddine said: Hello, I have a table with separate integer values for the day, month and year. I would like to group them all under one field of type date. I tried a few commands but I haven't captured the right syntax yet. so if the field names are dayVal,monthVal and YearVal

copying of information into a table from another with conditions (using where)

in table2 with a certain value for ID1, find the matching value in table1for ID1. Then take the corresponding mainID value on that row and stick it in that row in table2. I hope that was enlightening rather than more confusing. -- -Mahmoud Badreddine -- MySQL General Mailing List For list archives