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

t; At 16:35 -0500 15/9/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. > >

Can't fetch result twice in a PHP script

code. } 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: Inserting null values in mysql with PHP

check is to make sure you are not quoting 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 > >

Re: Inserting null values in mysql with PHP

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 insert values using phpMyAdmin, it sets

Inserting null values in mysql with PHP

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 Althou

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

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

Database design question

. -- -Mahmoud Badreddine

Re: Converting Integer values to date type

n <[EMAIL PROTECTED]> wrote: > In the last episode (Mar 18), 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 com

Converting Integer values to date type

he table. I also converted 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]

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

the condition is : for each row 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 --